Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.dume.ai/llms.txt

Use this file to discover all available pages before exploring further.

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