The catalogue/Google Sheets
Google Sheets
app.google.sheets
Create, read, write, format, and export Google Sheets spreadsheets
What it does
The app, in its own words.
Create, read, write, append, format, and export Google Sheets spreadsheets - create, write data, append rows, batch update (formatting, formulas, conditional formatting), read data, ranges, list tabs, export to CSV/XLSX/PDF. To delete a spreadsheet, use the Google Drive app.
Tools
14 tools the agent can call.
Every one is declared with typed parameters and returns structured results, so the host can render them instead of narrating them.
- add-sheetAdd a new sheet (tab) to an existing Google Spreadsheet. Returns the new sheet ID and properties.
- append-valuesAppend rows of data to the end of a sheet in a Google Spreadsheet. Finds the last row with data and appends below it. Supports formulas (strings starting with =).
- batch-updateExecute advanced operations on a Google Spreadsheet using the Sheets API batchUpdate endpoint. Supports: adding/deleting/renaming sheets, cell formatting (bold, colors, borders, number format), conditional formatting, formulas, frozen rows/columns, data validation, protected ranges, and more. Pass an array of request objects following the Google Sheets API batchUpdate schema.
- batch-update-valuesUpdate multiple ranges of values in a Google Sheet in a single request. More efficient than calling write-values multiple times.
- clear-valuesClear all values from a range of cells in a Google Sheet. Only clears values, not formatting.
- copy-sheetCopy a sheet (tab) from one Google Spreadsheet to another. Returns the new sheet ID and title in the destination spreadsheet.
- create-spreadsheetCreate a new Google Spreadsheet with a title and optional initial data. Returns the spreadsheet ID and URL.
- delete-sheetDelete a sheet (tab) from a Google Spreadsheet by its sheet ID. Use list-sheet-tabs to find the sheet ID.
- export-sheetExport a Google Sheet to a specific format (CSV, XLSX, PDF, ODS, TSV). Downloads the exported file to local filesystem.
- get-spreadsheetGet full metadata for a Google Spreadsheet including title, locale, sheets (tabs), named ranges, and spreadsheet URL. Does not return cell values — use read-spreadsheet or read-sheet-range for that.
- list-sheet-tabsList all sheets (tabs) in a Google Spreadsheet with their metadata.
- read-sheet-rangeRead a specific range from a Google Sheet. More efficient than reading the entire sheet.
- read-spreadsheetRead data from a Google Sheet.
- write-valuesWrite data to a specific range in a Google Sheet. Overwrites existing values. Pass a 2D array of rows (each row is an array of cell values). Supports formulas (strings starting with =).
Auth and permissions
What it asks for.
Declared in the manifest, in advance. The app cannot reach anything it did not ask for here.
Scopes
System secrets
User secrets
Reading further
The manifest and the source for Google Sheets live in the monorepo, alongside the other apps.