Google Sheets Integration

​

Overview

​

1. Connect (OAuth)

​

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)
• Download a sheet’s contents into the conversation

​

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 sheets with "budget"
Describe sheet "Marketing Spend"

Create sheet: Product Launch Tracker (Headers: Task, Owner, Status, Due)

Add row to Product Launch Tracker: Final QA, Sarah, In Progress, Friday
Rename tab 'Sheet1' to 'Raw Data'

​

5. Best practices

​

6. Troubleshooting

​

7. Security

• OAuth tokens only, no passwords stored
• Limited to the 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