How to connect HubSpot to Google Sheets

With CRM Sheet Sync it takes three steps: sign in with Google, connect HubSpot, and choose what goes in the sheet. The sheet then fills in and is checked for changes every minute. You need a Google account and a HubSpot user who can install apps.

Install in three steps

  1. Sign in with Google. Choose Start free trial. Your 7-day free trial starts. No card needed. We make one folder in your Google Drive for your sheets, and we can only open the files we create.
  2. Connect HubSpot. On your dashboard choose Connect HubSpot, pick your HubSpot account and accept the permissions below.
  3. Create a sync. Choose New sync, then contacts, companies or deals, and tick the properties you want as columns. A deal’s company and contacts, and a contact’s company, are columns too: look under From associated records. To keep only some records, add a condition under Only include records where…, for example a pipeline or an owner. Choose Create sync. We make the spreadsheet and fill it in. A large account can take a few minutes.

Column A holds the HubSpot record ID. Row 1 holds the property names as you see them in HubSpot. Owners, stages and dropdown values show their names, not IDs.

What we ask access to, and why

Read-only. We never create, change or delete anything in HubSpot.

PermissionWhy we need it
oauthRequired by HubSpot for every app that signs in with OAuth.
crm.objects.contacts.readRead the contacts you sync.
crm.objects.companies.readRead the companies you sync.
crm.objects.deals.readRead the deals you sync.
crm.objects.owners.readShow owner names instead of owner IDs.
crm.schemas.contacts.readList contact properties and their labels, so you can pick columns.
crm.schemas.companies.readList company properties and their labels.
crm.schemas.deals.readList deal properties, pipelines and stage names.

On the Google side we ask for your name and email (to sign you in) and access to the files we create, nothing else in your Drive. We do not keep a copy of your CRM records: they pass through our servers while a sync runs. Details: Privacy.

How the sheet stays current

We write values only, so your colors, widths and number formats stay. Don’t type into the synced cells: the next update writes the HubSpot value back.

If something goes wrong

Your dashboard shows the problem in plain words, with a button that fixes it. The most common ones:

You seeWhat to do
HubSpot disconnected.Choose Reconnect HubSpot. This happens when the app was uninstalled or your HubSpot user lost access.
HubSpot did not allow access to this data.Reconnect HubSpot and accept all the permissions.
Google disconnected.Choose Reconnect Google.
We cannot find your spreadsheet.It may have been deleted. Contact us and we set it up again.
HubSpot asked us to slow down, Google Sheets is busy, or either one is not answering.Nothing. We try again by ourselves in a few minutes.

Disconnect or uninstall

Help

Email support@webitsolutions.net. We answer within 2 working days.

Ready? Start free trial 7 days free. No card to start.