Google Analytics
Connect analytics data for dashboards.
Google Sheets
Connect Google Sheets and sync spreadsheet data.
The Google Sheets integration lets you import data from Google Sheets into Dashbreeze. Each selected sheet becomes a table that you can use in your dashboards.
Important:Dashbreeze only reads your spreadsheet. It never edits, deletes, or changes anything in it.
What you'll need
- 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
Connecting your Google account
Click Add Account. Give the connection a name, and a description if you'd like one. Then you're sent to Google to sign in and approve 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.
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.
Adding a spreadsheet
Once you have an integration, you can use it to import a spreadsheet. Select the integration, paste the spreadsheet's URL, and choose which sheets you want to import.
You can repeat this process for as many spreadsheets as the connected Google account has access to, without creating another integration.
Choosing which sheets to bring in
A spreadsheet can contain multiple sheets (tabs). Select the ones you want to import.
Every selected sheet becomes a separate table in Dashbreeze. 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.
Important:Dashbreeze only reads the exact spreadsheet you give it a link to — nothing else in your Google account.
Keeping your data updated
Google Sheets is a live connection. You don't need to reconnect your spreadsheet every time it changes.
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.