Google Analytics
Connect a GA4 property and import metrics, dimensions, and report presets into tables.
Google Sheets
Connect Google Sheets, import spreadsheet tabs as tables, and keep dashboard data synchronized.
To connect Google Sheets to Dashbreeze, authorize a Google account, paste a spreadsheet URL, and select the sheets you want to import. Dashbreeze turns each selected sheet into a separate table for charts, metrics, filters, and other dashboard blocks.
Important:Dashbreeze only reads your spreadsheet. It never edits, deletes, or changes anything in it.
What do you need to connect Google Sheets?
- A Google account with access to the spreadsheet
- The spreadsheet's URL
- Data arranged in columns (more on this below)
- A real Google Sheets file — not just an Excel file sitting in your Google Drive
How do you connect a Google account?
- Select Add Account.
- Give the connection a recognizable name and, optionally, a description.
- Sign in to Google and approve read access.
This creates an integration. You only do this once per Google account.
Need to import spreadsheets from another Google account? Connect that account too. You can choose which connected account to use whenever you create a new table.
For team-owned reporting, use a Google account whose spreadsheet access will remain stable. If the connected account loses access, Dashbreeze cannot refresh tables created from that spreadsheet until the permission or integration is restored.
What column-oriented data means
Dashbreeze turns your spreadsheet into a table. For that to work well, your data should be column-oriented: each column holds one kind of information (like a date or a price), and each row is one record (like one sale).
Row-oriented (avoid this)
| Metric | Jan 3 | Jan 4 |
|---|---|---|
| Revenue | $120 | $45 |
| Orders | 3 | 1 |
↓→
Column-oriented (do this)
| Date | Revenue | Orders |
|---|---|---|
| Jan 3 | $120 | 3 |
| Jan 4 | $45 | 1 |
Dashbreeze expects each row to represent one piece of data. Instead of creating a new column every day, keep all dates in a single Date column and add a new row for each new entry.
How do you import a Google Sheets spreadsheet?
- Select the connected Google account.
- Paste the spreadsheet URL from your browser's address bar.
- Select one or more sheets (tabs). Every selected sheet becomes a separate Dashbreeze table. For example, if your spreadsheet contains Sales, Expenses, and Inventory, selecting all three creates three separate tables that you can use independently in your dashboards.
You can repeat this process for as many spreadsheets as the connected Google account has access to, without creating another integration.
Before importing, make the first row a unique header for every column, remove decorative title rows, and avoid merged cells inside the dataset. Keep dates in one consistent format and store numeric values as numbers rather than including currency symbols or notes in the same cells.
Important:Dashbreeze only reads the exact spreadsheet you give it a link to — nothing else in your Google account.
A refresh reads the current structure as well as the current values. Renaming or removing a spreadsheet column can affect blocks that rely on it, so review connected dashboards after making structural changes. Adding new rows with the existing columns is the safest routine update.
How does Google Sheets data stay updated?
Google Sheets is a live data source in Dashbreeze. You do not need to reconnect the spreadsheet when its rows or cells change.
Open your table and choose how your data should be updated. You can sync it manually whenever you want, or enable Automatic updates and choose how often Dashbreeze should check for new data.
Tip:Automatic updates run on the schedule you choose. If you update your spreadsheet and want those changes to appear immediately, click **Sync Data** on your table instead of waiting for the next scheduled update.