Google Sheets
Connect Google Sheets to the AI agent: sheets, ranges and cell values
Connect Google Sheets to the AI agent: sheets, ranges and cell values. The agent answers from the data, writes reports and appends rows with the totals of the day.
DocumentationНашёл 27 расхождений из 1 340 строк, собрал их на лист «Сверка».
- Сопоставил «Остатки» и «Поставка_июль» по колонке артикула
- Отсортировал по величине разницы: сверху −118 шт по SKU 40-221
- 6 артикулов есть только в поставке — вынес отдельным блоком
Integration scenarios
A finished report in a spreadsheet
The agent gathers the numbers, creates a sheet and writes the report range by range — with a header row, auto-sized columns and values above your threshold highlighted.
Answers from the data on a sheet
The agent reads the sheets and ranges it needs and answers your question about the numbers, without making you open the file and flip through tabs.
Scheduled append of daily totals
On a schedule the agent appends a row with the totals of the day to the end of the summary sheet, leaving everything entered by hand above it untouched.
Reconciling two sheets
The agent matches two ranges by key, collects the discrepancies on a separate sheet and sorts them by the size of the difference.
How to connect
Sign in with the Google account that holds the sheets
Open sheets.google.com and check that the files you need are visible under that exact account. Access is granted per account, and the agent sees exactly the spreadsheets it sees.
Get the “Editor” role on someone else's spreadsheets
If a colleague owns the file, ask them to click “Share” and add your address with the “Editor” role. With “Viewer” or “Commenter” the agent can only read: writing cells and appending rows will fail.
Convert Excel files to Google Sheets format
An uploaded .xlsx opens in the browser but is not readable over the API and returns an error. Open such a file and pick “File” → “Save as Google Sheets”, then work with the resulting copy.
Clear the Workspace admin restriction
In a corporate domain third-party apps may be blocked. An admin opens “Security” → “Access and data control” → “API controls” in the Admin console and marks the app as “Trusted”.
What the agent does in the first 10 minutes
- Pulls figures from the sheets and ranges you name and answers from them without you opening the file
- Writes results straight into the spreadsheet: appends rows to the end of a sheet and updates the cells you point at
- Keeps a summary sheet updated on a schedule — for example, appending a row with yesterday's totals every morning
FAQ
How do I connect Google Sheets?
By signing in to your Google account in a separate window: you approve access to spreadsheets, there are no keys to copy. The agent sees exactly the files that account sees, so ask for other people spreadsheets to be opened up with the Share button and the Editor role.
What does the agent see in spreadsheets?
Sheets, ranges and cell values of the spreadsheet you gave a link to. The Sheets API has no file listing, so a spreadsheet is addressed only by a link or the identifier inside it.
Does the agent write to a spreadsheet?
Yes: it overwrites ranges, appends rows to the end of a sheet, clears cells, adds and renames sheets, and applies formatting, sorting and conditional rules.
Why is an uploaded Excel file not readable?
An .xlsx file opens in the browser but cannot be read over the API and returns an error. Open it and choose File → Save as Google Sheets — the agent then works with the resulting copy.