How do I create automation to transfer contacts from Google Sheets to HubSpot for free?

Hi @Branch192 PR 

Good question.

Can you clarify what you mean by it’s not updating the HubSpot Lists?

NOTE: The Zapier free plan only comes with 100 Tasks/month.

With the 2 step Zap you’ve configured, that will only work to add/update 100 Contacts from GSheets.

Hey @Troy Tessalone sorry I didn’t expect an reply right away.

I have separate lists in Hubspot, for example.

1. Executive
2. Members
3. Other

And I have three different lists in Google Sheets, named the same.

Zapier seems to pull everything from Google sheets, even when I add new rows and change infos.

Zapier is supposed to send those details, including new entries to Hubspot, based on the Zap created. It does not.

Regarding your Note:
The test list I am using right has only 27 members, I doubt I will be adding or editing more than 10-20 contacts per month.

Yes, some lists have more, but if for the next few months it only adds a 100 at a time, until the lists are complete on Hubspot.  I can handle that.

I hope this helps you with helping me solve this.

Thank you.

@Branch192 PR 

Can you post screenshots with how the top couple rows of your GSheet tabs are configured?

Help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

Sure thing. I have to fake emails at the bottom (as you can see) and I blacked out the other private infos.  I hope that is okay and enough infos for you to go on.

 

Cheers

@Branch192 PR 

If you are trying to add Contacts to Lists, then you will need to add this Zap action: HubSpot - Add Contact to List

I'm getting an "Unable to add unknown contact to list" error

The Add Contact to List action requires that the contact already be in HubSpot before they can be added to a list. The best way to ensure this is to add the HubSpot Create/Update Contact action before the Add Contact to List action. This guarantees that the contact exists and can then be added to the list.

Smart List is not available in the dropdown

The Add Contact to List action only works with Static Lists in HubSpot. Smart Lists will not show up here. You'll need to change your list in HubSpot to be a static list, or else use the Create/Update Contact action to update the property that would make a contact automatically qualify for a Smart List.

Is this a 3rd action (extra cost) or does this replace the action I used?

I am guessing it is a 3rd action as this will need to be added before “ HubSpot Create/Update Contact “

I will try it with just the 2 and see if it still works...if not I guess I can’t use Zapier to help.

If any more suggestions are available, even outside of Zapier, I am more than willing to try them out.  Thanks for your ongoing help @Troy Tessalone 

Cheers

Boo :(

@Branch192 PR 

It would be added as Step 3.

I'm getting an "Unable to add unknown contact to list" error

The Add Contact to List action requires that the contact already be in HubSpot before they can be added to a list.
The best way to ensure this is to add the HubSpot Create/Update Contact action before the Add Contact to List action.
This guarantees that the contact exists and can then be added to the list.

So unfortunately I won’t be able to use Zapier to do this as I am only allowed 2 steps in the free version.

….Unless I can create to different Zaps.  One to do the pulling and one to do the putting.  Problem is I am limited to 5 in the free account as well.

Thanks

@Branch192 PR 

Thank you, it will be hard to convince the group to do this but if I am given a budget, I might use it for this.

I also tried to do this:
 

Where Step 1 is:

And Step 2 is:

Which I might have mixed up.  Also when I originally started this forum post Hubspot was showing that the last time my lists were updated was June 29th. However when I returned to today to look at your response one of the lists shows July 21 exactly 5 ago when I reached out.  So Banana Peel got added, but didn’t show up until today.  Perhaps Zapier is slow to send, or Hubspot slow to retrieve. Hmm
 

Hi there @Branch192 PR! 👋

It’s very odd that it took days to trigger the Zaps and add the test contact to the list. From your recent screenshots it looks like the Zaps were edited recently. When editing, did you run any tests in the Zap that would have added the Banana Peel test contact to the HubSpot list? If so, then I’m thinking that might account for the long delay in the Zaps seeing the contact.

If you add another contact to the Google Sheets spreadsheet now, while the Zaps are still switched on, that should then trigger the first Zap, followed by the second Zap that then adds the contact to the relevant HubSpot list.

Can you give that a try and confirm whether the Zaps trigger and add the contact as expected? Keen to ensure you’re all set here! 🙂