Google Sheets
Connect Google Sheets to Riff to power spreadsheet-backed dashboards, quality checks, and data workflows. Riff handles the OAuth, stores tokens securely, and wires Sheets into your apps, automations, and agents.
What you can build (fast)
KPI dashboards from a “Metrics” sheet
Budget/variance monitors with Slack alerts
Lead scoring and enrichment workflows
KPI Board from Sheets
Build a KPI Board from Google Sheets that reads a 'Metrics' sheet, calculates weekly KPIs (growth, CAC, ROAS), and renders charts with a downloadable CSV. Trigger daily at 08:00 and via Refresh.
Budget Variance Monitor
Create a Budget Variance Monitor that reads actuals vs budget from Google Sheets, flags variances over 10%, and posts a summary to Slack with a CSV attachment. Trigger every weekday at 09:00.
Lead Scoring Dashboard
Create a Lead Scoring Dashboard that reads a 'Leads' sheet, computes scores using rules, highlights hot leads, and writes back a 'Score' column. Trigger on button.
Prerequisites
Google account with access to the relevant spreadsheets
A Riff workspace (sign-in at useriff.ai)
Connect Google Sheets to Riff (two easy ways)
Let the agent drive — When a task needs Sheets, the agent prompts you to connect; approve once; quick test runs. Add proactively — + More → Integrations → Google Workspace, authorise.
How Riff wires Sheets for you (under the hood)
Sets up OAuth and stores tokens in Secrets/Integrations
Adds minimal scopes, verifies, test action
Exposes Sheets to tasks, automations, and agents
Security notes
Sheets may contain sensitive info (e.g., financial records)
Tokens managed by Riff; frontend never sees secrets
Actions run server-side; least-privilege scopes
Last updated
Was this helpful?