How to connect Riff with Google Sheets for living dashboards

Pipe data into Sheets, append rows from automations, and share snapshot charts in Slack or email - without breaking your team’s workflow.

Riff and Google Sheets Integration
Riff and Google Sheets Integration - Action. Always

Step-by-step setup (How To)

Step 1 Connect your Google Sheets workspace

  • On the Riff platform click +More → Integrations → Google Sheets
  • Click Connect account
  • Select your Google Sheets workspace and authorize Riff

Step 2 Authorize database access

  • Choose which services Riff can read/write
  • Click Save permissions

Step 3 Verify connection

  • Run a quick test: ask the agent a question about your data.

Frequently Asked Questions

Why can’t I find my spreadsheet?

Confirm you’re signed into the right Google Account and that the file is shared with you.

Can I restrict access to certain spreadsheets or tabs?

Yes. Share only specific files, and keep sensitive tabs hidden or view-only for others.

Does Riff overwrite data in Sheets?

No. Typical flows append new rows or create new tabs you’ve configured—existing data stays intact.

How often does Riff sync to Sheets?

Set the cadence in your Riff automations (from frequent updates to manual refresh).

Troubleshooting Google Sheets Integration on Riff

  • Reconnect the Google sign-in if the connection expires
  • Verify the file is shared with the right people and not restricted
  • Ensure automations/schedules are enabled
  • If edits don’t appear, reload the sheet or check filter views
  • Contact support@riff.ai if the issue persists

Top use cases for Riff + Google Sheets

Dashboards

Weekly KPI Summary (Sheets → Dashboard) Riff and Google Sheets Integration

Weekly KPI Summary (Sheets → Dashboard)

An app that reads KPIs from a “Metrics” sheet, computes WoW deltas, renders charts, and exports a CSV. Trigger daily 08:00.

Build this
Finance Pacing Dashboard Riff and Google Shneets Integration

Finance Pacing Dashboard

An app that reads monthly budget and actuals from Google Sheets, highlights variances with thresholds, and posts a weekly PDF to Slack.

Build this

Automations

Anomaly Ping Riff and Google Sheets Integration

Anomaly Ping

An automation that reads threshold values and current KPIs from a Sheet, detects anomalies, and posts a Slack alert with a CSV.

Build this
List Cleanup Reminder Riff and Google Sheets Integration

List Clean up Reminder

An automation that scans a “Leads” sheet for duplicates/missing fields and posts an owner-specific checklist to Slack every Friday.

Build this

AI Agents

KPI Explainer Riff and Google Sheets Integration

KPI Explainer

An agent that analyzes trends in a “Metrics” sheet, explains drivers, and suggests next best actions in plain language.

Build this
Lead Scoring Advisor Riff and Google Sheets Integration

Lead Scoring Advisor

An agent that reads a “Leads” sheet, proposes a scoring model and highlights top prospects with reasoning.

Build this

Official Google Sheets Resources

Riff Help Center

RELATED INTEGRATIONS