Google Sheets integration
Operator AI connects to Google Sheets to find spreadsheets and read exact ranges. Creating spreadsheets, changing rows and tabs, and formatting need your approval.
2 min read
1. Supported actions
| Action | Approval |
|---|---|
| Find spreadsheets | Runs automatically |
| Read exact ranges | Runs automatically |
| Check for a duplicate title before creating a spreadsheet | Runs automatically |
| Create spreadsheets with data filled in | Needs your approval |
| Add or update rows | Needs your approval |
| Add and rename tabs, and apply table and cell formatting | Needs your approval |
Reading, searching and drafting run automatically. Anything that sends, publishes, changes or deletes needs your approval.
2. Examples
Log a new lead
- 1
Trigger
Nadia fills in your enquiry form.
- 2
What Operator AI prepares
A new row with her details in your leads sheet.
- 3
ApprovalNeeds your approval
You approve the row.
- 4
Result
The row is added to your leads sheet.
Google SheetsPrepared by Operator AIExampleNew row in your leads sheet
Nadia's details from your enquiry form, as a new row.
Start a tracker
- 1
Trigger
You ask for a tracker for this month's jobs.
- 2
What Operator AI prepares
A duplicate title check and a filled-in spreadsheet.
- 3
ApprovalNeeds your approval
You approve the new spreadsheet.
- 4
Result
The spreadsheet is created in Google Sheets.
3. Limitations
- Operator AI doesn't create charts, pivot tables, macros or Apps Script.
4. Permissions and access
What Operator AI can do depends on the account you connect and the permissions you grant. You can disconnect it at any time.
Access is scoped to the workflow you agree. Our team sets it up with you and manages it over time.
5. FAQ
- Can Operator AI change existing rows?
- Yes, with your approval. It adds or updates rows after you approve the change.
- Who sets up Google Sheets?
- Our team sets it up with you and manages it over time.
- Does Operator AI avoid duplicate spreadsheets?
- Yes. It checks for a duplicate title before it creates a spreadsheet.
Need help connecting Google Sheets? Book a call with our team.