Google Sheets
Read, append, and update rows of your Google spreadsheets.
Connect your Google account - the integration acts as you, and reaches exactly the spreadsheets you can. Each call names its spreadsheet, or falls back to the connection's default.
Connect
Sign in with Google. Sign in with Google to read and write your spreadsheets. An organization admin configures the OAuth app once under Integrations → OAuth apps; after that, connecting is a consent screen.
-
Connecting signs in as YOU - the integration sees exactly the spreadsheets your Google account can, with no sharing step.
-
Each call names its own spreadsheet; the connection's Spreadsheet ID is an optional default. Ranges use A1 notation like “
Sheet1!A1:C10”.
| Setting | Required | What it is |
|---|---|---|
Spreadsheet ID (SPREADSHEET_ID) | No | Optional default for calls that name no spreadsheet. From the sheet's URL: docs.google.com/spreadsheets/d/<THIS>/edit |
Tools
| Tool | Access | What it does |
|---|---|---|
List sheets (yekar.google-sheets.list-sheets) | Read | Spreadsheet title and its sheet tabs (name, id, size) - call first to learn valid range prefixes |
Read range (yekar.google-sheets.read-range) | Read | Read cell values from an A1-notation range of a spreadsheet |
Append rows (yekar.google-sheets.append-rows) | Write | Append rows after the last data row of a sheet/range (values written literally, never as formulas). NOT idempotent: a retried append adds the rows again, so after an interruption the run fails rather than risk duplicates. Use Update range for a fixed, recovery-safe target. |
Update range (yekar.google-sheets.update-range) | Write | Overwrite the cells of an A1-notation range (values written literally, never as formulas; idempotent - rewriting the same range with the same values re-runs safely) |
Notes
- Sign in with Google to connect - tools act as your Google account, so no sharing step is needed.
- Every tool takes an optional
spreadsheet(its id, or a pasted docs.google.com/spreadsheets URL), so one connection reaches every sheet the account can. - Setting the Spreadsheet ID property makes it the default for calls that name none - leave it empty to require one per call.
- Ranges use A1 notation like “
Sheet1!A1:C10”; call List sheets first to learn the valid tab names.