Skip to main content

​
Overview

Connect Google Sheets to find sheets, describe structure, create new sheets, and update content or metadata using natural language.

​
1. Connect (OAuth)

1

Open Integrations

Settings → Integrations → Google Sheets.
2

Authenticate

Click Connect and sign into the correct Google account.
3

Grant Access

Allow requested Sheets/Drive permissions.
4

Test

Ask: “Find my recent Google Sheets.”
Revoke anytime: Google Account → Security → Third‑party access.

​
2. Supported Actions

  • Find sheets by name or keyword (search/filter)
  • Describe a sheet (tabs, columns, basic stats)
  • Create a sheet (optionally with starter headers)
  • Update a sheet (add/rename sheet/tab, modify headers, append rows)

​
3. Quick Commands

Find sheets about Q4 forecast
Describe sheet "Sales Pipeline"
Create a sheet: Team Capacity Plan (Headers: Name, Role, Hours)
Add a row to "Team Capacity Plan": Alice, Designer, 30
Rename sheet "Old Metrics" to "Legacy Metrics"

​
4. Common Patterns

  • Find & Describe
  • Create
  • Update
Find sheets with "budget"
Describe sheet "Marketing Spend"

​
5. Best Practices

GoalTip
Faster searchUse clear sheet names & consistent prefixes
Clean structureStandardize headers; avoid merged cells
Reliable updatesReference exact sheet name + tab if needed
Append accuracyList values in header order

​
6. Troubleshooting

IssueFix
Sheet not foundUse exact title or simplify keywords
Permission deniedReconnect and grant Drive/Sheets scopes
Update failedConfirm tab exists; describe sheet first
Wrong sheet modifiedInclude full sheet name in command

​
7. Security

  • OAuth tokens only; no passwords stored
  • Limited to granted Sheets/Drive scope
  • Revocable anytime
  • Write operations may request confirmation

​
8. Sample Flow

Find sheets with "targets"
Describe sheet "2025 Targets"
Create sheet "2025 Hiring Plan" (Headers: Role, Start Date, Status)
Add row: Backend Engineer, Feb 3, Approved
Google Sheets connected. You can now find, describe, create, and update sheets via chat.
Need advanced analysis? Combine Sheets with Calendar or CRM in a workflow.