Google Sheets, worked by an AI employee
Not another app for your team to learn, and not a set of rules for you to build. You hire an AI employee, you give it access to your Google Sheets account, and you ask it for things in Slack or Teams the way you would ask anyone else on the team. There is nothing to map and nothing to maintain.
- Spreadsheets
- Signs in to your account
- 36 ready-made tools
- Asked in Slack or Teams
An illustration of how the conversation reads, not a transcript from a client account.
What Google Sheets is
Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps
You sign in with your own Google Sheets account, the same way you already do. We never see or hold your password.
It can also be told by Google Sheets when something happens, rather than only doing things when you ask.
One message in, the work done in Google Sheets.
- 01
You ask
You message your AI employee in the chat your team already has open, in one sentence, in your own words.
- 02
It works out the step
It decides what the job needs in Google Sheets. You do not pick anything from a menu or wire anything together.
- 03
It does the work
Signed in to your own Google Sheets account, inside the access you granted it, doing the thing you asked for.
- 04
It reports back
It tells you what it did, in the same thread. If it could not do something, it says so rather than guessing.
What it can do in Google Sheets
These are the ready-made tools your AI employee already has in Google Sheets. It is not limited to them, but it never has to be taught these.
- Add Sheet to SpreadsheetAdds a new sheet (worksheet) to a spreadsheet. use this tool to create a new tab within an existing google sheet, optionally specifying its title, index, size, and other properties
- Aggregate Column DataSearches for rows where a specific column matches a value and performs mathematical operations on data from another column.
- Append DimensionTool 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.
- Append Values to SpreadsheetTool to append values to a spreadsheet. use when you need to add new data to the end of an existing table in a google sheet.
- Batch Clear Spreadsheet ValuesTool to clear one or more ranges of values from a spreadsheet. use when you need to remove data from specific cells or ranges while keeping formatting and other properties intact.
- Batch Clear Values By Data FilterClears 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 specif
- Batch get spreadsheetRetrieves data from specified cell ranges in a google spreadsheet; ensure the spreadsheet has at least one worksheet and any explicitly referenced sheet names in ranges exist.
- Batch Get Spreadsheet Values by Data FilterTool to return one or more ranges of values from a spreadsheet that match the specified data filters. use when you need to retrieve specific data sets based on filtering criteria r
- Batch update spreadsheetUpdates a specified range in a google sheet with given values, or appends them as new rows if first cell location is omitted; ensure the target sheet exists and the spreadsheet con
- Batch Update Values by Data FilterTool 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.
- Clear Basic FilterTool 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.
- Clear spreadsheet valuesClears 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.
- Copy Sheet to Another SpreadsheetTool to copy a single sheet from a spreadsheet to another spreadsheet. use when you need to duplicate a sheet into a different spreadsheet.
- Create a Google SheetCreates a new google spreadsheet in google drive using the provided title.
- Create Chart in Google SheetsCreate a chart in a google sheets spreadsheet using the specified data range and chart type.
- Create sheet from JSONCreates a new google spreadsheet and populates its first worksheet from sheet json, which must be non-empty as its first item's keys establish the headers.
- Create spreadsheet columnCreates a new column in a google spreadsheet, requiring a valid spreadsheet id and an existing sheet id; an out-of-bounds insert index may append/prepend the column.
- Create spreadsheet rowInserts a new, empty row into a specified sheet of a google spreadsheet at a given index, optionally inheriting formatting from the row above.
- Delete Dimension (Rows/Columns)Tool to delete specified rows or columns from a sheet in a google spreadsheet. use when you need to remove a range of rows or columns.
- Delete SheetTool to delete a sheet (worksheet) from a spreadsheet. use when you need to remove a specific sheet from a google sheet document.
- Execute SQL on SpreadsheetExecute sql queries against google sheets tables. supports select, insert, update, and delete operations with familiar sql syntax. tables are automatically detected and mapped from
- Find worksheet by titleFinds a worksheet by its exact, case-sensitive title within a google spreadsheet; returns a boolean indicating if found and the complete metadata of the entire spreadsheet, regardl
- Format cellApplies text and background cell formatting to a specified range in a google sheets worksheet.
- Get sheet namesLists all worksheet names from a specified google spreadsheet (which must exist), useful for discovering sheets before further operations.
- Get Spreadsheet by Data FilterReturns the spreadsheet at the given id, filtered by the specified data filters. use this tool when you need to retrieve specific subsets of data from a google sheet based on crite
- Get spreadsheet infoRetrieves comprehensive metadata for a google spreadsheet using its id, excluding cell data.
- Get Table SchemaThis action is used to get the schema of a table in a google spreadsheet, call this action to get the schema of a table in a spreadsheet before you query the table. analyze table s
- Insert Dimension in Google SheetTool to insert new rows or columns into a sheet at a specified location. use when you need to add empty rows or columns within an existing google sheet.
- List Tables in SpreadsheetThis action is used to list all tables in a google spreadsheet, call this action to get the list of tables in a spreadsheet. discover all tables in a google spreadsheet by analyzin
- Look up spreadsheet rowFinds the first row in a google spreadsheet where a cell's entire content exactly matches the query string, searching within a specified a1 notation range or the first sheet by def
- Query Spreadsheet TableThis action is used to query a table in a google spreadsheet, call this action to query a table in a spreadsheet. execute sql-like select queries against spreadsheet tables. suppor
- Search Developer MetadataTool to search for developer metadata in a spreadsheet. use when you need to find specific metadata entries based on filters.
- Search SpreadsheetsSearch for google spreadsheets using various filters including name, content, date ranges, and more.
- Set Basic FilterTool to set a basic filter on a sheet in a google spreadsheet. use when you need to filter or sort data within a specific range on a sheet.
- Update Sheet PropertiesTool to update properties of a sheet (worksheet) within a google spreadsheet, such as its title, index, visibility, tab color, or grid properties. use this when you need to modify
- Update Spreadsheet PropertiesTool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings. use when you need to modify the overall configuration of a google sheet.
What Google Sheets can tell it about
It does not only wait to be asked. These are the things Google Sheets can tell your AI employee about the moment they happen, so it can act without anyone noticing first.
- Aggregate Metric ChangedAn aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filt
- Cell Range Values ChangedValues in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
- Conditional Format Rule ChangedConditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between
- Data Validation Rule ChangedData validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
- Developer Metadata ChangedDeveloper metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
- Filtered Range Values ChangedPolling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched va
- New Rows in Google SheetSimple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new
- New Sheet Added in Google SpreadsheetPolling trigger that detects when a new sheet is added to a Google Spreadsheet.
- New Spreadsheet CreatedA new Google Spreadsheet is created. This trigger monitors Google Spreadsheets and fires when new spreadsheets are detected. Uses timestamp filtering to efficiently d
- Spreadsheet Metadata ChangedPolling trigger that detects when a Google Spreadsheet's metadata changes. Uses snapshot-based diffing to detect any changes in spreadsheet properties, sheets, named ranges, develo
- Spreadsheet Properties ChangedPolling trigger that detects when a Google Spreadsheet's top-level properties change. Monitors properties such as title, locale, timeZone, and autoRecalc settings.
- Spreadsheet Row ChangedA looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the ro
- Spreadsheet Search MatchA new spreadsheet appears that matches a saved search. This trigger uses snapshot-based diffing to detect when spreadsheets matching the search criteria are newly cre
- Table Query Result ChangedThe result set of a saved table query changes in Google Sheets. Detects rows added, removed, or updated in the query output. This trigger monitors the result of a SQL
- Table Schema ChangedPolling trigger that detects when a table's schema changes in Google Sheets. Monitors columns added/removed/renamed and inferred type/format changes. Uses snapshot-based diffing to
- Worksheet Names ChangedThe set of worksheet/tab names changes in a Google Spreadsheet. Detects when sheets are added, deleted, or renamed.
These are the jobs Sanaf would hold, signed in to your Google Sheets account.
AI Administrative Assistant
Sanaf, on this job
- Updates the sheet so nobody has to retype anything
- Catches the rows someone left half filled in
AI Business Analyst
Sanaf, on this job
- Reads the sheet and tells you what it means
- Spots the column that has quietly stopped being updated
AI Inventory Manager
Sanaf, on this job
- Keeps a stock sheet current and flags what is low
- Recommends what to order and how much
AI Data Entry Clerk
Sanaf, on this job
- Enters this week’s records and checks them against what is already on file
- Runs the recurring imports and exports
AI Sales Operations Specialist
Sanaf, on this job
- Builds the weekly pipeline and activity report
- Keeps the fields and stages consistent with the CRM
You do not learn a new screen. You type this in Slack or Teams.
@Sanaf update the job sheet with everything from today.
@Sanaf read the sheet and tell me which service line is losing money.
@Sanaf what is below the reorder point on the stock sheet?
You stay the boss of your Google Sheets account.
Nothing connects until you approve it. You grant access one app at a time, you can take it back the same way, and everything your AI employee does in there is written down where you can see it.
How we handle your data- It signs in to your own Google Sheets account. You are not moving anything into ours.
- You grant access one app at a time, and you can take it back the same way.
- Everything it does in Google Sheets is written down, with what it did and when.
- Anything you tell it to check with you first, it checks with you first.
It works in Google Sheets and the rest of your software in the same job
A real job rarely stays in one place. Reading a message in one app, checking a record in another and writing the result in a third is one request to your AI employee, not three.
Questions people ask about Google Sheets
- Can an AI employee really work inside Google Sheets?
- Yes. It signs in to your own Google Sheets account and works in it the way a new hire would, from the chat your team already has open. Nobody installs anything, and nobody learns a new screen.
- Do I have to move anything out of Google Sheets?
- No. Nothing moves and nothing is replaced. Your records stay in Google Sheets, your team carries on in the same screens they used yesterday, and your AI employee works alongside them in there.
- How does it get into my Google Sheets account?
- You sign in with your own Google Sheets account, the same way you already do. We never see or hold your password. You approve it before anything connects, and you can take the access back the same way you gave it.
- What can it actually do in Google Sheets?
- It has 36 ready-made tools in Google Sheets today, among them Add Sheet to Spreadsheet, Aggregate Column Data and Append Dimension. The full list is on this page. It is not limited to those, but it never has to be taught them.
- Can it use Google Sheets and the rest of my software in the same job?
- Yes, and that is usually the point. Reading a message in one app, checking a record in Google Sheets and writing the result somewhere else is one request to your AI employee, not three separate ones you stitch together.
- Who decides what it is allowed to do in Google Sheets?
- You do. You grant access one app at a time and can withdraw it at any time, anything you ask it to check with you first it checks with you first, and everything it does in Google Sheets is written down with what it did and when.