Our HubSpot–Google Sheets sync is designed for B2B companies who need to keep their CRM data in sync with Google Sheets. With data in Google Sheets teams can deploy BI & analytics tools, create workflows with Zapier/Make and more.
💡 Google Sheets is currently only available as a destination app. This means you can sync contacts from HubSpot to Google Sheets, but not the other way around. 2-way sync is coming soon.
Are there alternatives for syncing HubSpot and Google Sheets?
Zapier and Make offer more flexibility but come with trade-offs. They don't create a bi-directional relationship that listens to changes, they are difficult to set up and get expensive as each action counts.
Connect HubSpot and Google Sheets, deeply and easily
Get started in 10 minutes. 14-day free trial. No credit card required.
Why Outfunnel is the best tool to integrate HubSpot with Google Sheets
Contact sync. Sync all contacts or a subset(s) of contacts from HubSpot to Google Sheets and keep them in sync going forward.
Comprehensive field mapping. Sync any default or custom fields.
Deduplication built-in. Outfunnel creates links based on the email address and we'll automatically cross-reference contacts to prevent duplicate contact entries. If a contact already exists we'll simply link it. If it doesn't we'll create a new contact.
Instant data sync. Outfunnel syncs most data instantly and some within 2 hours.
Monitor sync status. Clear overview of the sync health which includes actionable error messages so you can fix them as they happen.
Historical sync. Sync all of your customer data, no matter when it was created. Outfunnel syncs not only new contacts, but also existing ones.
Transparent pricing. Each contact that's part of the sync only counts once, regardless of how many updates get synced or to how many apps.
Reliable and secure data. Outfunnel uses advanced authentication methods, such as OAuth, and deploys encryption measures to make sure the data is secure in transit.
Authenticate your apps
Head to App connector
Select HubSpot and Google Sheets
Authenticate as per on-screen instructions if you haven't done so already
How to set up a contact sync from HubSpot to Google Sheets
1. Choose your apps
Select HubSpot and Google Sheets, and choose Contact sync as the connection type.
2. Set the sync direction and database
Choose the Google Sheets file and sheet you'd like to sync data to.
3. Define which contacts to sync
Define which contacts should be part of the sync.
HubSpot contacts: You can choose to sync all contacts or use static lists or active lists. Learn how to set up HubSpot Lists.
If this is your first sync we recommend syncing a limited number of (test) contacts to get a feel for the sync.
4. Set up field mapping
Choose the default fields and/or custom fields you'd like to sync.
Read-only fields. Some fields are read-only (ie calculated fields) and cannot be edited which means they can only be synced in one direction.
Adding new fields. Create a new field in the corresponding app. Then head back to Outfunnel and click "refresh fields" to see the new field.
5. Activate the connection
🏁 Initial sync
After activating the connection Outfunnel will run an initial sync and you should see contacts appearing in the sync status page. The initial sync usually takes a few minutes but can take up to a few hours depending on the number of contacts to sync.
The status page also shows errored contacts and provides actionable feedback on how to fix this.
Initial sync action
Outfunnel first looks for an existing object based on the email address. If found, a link is created with the existing object. If an existing object is not found a new row is created. If multiple objects are found with the same email address then the link is made with the oldest contact and no duplicates will be created.
🔄 Continuous sync
After the initial sync completes Outfunnel starts running a continuous sync that checks for updates. As long as the contact matches the rule any changes to its profile in HubSpot will be synced to Google Sheets. See here for sync interval.
✖️ Exiting the sync
When a contact stops matching the rules all updates will stop.
In Google Sheets: the row will be removed from the sheet.
Need help?
If you run into any issues or have questions about the sync, reach out to us via the chat widget — we're happy to help!