Google sheet sync

How can I import data from active list in Google Sheet to HubSpot and use this data in workflows?

Hi @KMorka and welcome to the Community!
We are so glad to have you here!
Thanks for asking the Community!
I’d like to share this article “Add data to Google Sheets with workflows” that might help you!
And please @KMorka, let me know if there is anything else I can help with. I’ll be delighted to do so!
Thank you and have a brilliant day!
Best,
Bérangère

Thank you for link to the article!

Best

Kasia

Hi @KMorka,

The Google Sheets integration goes one-way, from HubSpot to Google Sheets. If you want to go the other way, you could explore Zapier: Use HubSpot's integration with Zapier

For each (new) row in Google Sheets, you would update/create a contact in HubSpot. If you pass on a column (= property) that identifies these contacts as coming from the sheet, you can use that for enrollment in a workflow.

Best regards!

Thank you very much for help. Have a great day! :slightly_smiling_face:

Kasia

Hey, you can do this with Superjoin (Connect Hubspot to Google Sheets & Excel in One-Click | Superjoin). It’s a bidrectional sync between HubSpot and Google Sheets
1. We’ve bypassed the 10k limit on Hubspot APIs. You can pull upto 250k rows.

2. We’ve done all possible associations between objects
3. Preview data before importing to Sheets

4. Insert, Update and Associate data from Google Sheet to HubSpot
Do try it out, and let me know if this solves your usecase

Been using Superjoin for this and works like a breeze. It’s 2-way, so whatever you edit on Sheets also gets reflected here.

You can definitely do this using Coefficient from HubSpot’s marketplace. It enables a 2-way sync of data between Google Sheets / Excel and HubSpot, which means you can also push data from Sheets into HubSpot.

  1. You’ll point and click to map and upload your Sheet data back into HubSpot — either creating new records or updating existing ones.
  2. Once the data is in HubSpot, you can trigger workflows using properties or lists tied to those records.

You can even schedule this sync so your Sheet and HubSpot stay aligned automatically.

Here’s a quick video demo: