Are you looking for a solution to connect HubSpot to Google Sheets? I find HubSpot to be a great CRM but, when it came to building my weekly dashboard, I just dreaded this tedious copy-pasting. Such a waste of my time!
So I looked for a Google Sheets HubSpot integration so that I could build the custom HubSpot dashboard of my dreams. Instead of recreating the same dashboard over and over again, it’s now there, automated automatically.
In this article, I share the tools I’ve found to push HubSpot data to Google Sheets, ready to be analyzed, visualized, edited and transformed into reports: Zapier, G-Accon, Supermetrics, Automate.io, etc.
Zapier is a great tool leading the no-code movement. You’ll love it if you’re looking for a way to populate Google Sheets with HubSpot data for reporting purposes, and get Google Sheet updated when data is populated or edited within HubSpot. This integration will automatically pull this info for you. Zapier allows you to push updates from HubSpot to Google Sheets in just a few minutes. If you receive a new contact or form submission, for instance, this data will be pushed to Google Sheets. Zapier’s HubSpot to Google Sheets integration is relatively basic and easy to set up. You can push new data relating to Contacts, Blogs, Forms and Calendar updates. If you’re looking to update a Google Sheet every time you get a new contact, then Zapier might be the right tool for you. But if you’re looking to analyze past data and get more data on Engagements and Deals, then keep reading, other reviewed solutions in this article will probably suit you best. Another shortcoming is also to get existing records updated. For instance, if you created a contact a week ago and you changed an attribute in the meantime, then updating it through Zapier is not that easy. If a property is updated, the sheet doesn’t update as well. That’s possible but it’s tricky to set up, so it’s workable but not ideal.
If your needs are below 100 tasks per month, you can enjoy the service for free. Otherwise, it costs $24.99 monthly for 750 tasks per month, $61.25 monthly for 2,000 tasks per month, and so on.
G-Accon for HubSpot is an excellent Google add-on, extremely easy to set up. It allows you to export HubSpot data and push it to Google Sheets, edit it, and send it back. Depending on your needs, you might want to know that you can only export fields from HubSpot such as Companies, Contacts Lists, Contact Properties and Contacts.
You cannot schedule this with the least expensive plan however, so you’ll need to refresh new data from HubSpot to Google Sheets and refresh when you want to push your spreadsheet edits back. If you want it to schedule automations, you’ll need to subscribe to the $29.99 per month plan. If you still hesitate, you can use the 2-week free trial to check it out.
Supermetrics is a sidebar that allows you to pull the metrics and dimensions you want directly into the cells you've selected.
Moving your data into Google Sheets is simple: you install the Supermetrics add-on, connect to your HubSpot account, pull the data you want into Google Sheets, and set up scheduled refreshes. Very convenient. This integration supports 126 metrics as well as custom fields for Contacts, Companies, and Deals so you’ll most probably be able to build the dashboard you have in mind. A really cool feature is that you can access all your historical HubSpot data from 2005.
It’s quite pricey though since it costs $199 per user per month to use the HubSpot connector under 100K contacts. If you have +100K contacts, you’ll need to get a quote. If you’d like to ensure it’s the right tool for you before committing, you might want to use the 14-day free trial.
This solution allows you to integrate your HubSpot and Google Sheets accounts without coding through a very easy drag-and-drop interface so that you can map your Google Sheet columns to relevant HubSpot fields. For instance, you could choose to trigger every time a new row is added or updated in Google Sheets and automatically add or update a contact in HubSpot based on the email column in Google Sheets. If you have very simple use cases and look for a no-brainer UI, you’ll like this solution. But since it proposes only a handful of use cases, it might not suit your needs if they’re more complex than just the basic stuff. A great plus is that it can also connect Google Sheets and HubSpot with your other apps and run workflows across them, so that you can trigger workflows automatically when things happen in any of your connected apps.
If you'll run as little as 250 actions per month, you'll be able to use it for free. You'll start paying $49 per month for 10,000 monthly actions.
This one is a slightly different option. It’s not a connector to Google Sheets or Excel. It's a spreadsheet software on its own. Yes, a full fledged spreadsheet software, that’s natively connected to HubSpot. Meaning no more CSV copy-pasting: you just import data from HubSpot in your spreadsheet, build things with this data directly in your spreadsheet, and have that data refreshed automatically 😎.
So the main difference here is that instead of having (1) a HubSpot account, (2) a spreadsheet and (3) a connector to link them both ; you just have your HubSpot account and your Actiondesk spreadsheet, the integration being an integral part of the product.
Just as an FYI, I’m part of the Actiondesk team so I’m definitely biased, but I’d say you should definitely have a look at Actiondesk spreadsheet so that you can request access if it suits your needs.
I would recommend using G-Accon for HubSpot to look at basic data and if you want to mass edit fields on Google Sheets and then push it back. If you want to really get the most out of your HubSpot data however, I would suggest using Actiondesk (but of course I might be a little biased).