HubSpot and Google Sheets, ready to switch on

Each pipeline you choose gets a tab with one row per deal that changes as the deal moves, contacts have a tab of their own, and rows you paste on the import tab become contacts with the properties you map. You paste two keys in your account and it runs, in about ten minutes.

Connect for $39 a month Mine is a bit different

No setup fee, cancel any month, and a person on live chat if a key doesn't work.

More with these apps: all HubSpot integrations · all Google Sheets integrations

HubSpot can already write to Google Sheets from a workflow.

It can: HubSpot's help describes workflow actions that create or update a Google Sheet row, and there is a free HubSpot Assistant add-on for Sheets. If your plan has workflows and you want one property at a time, that works. This pair keeps whole tabs current for every deal and contact without a workflow per case, and reads the import tab back into the CRM. If the workflow action is enough, we'll say so.

What moves, and when

The details you would normally get after a sales call. Here they are up front.

What	Direction	When	Rule
A tab per pipeline	HubSpot to Google Sheets	Within seconds	One row per deal: name, stage, amount, owner, close date and source, on the tab for that pipeline
Stage moves edit the cell	HubSpot to Google Sheets	Within seconds	The stage and amount cells change on the deal's row, so a pivot by stage is live
Contacts tab	HubSpot to Google Sheets	Within seconds	Name, email, phone, lifecycle stage and owner, with the deal id beside them for a lookup
Import tab	Google Sheets to HubSpot	Every few minutes	Paste rows with an email and they become or update contacts with the properties you map
Names, not ids	In the sheet	Always	Owners and pipelines appear as words so the sheet reads like a report; the ids sit in a hidden column
Formulas survive	In the sheet	Always	Columns we own are written; the rest of the file is yours

How to set up HubSpot and Google Sheets

Ten minutes of your time, then it's ours.

Choose HubSpot and Google Sheets

Press Connect. This pair is already selected on the checkout page at $39 a month, and there's nothing else to pick.
Pay and open your account

Card or invoice, about two minutes. The account opens with this integration waiting for its two keys.
3
Paste the HubSpot private app token and the Google Sheets link
- HubSpot private app token: in HubSpot open Settings, then Integrations, then Private apps, and create an app. Full HubSpot guide
- Google Sheets link: create or open the spreadsheet, share it with the address our engineer sends you or with anyone who has the link, and paste the link from the address bar. Full Google Sheets guide
Each screen carries the full guide with the exact menu names, about six minutes for both.
We check both keys

Each key is checked against HubSpot's and Google Sheets's own API the moment you paste it. If one doesn't pass, the screen says what to fix, and a person joins the chat if that isn't enough.
Move one test deal, then it's Running

A minute or two. Change a test deal in HubSpot and watch its row appear and then update. From then on we watch it for you.

When HubSpot or Google Sheets changes its API, we fix it within a working day. You don't get a ticket to solve.

$39a month

Everything in the table above, with monitoring on.
Fixes when either app changes its API.
A person on live chat, replies within a working hour.
Custom logic beyond the table is priced separately.

Connect for $39 a month

No setup fee, cancel any month

Ways to connect HubSpot and Google Sheets

Three ways people connect these two, and what each one asks of you. The built-in app is described above.

Built-in appZapier or MakeDovetly

Who sets it upYou, in the app's own settingsYou, one step at a time in the scenario editorAlready built. You paste two keys.

Who fixes it when it breaksThe vendor, when it ships a fixYou: the scenario is yours, so the fix is tooWe do, within a working day, and we watch it

What you need to knowThe app's own settings and what they coverTriggers, actions, filters and how the fields of HubSpot and Google Sheets mapWhere the two keys are. The guide shows it.

PriceSet by the vendorSet by the builder's plan, counted in tasks or operations$39 a month, flat, whatever the volume

Before you decide

Can I load a list this way?

Yes, and it's the usual reason people ask. Paste rows on the import tab and they become contacts within a few minutes, matched by email so nobody is created twice.

What if mine is a bit different?

Tell us what should go where in plain words. Small changes to the rules above are usually free; bigger ones we price the same day and build into the same account.