El catálogo/Google Sheets
Google Sheets
app.google.sheets
Create, read, write, format, and export Google Sheets spreadsheets
Qué hace
La aplicación, en sus propias palabras.
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.
Herramientas
14 herramientas que el agente puede llamar.
Todas se declaran con parámetros tipados y devuelven resultados estructurados, así que el anfitrión puede renderizarlas en vez de narrarlas.
- 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 =).
Autenticación y permisos
Qué pide.
Declarado en el manifiesto y por adelantado. La aplicación no puede alcanzar nada que no haya pedido aquí.
Permisos
Secretos de sistema
Secretos de usuario
Seguir leyendo
El manifiesto y el código de Google Sheets están en el monorepo, junto al resto de aplicaciones.