Category · Data Sources
Google Sheets
Your spreadsheets, as a live data source
Connect any Google Sheet via OAuth and Datareaches will keep the rows in sync with your dashboard. No CSV exports, no copy-paste, just point at a sheet and pick the tab.
What it does
- Read any worksheet with up to 500,000 rows
- Auto-detect column types (text, number, date, boolean)
- Refresh every 5 minutes or on demand
- Respect Google Workspace sharing permissions
How data flows
One-way read from your sheet into Datareaches. We never write back to your spreadsheet, your source of truth stays untouched.
How to set it up
Step 1
Click "Add integration" in your dashboard settings.
Step 2
Sign in with the Google account that owns the sheet.
Step 3
Pick the spreadsheet and the specific tab.
Step 4
Map columns to dashboard widgets (we suggest defaults).
Step 5
Save, the first sync runs immediately.
Example dashboards
- Sales pipeline tracker driven from a shared sheet
- Project status board with team assignments
- Inventory snapshot fed by a warehouse export
Add this to your dashboard
We'll wire this integration into your custom dashboard during the 7-day build.