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"
  }
}