Google Sheets

OpenClaw Google Sheets Integration

Spreadsheets are powerful but tedious. Finding data, updating rows, running summaries — all manual. The OpenClaw Google Sheets integration puts a conversational AI layer on top of your spreadsheets. Query data, add entries, and get automated reports without touching a formula.

What You Can Do

Query Data

You: What's the total revenue in the Sales tracker for March?Assistant: March revenue total: $47,230 across 23 deals. Best deal: Acme Corp at $12,000.

Add Rows

You: Add to expenses: $150 office supplies, today, category AdminAssistant: Row added to Expenses sheet: 2026-03-22 | Office Supplies | Admin | $150

Data Analysis

You: Which sales rep had the most deals closed this quarter?Assistant: Top performer this quarter: Sarah K. with 14 deals closed totaling $89,400. Runner-up: Mike L. with 11 deals at $72,100.

Automated Reports Set up weekly crons to receive spreadsheet summaries automatically:

You: Every Monday morning, send me last week's sales numbers from the CRM sheet

Find Specific Data

You: What's the status of the Acme Corp deal?Assistant: Acme Corp (Row 47): Stage — Negotiation | Value — $25,000 | Owner — Sarah | Last updated — Mar 18

Setup Guide

Step 1: Install the gog skill

clawdhub install gog

Step 2: Enable Google Sheets API

1. Go to console.cloud.google.com
2. Enable the Google Sheets API and Google Drive API
3. Create OAuth 2.0 credentials (Desktop app)
4. Download credentials JSON

Step 3: Configure OpenClaw

skills:  gog:    enabled: true    credentials: ~/.openclaw/google-credentials.json    scopes:      - sheets      - drive.readonly  # needed to list and find spreadsheets

Step 4: Authenticate

gog auth

Step 5: Reference Your Spreadsheets

You can refer to sheets by name in natural language. OpenClaw searches your Drive for matching spreadsheet names.

Automation Examples

Expense Logging via Voice

Send a voice note on your phone: "Uber to airport, $47, travel expense" — OpenClaw transcribes and logs it to your expenses sheet.

Weekly KPI Report

crons:  - schedule: "0 9 * * 1"    prompt: "Pull last week's numbers from the KPI dashboard sheet and give me a summary"    channel: telegram

CRM Updates on the Go

Out of a meeting? Text OpenClaw: "Update Acme Corp deal status to Closed Won, $25K" and it updates your CRM sheet immediately.

Privacy & Security

• OAuth 2.0 — your Google password is never exposed
• Only accesses spreadsheets you grant permission to
• Revoke anytime at myaccount.google.com/permissions

Troubleshooting

Sheet not found

• Ensure Google Drive API is enabled (needed to search for sheets by name)
• Try using the spreadsheet ID directly from the URL

Permission denied on edit

• Ensure you granted write permissions during OAuth
• Check you own or have edit access to the sheet