> For the complete documentation index, see [llms.txt](https://actlysai.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://actlysai.gitbook.io/docs/supported-protocols-and-platforms/apps/google-sheets.md).

# Google Sheets

AI agents can help you create and update Google Sheets without opening the app. Here are the main things you can do, with examples:

### 1. Create spreadsheets

Start new spreadsheets for projects or reports.

Examples:

* Create a new spreadsheet called “Sales Dashboard”.
* Create a new spreadsheet “User Research Notes” with a first tab named “Interviews”.

### 2. Read values

Fetch data from specific ranges or entire tabs.

Examples:

* Read cells A1:C10 from the “Sales” tab.
* Read the whole “Config” tab.

### 3. Update values

Replace data in specific ranges.

Examples:

* Write “Hello” into cell A1 on the “Notes” tab.
* Overwrite A2:C5 on “Leads” with my CSV rows.

### 4. Batch update values

Change multiple ranges at once.

Examples:

* Write headers “Name, Email, Status” to row 1 on “Leads” and set the next 3 rows.
* Update two non-contiguous ranges, A2:A20 and C2:C20, on “Metrics”.

### 5. Append values

Add new data without touching existing rows.

Example:

* Add a new lead row to the bottom of “Leads”.