# Google Sheets AI integration on Definable

> Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps

## What this connects

Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps

Vendor: https://sheets.google.com/

## Tools available

**40** tools available. First 12:

- `GOOGLESHEETS_ADD_SHEET` — Add Sheet to Existing Spreadsheet — Adds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE. SHEET TYPES: - GRID (default): Standard spreadsheet with rows/columns. Use properties to set dimensions, tab color, etc. - OBJECT: Sheet containing a chart. Requires objectSheetConfig with chartSpec (basicChart or pieChart). - DATA_SOURCE: Sheet connected to BigQuery. Requires dataSourceConfig with bigQuery spec and bigquery.readonly OAuth scope. OTHER NOTES: - Sheet names must be unique; use forceUnique=true to auto-append suffix (_2, _3) if name exists - For tab colors, use EITHER rgbColor OR themeColor, not both - Avoid 'index' when creating sheets in parallel (causes errors) - OBJECT sheets are created via addChart with position.newSheet=true - DATA_SOURCE sheets require bigquery.readonly OAuth scope Use cases: Add standard grid sheet, create chart on dedicated sheet, connect to BigQuery data source.
- `GOOGLESHEETS_AGGREGATE_COLUMN_DATA` — Aggregate Column Data — Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
- `GOOGLESHEETS_APPEND_DIMENSION` — Append Dimension — Tool to append new rows or columns to a sheet, increasing its size. Use when you need to add empty rows or columns to an existing sheet.
- `GOOGLESHEETS_AUTO_RESIZE_DIMENSIONS` — Auto-Resize Rows or Columns — Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Use when you need to automatically adjust row heights or column widths to fit content after writing data.
- `GOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER` — Batch Clear Values By Data Filter — Clears one or more ranges of values from a spreadsheet using data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters will be cleared. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept.
- `GOOGLESHEETS_BATCH_GET` — Batch get spreadsheet — Retrieves data from specified cell ranges in a Google Spreadsheet.
- `GOOGLESHEETS_BATCH_UPDATE` — Batch update spreadsheet (Deprecated) — DEPRECATED: Use GOOGLESHEETS_VALUES_UPDATE instead. Write values to ONE range in a Google Sheet, or append as new rows if no start cell is given. IMPORTANT - This tool does NOT accept the Google Sheets API's native batch format: - WRONG: {"data": [{"range": "...", "values": [[...]]}], ...} - CORRECT: {"sheet_name": "...", "values": [[...]], "first_cell_location": "...", ...} To update MULTIPLE ranges, make SEPARATE CALLS to this tool for each range. Features: - Auto-expands grid for large datasets (prevents range errors) - Set first_cell_location to write at a specific position (e.g., "A1", "B5") - Omit first_cell_location to append values as new rows at the end Requirements: Target sheet must exist and spreadsheet must contain at least one worksheet.
- `GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER` — Batch Update Values by Data Filter — Tool to update values in ranges matching data filters. Use when you need to update specific data in a Google Sheet based on criteria rather than fixed cell ranges.
- `GOOGLESHEETS_CLEAR_BASIC_FILTER` — Clear Basic Filter — Tool to clear the basic filter from a sheet. Use when you need to remove an existing basic filter from a specific sheet within a Google Spreadsheet.
- `GOOGLESHEETS_CLEAR_VALUES` — Clear spreadsheet values — Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond to an existing sheet and cells.
- `GOOGLESHEETS_CREATE_CHART` — Create Chart in Google Sheets — Create a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional requirements: - Provide either a simple chart via chart_type + data_range (basicChart), OR supply a full chart_spec supporting all chart types. Exactly one approach should be used. - When using chart_spec, set exactly one of the union fields (basicChart | pieChart | bubbleChart | candlestickChart | histogramChart | waterfallChart | treemapChart | orgChart | scorecardChart).
- `GOOGLESHEETS_CREATE_GOOGLE_SHEET1` — Create a Google Sheet — Creates a new Google Spreadsheet in Google Drive. If a title is provided, the spreadsheet will be created with that name. If no title is provided, Google will create a spreadsheet with a default name like 'Untitled spreadsheet'. Optionally create the spreadsheet in a specific folder by providing either: - folder_id: The Google Drive folder ID (preferred, unambiguous) - folder_name: The folder name (searches for exact match; if multiple folders match, returns choices) If neither folder_id nor folder_name is provided, the spreadsheet is created in the root Drive folder.

## Auth

Auth schemes: `OAUTH2`. Managed by Definable: `OAUTH2` — no client credentials required from the user.

## How agents use Google Sheets

Inside a Definable workflow, Google Sheets is one of the tools the **Distributor specialist** can call. Example coordination patterns:

- **Researcher → Google Sheets** — the Researcher (GPT-5.5) pulls context from Google Sheets (records, threads, documents), synthesises findings, and briefs the rest of the team.
- **Writer → Distributor → Google Sheets** — the Writer (Claude Opus 4.7) drafts copy in brand voice, the Verifier passes it, then the Distributor writes the result into Google Sheets (create record, post message, draft email).
- **Designer / Engineer → Distributor → Google Sheets** — the Designer ships an asset or the Engineer ships a code change, the Distributor delivers it via Google Sheets (attach file, open PR comment, post status).

The Verifier checks every Google Sheets call. On rate limit, schema drift, or auth refresh it self-heals and retries — the workflow completes without manual intervention.

## Categories

- spreadsheets — https://definable.ai/apps/category/spreadsheets/

## Related

- HTML page: https://definable.ai/apps/googlesheets/
- Same category (spreadsheets): https://definable.ai/apps/category/spreadsheets/
- All integrations: https://definable.ai/apps/
- Workflow (multi-agent loop): https://definable.ai/workflow/
- Apps llms.txt index: https://definable.ai/llms-apps.txt