Google Sheets

Read and write spreadsheet data, manage sheets.

Install

amodal connect google-sheets

Authentication

OAuth 2.0 Bearer token.

• GOOGLE_SHEETS_TOKEN — OAuth token with https://www.googleapis.com/auth/spreadsheets scope

For read-only access, the spreadsheets.readonly scope is sufficient. Service account credentials can also be used for server-to-server access. Tokens expire after 1 hour.

Endpoints

Read

• GET /v4/spreadsheets/:spreadsheetId — Get spreadsheet metadata
• GET /v4/spreadsheets/:spreadsheetId/values/:range — Read cell values
• GET /v4/spreadsheets/:spreadsheetId/values:batchGet — Read multiple ranges

Write

• PUT /v4/spreadsheets/:spreadsheetId/values/:range — Write cell values (confirmation)
• POST /v4/spreadsheets/:spreadsheetId/values/:range:append — Append rows (confirmation)
• POST /v4/spreadsheets/:spreadsheetId/values:batchUpdate — Batch write values (confirmation)
• POST /v4/spreadsheets/:spreadsheetId/values:batchClear — Clear multiple ranges (confirmation)

Management

• POST /v4/spreadsheets/:spreadsheetId:batchUpdate — Batch spreadsheet updates (confirmation)
• POST /v4/spreadsheets — Create spreadsheet
• POST /v4/spreadsheets/:spreadsheetId/sheets:copyTo — Copy sheet to another spreadsheet

Entities

• spreadsheet

Rules

• Rate limits: 60 read and 60 write requests per minute per user; 300 requests per minute per project — prefer batching over individual calls
• Ranges use A1 notation: SheetName!A1:D10 (sheet names with spaces need single quotes: 'Sheet Name'!A1:D10)
• Use valueInputOption=USER_ENTERED for formulas, RAW for data imports
• Reading an empty range returns no values field (not an empty array), and rows may be ragged (trailing empty cells omitted)