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
- 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.
- Connect HubSpot. On your dashboard choose Connect HubSpot, pick your HubSpot account and accept the permissions below.
- 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.
| Permission | Why we need it |
|---|---|
oauth | Required by HubSpot for every app that signs in with OAuth. |
crm.objects.contacts.read | Read the contacts you sync. |
crm.objects.companies.read | Read the companies you sync. |
crm.objects.deals.read | Read the deals you sync. |
crm.objects.owners.read | Show owner names instead of owner IDs. |
crm.schemas.contacts.read | List contact properties and their labels, so you can pick columns. |
crm.schemas.companies.read | List company properties and their labels. |
crm.schemas.deals.read | List 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
- Edited values and new records: we check HubSpot every minute (every 30 seconds on Pro) and update their rows. In our test on a real HubSpot account, five edits reached the sheet in 5 to 38 seconds.
- Deleted and merged records: HubSpot tells us at once, and the sheet follows within about a minute (about 30 seconds on Pro).
- Every night: we rebuild each sheet from HubSpot, so nothing can drift.
- Company and contacts columns: they are rewritten whenever the record is written, which includes every time it is edited, and at the nightly rebuild.
- Sync now: on your dashboard, for when you can’t wait.
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 see | What 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
- Stop one sync: choose Stop sync on your dashboard. The spreadsheet stays in your Drive, with its data.
- Disconnect a HubSpot account: choose Disconnect next to the account on your dashboard. We remove the app from that HubSpot account and delete its syncs. Your spreadsheets stay in your Drive.
- Uninstall from HubSpot: in HubSpot, open your Connected Apps, find CRM Sheet Sync and uninstall it. We stop reading at once. Your sheets stay in your Drive.
- Cancel your plan: on your dashboard choose Manage billing. Your syncs pause at the end of the paid period.
- Your data: 90 days after a trial ends unpaid or a plan is cancelled, we delete your account, tokens and sync settings. We never delete your spreadsheets. Want it gone sooner? Email us.
Help
Email support@webitsolutions.net. We answer within 2 working days.
Ready? Start free trial 7 days free. No card to start.