.png)
With the Dashbreeze integration with Google Sheets, you can use your Google Sheets spreadsheets as a source for creating datasets.
To use the integration and access the spreadsheets stored in your account, all you need is a free Google account.
<aside> <img src="https://prod-files-secure.s3.us-west-2.amazonaws.com/97ad7190-ac2b-442f-9e27-74cf0c7fdf67/0250722f-16c3-4eef-ad46-1949a4b7e019/google_sheets_logo.png" alt="https://prod-files-secure.s3.us-west-2.amazonaws.com/97ad7190-ac2b-442f-9e27-74cf0c7fdf67/0250722f-16c3-4eef-ad46-1949a4b7e019/google_sheets_logo.png" width="40px" />
The Google Sheets integration is available for free to all Dashbreeze users.
</aside>
Once the integration is up and running, Dashbreeze can access the spreadsheets stored in the Google account you’ve granted permission to. Using the URLs of these spreadsheets, Dashbreeze can create datasets that will be used to build the blocks for your dashboards.
In your Google Sheets spreadsheet, you can add new columns, delete columns, and input new data, and these changes will reflect in the dataset you created. This action can be automatic if you have enabled the auto-refresh setting, or it can be manual by clicking the Update databutton within your dataset.
If you have other Google Sheets spreadsheets stored in a different account and want to use them to create datasets, you will need to grant us permission for that account as well. This will allow us to access these spreadsheets and use their data for your dashboards.
<aside> <img src="/icons/info-alternate_blue.svg" alt="/icons/info-alternate_blue.svg" width="40px" />
You can connect multiple Google accounts to your Dashbreeze account to access the different Google Sheets spreadsheets stored in each.
</aside>
In the main menu, click on the integrations button, and then click on the Create integration button.
On the next screen, click the Connectbutton located on the Google Sheets card. Then, give a name to this integration so that it is easy to locate when creating datasets.
A window will pop up asking you to connect a Google account. You can then either select one of the accounts shown or click on Use another account to sign in with a different Google account that you’re not currently logged into.
If everything goes smoothly, you will be automatically redirected to start creating a dataset with the connected account.
Open the datasets panel and click on the Create dataset button.