Skip to main content

Google Sheets

Read, write, and append data in Google Sheets via the Google Sheets API. Ideal for data analyst agents, reporting, and lightweight database use cases.
Requires the googleapis peer dependency and Google OAuth2 credentials.

Quick Start


Config

string
Path to Google OAuth2 credentials JSON file. Falls back to GOOGLE_SHEETS_CREDENTIALS_PATH env var.
string
Path to stored OAuth2 token. Falls back to GOOGLE_SHEETS_TOKEN_PATH env var.
string
Default spreadsheet ID (from the URL). Falls back to GOOGLE_SHEETS_SPREADSHEET_ID env var. Can be overridden per-call.

Tools


Peer Dependency


Environment Variables