google-sheets
Read and write Google Sheets data. Create spreadsheets, update cells, and manage worksheets via Sheets API.
Informations de source
- Dépôt
- ThinkfleetAI/thinkfleet-engine
- Dernière activité de la source
- 1 février 2026 à 16:21
- Langue détectée de SKILL.md
- anglais
- Étoiles
- 0
- Forks
- 0
Options d'installation
Le prompt qui vérifie d'abord la source est sélectionné par défaut. Vous pouvez passer à une commande directe ou télécharger une copie locale.
Vérifiez les fichiers source
Lisez SKILL.md et les fichiers associés affichés par SkillsMP avant de décider de l'installer.
Affichage de SKILL.md
SKILL.md
Instructions source · Aperçu en lecture seule- 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
Voir sur GitHub