Pushbuild

Keep a copy of your HubSpot contacts in Google Sheets

A free Google Apps Script that copies your HubSpot contacts into a Google Sheet every hour, for reports, mail merges or a backup.

Short answer: Use a free Google Apps Script that copies your HubSpot contacts into a Google Sheet every hour, for reports, mail merges or a backup. It runs in your own Google account; nothing is sent to us. Setup takes 3 steps: Add your key; Paste the script; Run it.

How to set it up

  1. Add your key. In the Apps Script editor, open Project Settings and add the Script property HUBSPOT_TOKEN. In HubSpot, go to Settings, Integrations, Private apps, create an app with the crm.objects.contacts.read scope and copy its access token. Keys stay in the script, never in the sheet.
  2. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a HubSpot menu appears.
  3. Run it. Choose HubSpot, then Refresh contacts. The Contacts tab fills in with each contact's ID, name, email, phone, company, lifecycle stage and created and last changed dates. Choose Refresh contacts every hour to keep it up to date.
Setup, step by step: 3 steps, done in your own Google account.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Download it free

We'll email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

By continuing, you agree that Pushbuild may email you about this script and related tips. Unsubscribe any time. Privacy

Have us install it for you

We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Have us install it

Good to know

  • The tab is rewritten on each run, so keep your own notes on another tab.
  • Private apps work on HubSpot's free CRM.
  • To add more fields, put their internal names in the FIELDS line at the top of the script and a heading for each in the header row line.

Questions

What does this script do?

It is a free Google Apps Script that copies your HubSpot contacts into a Google Sheet every hour, for reports, mail merges or a backup.

How do I set it up?

In 3 steps: 1. Add your key; 2. Paste the script; 3. Run it. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want it wired into QuickBooks, your CRM or your payment system? Send us a short brief.

Pushbuild · Automate your business with Pushbuild: pushbuild.com/contact