Google Sheets Spreadsheets
Use this skill to create a spreadsheet, inspect its structure, read a range, append rows, or update cell values.
When to use
-
create a new spreadsheet
-
inspect sheet names and spreadsheet metadata
-
read values from a range
-
append rows to a range
-
update a fixed range with new values
Authentication
This skill uses the connected google-sheets provider credential for the current agent.
Invocation
Call through Shift's Skill Router:
curl -X POST "$SHIFT_LOCAL_GATEWAY/skill-router/invoke"
-H "Content-Type: application/json"
-d '{
"skillProvider": "google-sheets",
"skill": "spreadsheets",
"action": "read-range",
"input": {
"spreadsheetId": "SPREADSHEET_ID",
"range": "Sheet1!A1:C10"
}
}'
Examples
Create a spreadsheet:
{ "skillProvider": "google-sheets", "skill": "spreadsheets", "action": "create", "input": { "title": "Launch Tracker" } }
Get spreadsheet metadata:
{ "skillProvider": "google-sheets", "skill": "spreadsheets", "action": "get", "input": { "spreadsheetId": "SPREADSHEET_ID" } }
Read a range:
{ "skillProvider": "google-sheets", "skill": "spreadsheets", "action": "read-range", "input": { "spreadsheetId": "SPREADSHEET_ID", "range": "Sheet1!A1:C10" } }
Append values:
{ "skillProvider": "google-sheets", "skill": "spreadsheets", "action": "append-values", "input": { "spreadsheetId": "SPREADSHEET_ID", "range": "Sheet1!A:C", "values": [["2026-03-13", "Launch", "On track"]], "valueInputOption": "USER_ENTERED" } }
Update a range:
{ "skillProvider": "google-sheets", "skill": "spreadsheets", "action": "update-values", "input": { "spreadsheetId": "SPREADSHEET_ID", "range": "Sheet1!B2:C3", "values": [["Owner", "Status"], ["Wei", "Ready"]], "valueInputOption": "USER_ENTERED" } }