How it works
- 1
Authorize Google Sheets once (same Google Cloud OAuth project must have Sheets API enabled)
- 2
Paste a spreadsheet URL, pick a worksheet, then import
- 3
Refresh live data from the dataset workspace whenever the sheet changes
One-time Google Cloud setup
In the Google Cloud project that owns your OAuth client (the same one configured in Supabase Auth → Providers → Google), enable Google Sheets APIunder APIs & Services → Library. Without this, Test Connection returns SERVICE_DISABLED.
Also set GOOGLE_OAUTH_CLIENT_ID and GOOGLE_OAUTH_CLIENT_SECRET on the server so stored refresh tokens can renew access across sessions.
Use cases
- Import survey responses
- Sync budget trackers
- Combine multiple sheets into one dashboard