.webp)
The query of HubSpot and Google Studio integration has been doing rounds on the Internet. With an urge to be a Good Samaritan, we couldn’t resist ourselves to provide you with a free helping guide.
While dealing with one of our clients at GrowthSpree, we also stumbled upon this unusual riddle. It included creating reports with division and percentage calculations. HubSpot reports were not producing an accurate graph representation, leading to erroneous analysis.
Limitations of HubSpot Reports
- Percentage calculations are a little bit complex
- Cannot be scheduled to share to professional virtual groups like slack, email, etc.
- Not as customizable and flexible for presentations as Data Studio
- Manipulating multiple data sources is complicated and not centralized in one dashboard
This is when it hit us that we should try to represent these reports in Google Studio as it does have the features to do so. But the important question that remains is -how to transfer the HubSpot data to Google Data Studio without spending a penny.
Process of Integrating HubSpot with Google Data Studio
Let’s begin with the step-by-step process.
Data Clarity is the key
The data we send needs to be well-defined in HubSpot with accurate properties. Make sure to check all the properties that need to be transferred, like Name, Email, No of meetings booked, etc., depending on the requirements. Data can be in the form of a list, some property filters or can be manually added.
Send Data to Google Sheets via Workflow
We can easily send all the data to Google Sheets using HubSpot workflow.
But first, we need to integrate them both.
Go to Settings → Integrations → Connected Apps → Seach for Google Sheets → Install
Now, we will create a workflow and define the enrollment trigger required, which can be a list, a property like Meeting Status = Completed, form submissions, etc.
Select “Create Google Sheet row” as your action and choose the Sheet you want to add the data to.
Add all the properties and match them against the headers of the Google Sheet. For example, if one of the headers in your Google sheet contains Email, you can choose the property Email to populate the values for the column Email.
Connect Google Sheets to Google Data Studio
Once you have logged in to your Google Data Studio account, follow the steps:
Step 1: Click on Create button on the left navbar
Step 2: Select Data Source
Step 3: Select Google Sheets as your Google Connectors
Step 4: Click on Authorize button
Step 5: Click on Allow
Step 6: Select the Google Sheet of your choice
Step 7: Make sure to tick the checkbox that says -Use first row as headers
Step 8: Click on Connect
Step 9: Click on “Create Report”
The next step would be to create reports with the available data by using different properties, filters, and graph representations.
Difference between HubSpot Reports and Google Studio Reports
Unlike Hubspot, Data Studio helps you manipulate multiple data sources to produce a single page and centralised report.
Now, go and impress your boss with a fancy single dashboard!
Emphasize your product's unique features or benefits to differentiate it from competitors
In nec dictum adipiscing pharetra enim etiam scelerisque dolor purus ipsum egestas cursus vulputate arcu egestas ut eu sed mollis consectetur mattis pharetra curabitur et maecenas in mattis fames consectetur ipsum quis risus mauris aliquam ornare nisl purus at ipsum nulla accumsan consectetur vestibulum suspendisse aliquam condimentum scelerisque lacinia pellentesque vestibulum condimentum turpis ligula pharetra dictum sapien facilisis sapien at sagittis et cursus congue.
- Pharetra curabitur et maecenas in mattis fames consectetur ipsum quis risus.
- Justo urna nisi auctor consequat consectetur dolor lectus blandit.
- Eget egestas volutpat lacinia vestibulum vitae mattis hendrerit.
- Ornare elit odio tellus orci bibendum dictum id sem congue enim amet diam.
Incorporate statistics or specific numbers to highlight the effectiveness or popularity of your offering
Convallis pellentesque ullamcorper sapien sed tristique fermentum proin amet quam tincidunt feugiat vitae neque quisque odio ut pellentesque ac mauris eget lectus. Pretium arcu turpis lacus sapien sit at eu sapien duis magna nunc nibh nam non ut nibh ultrices ultrices elementum egestas enim nisl sed cursus pellentesque sit dignissim enim euismod sit et convallis sed pelis viverra quam at nisl sit pharetra enim nisl nec vestibulum posuere in volutpat sed blandit neque risus.
Use time-sensitive language to encourage immediate action, such as "Limited Time Offer
Feugiat vitae neque quisque odio ut pellentesque ac mauris eget lectus. Pretium arcu turpis lacus sapien sit at eu sapien duis magna nunc nibh nam non ut nibh ultrices ultrices elementum egestas enim nisl sed cursus pellentesque sit dignissim enim euismod sit et convallis sed pelis viverra quam at nisl sit pharetra enim nisl nec vestibulum posuere in volutpat sed blandit neque risus.
- Pharetra curabitur et maecenas in mattis fames consectetur ipsum quis risus.
- Justo urna nisi auctor consequat consectetur dolor lectus blandit.
- Eget egestas volutpat lacinia vestibulum vitae mattis hendrerit.
- Ornare elit odio tellus orci bibendum dictum id sem congue enim amet diam.
Address customer pain points directly by showing how your product solves their problems
Feugiat vitae neque quisque odio ut pellentesque ac mauris eget lectus. Pretium arcu turpis lacus sapien sit at eu sapien duis magna nunc nibh nam non ut nibh ultrices ultrices elementum egestas enim nisl sed cursus pellentesque sit dignissim enim euismod sit et convallis sed pelis viverra quam at nisl sit pharetra enim nisl nec vestibulum posuere in volutpat sed blandit neque risus.
Vel etiam vel amet aenean eget in habitasse nunc duis tellus sem turpis risus aliquam ac volutpat tellus eu faucibus ullamcorper.
Tailor titles to your ideal customer segment using phrases like "Designed for Busy Professionals
Sed pretium id nibh id sit felis vitae volutpat volutpat adipiscing at sodales neque lectus mi phasellus commodo at elit suspendisse ornare faucibus lectus purus viverra in nec aliquet commodo et sed sed nisi tempor mi pellentesque arcu viverra pretium duis enim vulputate dignissim etiam ultrices vitae neque urna proin nibh diam turpis augue lacus.
.webp)