google-sheets
Read and write Google Sheets data. Create spreadsheets, update cells, and manage worksheets via Sheets API.
来源信息
- 仓库
- ThinkfleetAI/thinkfleet-engine
- 最近来源活动
- 2026年2月1日 16:21
- 检测到的 SKILL.md 语言
- 英语
- 星标
- 0
- Forks
- 0
安装方式
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
检查来源文件
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
正在显示 SKILL.md
SKILL.md
来源说明 · 只读预览- name
- google-sheets
- description
- Read and write Google Sheets data. Create spreadsheets, update cells, and manage worksheets via Sheets API.
- metadata
- {"thinkfleetbot":{"emoji":"📊","requires":{"env":"[Truncated]"}}}
# Google Sheets
Spreadsheet automation.
## Environment
```bash
export GOOGLE_ACCESS_TOKEN="ya29.xxxxxxxxxx"
```
## Read Sheet Data
```bash
curl "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/Sheet1!A1:D10" \
-H "Authorization: Bearer $GOOGLE_ACCESS_TOKEN"
```
## Write to Cells
```bash
curl -X PUT "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/Sheet1!A1:B2?valueInputOption=USER_ENTERED" \
-H "Authorization: Bearer $GOOGLE_ACCESS_TOKEN" \
-H "Content-Type: application/json" \
-d '{"values": [["Name", "Score"], ["Alice", 95]]}'
```
## Append Rows
```bash
curl -X POST "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/Sheet1!A:D:append?valueInputOption=USER_ENTERED" \
-H "Authorization: Bearer $GOOGLE_ACCESS_TOKEN" \
-H "Content-Type: application/json" \
-d '{"values": [["New", "Row", "Data", "Here"]]}'
```
## Create Spreadsheet
```bash
curl -X POST "https://sheets.googleapis.com/v4/spreadsheets" \
-H "Authorization: Bearer $GOOGLE_ACCESS_TOKEN" \
-H "Content-Type: application/json" \
-d '{"properties": {"title": "My New Sheet"}}'
```
## Get Spreadsheet Metadata
```bash
curl "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}" \
-H "Authorization: Bearer $GOOGLE_ACCESS_TOKEN"
```
## Clear Range
```bash
curl -X POST "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/Sheet1!A1:Z100:clear" \
-H "Authorization: Bearer $GOOGLE_ACCESS_TOKEN"
```
## Links
- Console: https://console.cloud.google.com/apis/library/sheets.googleapis.com
- Docs: https://developers.google.com/sheets/api/reference/rest
在 GitHub 查看