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
- 포크
- 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에서 보기