Google Sheets

read_rows

Read a range of cells.

Request body:

{
  "user_id": "...",
  "action": "read_rows",
  "payload": { "spreadsheetId": "1BxiMV...", "range": "Sheet1!A1:C10" },
  "target_app": "sheets"
}

provider_response.result shape:

{ "values": [["Name","Email"],["Ada","ada@example.com"]] }

append_row

Append a new row after the last row of data.

Request body:

{
  "user_id": "...",
  "action": "append_row",
  "payload": { "spreadsheetId": "1BxiMV...", "range": "Sheet1!A:C", "values": ["Ada", "ada@example.com", "New"] },
  "target_app": "sheets"
}

provider_response.result shape:

{ "updates": { "updatedRange": "Sheet1!A5:C5" } }

update_range

Overwrite a specific range.

Request body:

{
  "user_id": "...",
  "action": "update_range",
  "payload": { "spreadsheetId": "1BxiMV...", "range": "Sheet1!A2:C2", "values": ["Ada", "ada@example.com", "Updated"] },
  "target_app": "sheets"
}

provider_response.result shape:

{ "updatedRange": "Sheet1!A2:C2" }

clear_range

Clear a range without deleting the rows/columns.

Request body:

{
  "user_id": "...",
  "action": "clear_range",
  "payload": { "spreadsheetId": "1BxiMV...", "range": "Sheet1!A2:C2" },
  "target_app": "sheets"
}

provider_response.result shape:

{ "clearedRange": "Sheet1!A2:C2" }

403 "The caller does not have permission"

Cause: The spreadsheet isn't accessible to the connected Google account (owned by someone else, not shared).

Fix: Share the spreadsheet with the connected Google account, or use a spreadsheet that account owns.

400 "Unable to parse range"

Cause: range string is malformed — must be A1 notation like Sheet1!A1:C10.

Fix: Match the exact tab name (case-sensitive) followed by !, then the cell range.