WorkerKit

AI workers for Google Sheets

Ready-made AI workers for Google Sheets: rows appended without a copy-paste chain, the numbers your reporting depends on read on a schedule, and spreadsheets that stop being a manual job.

What is an AI worker for Google Sheets?

An AI worker for Google Sheets is an AI agent scoped to one spreadsheet job, such as appending the day's figures to a running log or reading a sheet and turning the current numbers into a written status. It works through your connected Google account and can be limited to spreadsheets alone, so a worker built for sheet work cannot open the documents and decks that live beside them.

What these workers do

Append the day's numbers to a running log

Adds new rows to the bottom of the table each run, without touching the rows already there, so the history your charts read from stays intact.

Turn a sheet into a written status

Reads the ranges your reporting depends on and writes the current state as prose a person can skim, refreshed on the schedule you set.

Keep a tracker current from other sources

Carries figures from the systems it may read into the sheet your team actually looks at, so the tracker stops being a weekly manual chore.

Watch a sheet for the number that matters

Checks a range on a schedule and reports when a threshold is crossed, so nobody keeps a tab open just to notice.

How an AI worker runs in Google Sheets

Appending is safer than editing

A sheet is a database the team can read

Scope can stop at spreadsheets

Google Sheets questions, answered.

Can an AI worker overwrite my spreadsheet?

Only with the matching write permission, and appending rows is a separate, narrower grant than editing cells. A worker set up to append can add to a table but not rewrite it, and a read only worker can report on a sheet with no ability to change a single cell.

Can it see my other Drive files?

Not if you scope it to spreadsheets. The file-type limit means documents, presentations, and everything else in the account stay outside its window even when they sit in the same folder as the sheet it works on.

Does it understand tabs and ranges?

Yes, it reads the tabs and ranges you point it at and can be told to work within one tab of a larger workbook. That keeps a worker feeding one log from wandering across the rest of the spreadsheet.

What about formulas?

Values it writes can be entered the way a person would type them, so the sheet's own formulas keep calculating. A worker appending rows to a table does not need to know how your totals are built, and it cannot restructure them without edit permission.

What AI workers can do in Google Sheets

The tools a worker can be granted in Google Sheets once you connect it. A kit grants only the ones its job needs, and you can narrow them further on the worker.

Read Named Sheet Rows

Read a bounded page of named row objects through existing Sheets permissions and redaction. Supply an explicit column map and a tab-qualified finite A1 range excluding headers. Preserves sparse cells, zero, false and physical row positions. Optional keyColumn must be unique and non-empty within the page; without it IDs are row positions at read time and move on sorting. sourceReadInfo.nextArgs advances the requested row window, including blank/trailing rows. No automatic header guessing or in-place writes.

Search Google Sheets

Search for Google Sheets across connected drives. Returns matching spreadsheets with name, size, owners, modified time, and parent folder. Pre-filtered to Google Sheets only. Use pageToken from response for pagination.

Get Sheet Metadata

Get metadata for a Google Sheet: spreadsheet title, sheet names, and dimensions (row/column count per sheet). Use this to discover sheet names before writing values. For reading data, prefer google_sheets_read_all (one call across all tabs) and only fall back to google_sheets_read for a specific range.

Read All Sheet Tabs

Read every tab of a Google Sheet in a single call. Default behaviour caps each tab at up to 200 rows × up to 26 columns (narrower tabs return their actual column count) and annotates clipped tabs with 'clipped: true' and a 'fullRange' A1 string — pass that fullRange straight to google_sheets_read to drill in on a clipped tab (no client-side range arithmetic needed). Prefer this over google_sheets_read when the agent doesn't already know which range it needs. Supply explicit 'ranges' to bypass the default cap; supplied ranges pass through verbatim.

Read Sheet Values

Read cell values from a specific A1-notation range. Values come back as formatted strings or native numbers/booleans; trailing empty rows and trailing empty cells are dropped, but nulls mid-row are preserved to keep column alignment (jagged rows are intentional, not a bug). For exploring an unknown spreadsheet prefer google_sheets_read_all (one call returns every tab); use this tool when you already know the exact range — or when google_sheets_read_all reported a 'clipped' tab and you want to read its full range.

Write Sheet Values

Write a 2D array of cell values into a Google Sheet range, or pass updates to write several ranges in one atomic call (preferred for multi-tab edits). Extra cells in the array are ignored; cells the array doesn't reach are left untouched — overwrite-where-supplied, not range-clear-and-write; write empty strings to clear. Max 10,000 cells per single write, 50,000 across a batch.

Append Rows to Sheet

Append rows to the bottom of a Google Sheet. Values are added after the last row with data in the specified range. Max 5,000 rows per call. Use this instead of google_sheets_write when adding new data to an existing table.

Create Google Sheet

Create a new Google Sheet, optionally seeding the first tab from CSV content. Omit content for a blank spreadsheet. When CSV is supplied, Drive names the tab after the file rather than 'Sheet1' — call google_sheets_get_metadata to discover the tab name before google_sheets_write or google_sheets_append. Returns the new spreadsheet's provider-prefixed ID.

Read Sheet Tab

Read the entire used range of a single tab in one call — no A1 range to compute. Identify the tab by title (primary) or sheetId; provide exactly one. Returns the same value shape as google_sheets_read. Use this when you want a whole tab and know its name; use google_sheets_read for a specific range, or google_sheets_read_all to sweep every tab at once.

Add Sheet Tab

Add a new tab (worksheet) to an existing spreadsheet. The title must be unique within the spreadsheet. Returns the new tab's assigned sheetId — target the tab with that (or its title) in later reads and writes.

Delete Sheet Tab

Delete a single tab from a spreadsheet, identified by sheetId (primary) or title; provide exactly one. The spreadsheet must keep at least one tab. This permanently removes the tab and its data, unlike trashing the whole spreadsheet (which is recoverable).

Browse Google Sheets kits

All apps