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