Harnessing the power of Google Sheets within HubSpot dashboards brings a new level of efficiency and clarity to your data analysis and reporting.
Whether it’s tracking sales performance, monitoring marketing campaigns, or managing customer data, this integration offers a seamless solution for your data-driven tasks.
In this guide, you’ll learn the step-by-step process to embed Google Sheets charts into a HubSpot dashboard.
Let’s dive in!
Why Embed Google Sheets into a HubSpot Dashboard?
Embedding Google Sheets into HubSpot enables you to view live, interactive charts alongside your HubSpot reports.
This integration is a boon for professionals using HubSpot’s various hubs like Marketing, Sales, Service, Operations, and CMS.
Note: In this guide, we are using a pre-existing chart created in Google Sheets. This approach assumes you have already set up your chart with the relevant data for your project.
Step-by-Step Guide to Embedding Google Sheets into HubSpot
Prepare Your Google Chart
Create a chart in Google Sheets.
![Create a chart in Google Sheets.](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-1.png)
Click the ‘…’ icon on the chart corner and select ‘Publish chart’.
![Click the '…' icon on the chart corner and select 'Publish chart'.](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-2.png)
Ensure ‘Interactive’ is selected under the ‘Link’ tab.
![Ensure 'Interactive' is selected under the 'Link' tab.](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-3.png)
Tick ‘Automatically republish when changes are made’.
!['Automatically republish when changes are made'.](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-4.png)
Click ‘Publish’.
![Click 'Publish' to publish to the web](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-5.png)
Select ‘OK’ from the dialogue box.
![Coefficient Excel Google Sheets Connectors](https://coefficient.io/wp-content/uploads/2024/02/Coefficient-Excel-Google-Sheets-Connectors-1024x783.png)
Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.
Get Started![](https://coefficient.io/wp-content/uploads/2024/02/blog-form-cta.png)
![Select 'OK' from the dialogue box.](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-6.png)
Copy the embed link.
![Copy the embed link.](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-7.png)
Embed in HubSpot Dashboard
Log into your HubSpot account and navigate to Reporting > Dashboards.Select the dashboard where you wish to add the chart.
Click Actions in the upper right, then choose ‘Add external content’.
![Click Actions in the upper right, then choose 'Add external content'.](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-8.png)
Insert the copied Google Sheets link and click ‘Add’.
![Insert the copied Google Sheets link and click 'Add'.](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-9.png)
View the chart on your dashboard, which is now live and interactive.
![View the chart on your dashboard, now live and interactive.](https://coefficient.io/wp-content/uploads/2023/12/word-image-15624-10.png)
Troubleshooting Common Issues
Ensure the Google Sheet’s sharing settings allow for external viewing. The URL should begin with http:// or https://.
If issues persist, check if the content source provides a specific embed code or link for sharing.
Conclusion
Integrating live, interactive Google Sheets charts into HubSpot dashboards is a business game-changer. It brings data visibility to the forefront, aiding in more strategic and informed decision-making across various departments.