Google Sheets
Service domainSPREADSHEETS
Arcade Optimized
Arcade.dev LLM tools for Google Sheets.
6tools
4require secrets
Google Sheets toolkit connects Arcade to Google Sheets (and Drive), enabling LLMs to create, read, edit, search, and audit spreadsheets on behalf of authenticated users.
Capabilities
- Spreadsheet creation & editing — Create new spreadsheets or batch-edit existing ones using typed cell operations (updateCells, addSheet, sortRange, addConditionalFormatRule, autoResizeDimensions, and more); supports formulas, formatting, and structured table layouts.
- Structure inspection & data reading — Inspect workbook structure (tabs, charts, merges, conditional formats, table regions) cheaply before reading, then pull specific cell ranges as grids with optional annotations and markdown/CSV/TSV export.
- Search & discovery — Search a user's Google Drive for spreadsheets by title or content, returning metadata (title, ID, URL); excludes trashed files.
- Edit history auditing — Retrieve revision history (contributor identity and timestamps) from Drive; supports summary mode (aggregates, recent preview) and paginated list mode for full history traversal.
- Drive file picker integration — Generate a first-party Google Drive Picker URL to let users grant file-level access when a file is not found or access is denied, enabling retry flows.
- User profile & permissions — Retrieve the authenticated user's name, email, profile picture, and Google Sheets access permissions.
OAuth
This toolkit uses OAuth 2.0 via Google. See the Arcade Google auth provider docs for setup details.
Secrets
ENABLE_GOOGLE_DRIVE_INLINE_PICKER_URL
This secret is a URL override or feature flag value that controls the behavior of the inline Google Drive Picker flow used by GoogleSheets.GenerateGoogleFilePickerUrl. It is not a credential issued by Google — it is a configuration value set by the developer (or Arcade platform operator) to enable or customize the picker URL endpoint used internally. Set this in your Arcade secrets configuration; no specific Google dashboard page issues it.
See the Arcade secrets configuration docs for how to define and manage secrets, and the Arcade secrets dashboard to set values.
Available tools(6)
6 of 6 tools
Operations
Behavior
| Tool name | Description | Secrets | |
|---|---|---|---|
Create a new spreadsheet or batch-edit an existing one.
Omit `spreadsheet_id` to create; provide it to edit. All writes flow through
`requests[]` — typed operations like updateCells, addSheet, sortRange,
addConditionalFormatRule, autoResizeDimensions, and more.
For updateCells use ExtendedValue with an explicit type field (stringValue,
numberValue, boolValue, formulaValue).
By default, build clean, professional-looking tables with restrained, consistent
formatting and plain-text tab names/headers (no emojis); only use emojis or
decorative styling when the user explicitly asks for it. | 1 | ||
Generate a URL where the user can grant this app access to specific Drive files.
Opens Google's first-party Drive picker. The user selects which files to share
with this application — it is not a sign-in or credential prompt.
Use this when a prior tool reported that a file was not found or access was denied,
and the user expects the file to exist. After the user completes the picker flow,
retry the prior tool. | |||
Report who edited a spreadsheet and when, from Google Drive revisions.
Reports the "who" and "when" only — not which cells changed, and it can't revert.
'summary' (default) answers "who last edited this and when" (read from the file's head,
so always accurate), plus per-window aggregates (revisions read, contributors, first
edit) and a preview of recent edits — computed over a bounded window of history per call.
These aggregates describe the whole history only when `is_incomplete` is false; it is
true when the scan was resumed from a token and/or more history remains. To answer
"when was this first edited?" or "who contributed?" reliably, call from the beginning
(no `pagination_token`) and check `is_incomplete` is false. `pagination_token` is
returned when more pages remain so you can resume.
'list' returns one page of individual revisions, oldest first. Drive can't sort
newest-first, so the most recent individual revisions are on the final page. | 1 | ||
Inspect a Google Sheets spreadsheet's structure or read a range of cells.
Use the default 'structure' mode to understand a workbook cheaply before reading.
Switch to 'read' mode to pull a range as a grid of rows, optionally with
per-cell annotations and a rendered markdown/csv/tsv export.
In 'read' mode the response's per-tab 'sheets' block reports only tab identity and
the allocated grid; its scan-derived fields (used_range, populated_cell_count,
formula_cell_count, first_row, table_regions) are placeholders (0/empty) because read
mode does not scan the tab — they do NOT mean the tab is empty or that it has no
tables. The data you read is in the top-level 'range' and 'rows'. Call 'structure'
mode for those aggregates and for the workbook's charts, merges, protected ranges, and
conditional formats.
Workflow for a tab that holds multiple tables, or a table that does not start at A1:
call 'structure' first and use that tab's estimated 'table_regions' to choose the
a1_range to read or filter, so you target one table instead of a glued multi-table
range.
Always check the response's top-level 'warnings' list: read mode reports there when a
result was capped or trimmed (cell budget, the per-cell annotation cap, or an empty
filter scan) and tells you how to recover (page 'next_range', narrow 'a1_range',
'select_columns', or request fewer annotation kinds). | 1 | ||
Searches for spreadsheets in the user's Google Drive based on the titles and content and
returns the title, ID, and URL for each matching spreadsheet.
Does not return the content/data of the sheets in the spreadsheets - only the metadata.
Excludes spreadsheets that are in the trash. | 1 | ||
Get comprehensive user profile and Google Sheets environment information.
This tool provides detailed information about the authenticated user including
their name, email, profile picture, Google Sheets access permissions, and other
important profile details from Google services. |
Get Building
Last updated on