# Google Sheets

Таблицы Google — листы, ячейки, диапазоны

## 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”.

## 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.

[Open Google Sheets](https://sheets.google.com)