How to Connect OpenClaw to Google Sheets

# 1. Go to https://console.cloud.google.com
# 2. Click "Select a project" → "New Project"
# 3. Set:
#    - Project name: OpenClaw Sheets Integration
#    - Location: No organization
# 4. Click "Create"
# 5. Note your Project ID (openclaw-sheets-xxxxx)

# 1. In Google Cloud Console, go to "APIs & Services" → "Library"
# 2. Search for "Google Sheets API"
# 3. Click "Google Sheets API" → "Enable"
# 4. Wait for enablement to complete (usually instant)

# 1. Go to "APIs & Services" → "Credentials"
# 2. Click "Create Credentials" → "OAuth client ID"
# 3. Configure consent screen (one-time setup):
#    - User type: Internal (for workspace) or External (for personal)
#    - App name: OpenClaw
#    - Scopes: Add "../auth/spreadsheets" (full Sheets access)
# 4. Create OAuth client ID:
#    - Application type: Desktop app (for CLI) or Web app (for hosted)
#    - Name: OpenClaw Sheets Client
# 5. Download JSON credentials file (client_secret_xxx.json)

# Install the Google Sheets skill:
openclaw skill install google-sheets

# Configure credentials:
# In config/skills/google-sheets.yaml:
google_sheets:
  enabled: true
  credentials_path: "/path/to/client_secret_xxx.json"
  token_path: "~/.openclaw/google-sheets-token.json"  # OAuth token storage
  scopes:
    - "https://www.googleapis.com/auth/spreadsheets"

# Authenticate (opens browser for OAuth flow):
openclaw skill auth google-sheets

# Read a sheet:
openclaw chat "Read data from Google Sheet <SHEET_URL>"

# Write data:
openclaw chat "Add a new row to <SHEET_URL> with columns: Name='John Doe', Email='john@example.com', Status='Active'"

# Update a cell:
openclaw chat "Update cell B2 in <SHEET_URL> to 'Completed'"

# Batch operation:
openclaw chat "Read all rows from <SHEET_URL> where column C equals 'Pending' and update column D to 'In Progress'"

# Check logs:
tail -f ~/.openclaw/logs/skills.log | grep google-sheets

# Example: CRM sync workflow
# config/workflows/sheets_crm_sync.yaml:
workflows:
  sheets_crm_sync:
    trigger:
      type: webhook
      path: /webhooks/new-lead
    steps:
      - name: Extract lead data
        action: ai.extract
        input: "{{ webhook.body }}"
        schema:
          name: string
          email: string
          company: string
      - name: Append to Sheets
        action: google_sheets.append_row
        params:
          spreadsheet_id: "YOUR_SPREADSHEET_ID"
          range: "Leads!A:D"
          values:
            - "{{ steps.extract_lead_data.output.name }}"
            - "{{ steps.extract_lead_data.output.email }}"
            - "{{ steps.extract_lead_data.output.company }}"
            - "{{ timestamp }}"