Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi there! 

 

My goal is to export contacts (and their properties) from a dynamic list in Hubspot into a Google Sheet. Additionally, whenever a new contact is added/removed from this list in Hubspot (based on the dynamic list filter properties), the Google Sheet will update on a scheduled basis. Maybe weekly, daily, doesn’t really matter.

 

I am quite new to Zapier, so I’ve only got as far as using the below zap. The first issue is that it does not import existing contacts from this list into Google Sheets, therefore only one (test) contact appeared when running the zap. 

Additionally, I am unsure whether it is possible to have this ‘live’ update/refresh in which I mentioned above. Is there some sort of scheduler I missed in the settings? If so, will this only add new contacts, and not remove those who are not part of the list within hubspot anymore.

 


 

Sorry if my explanation seems complex for somewhat of a simple goal, but any help or advice would be greatly appreciated! 

 

Thanks a lot! 

 

 

 

 

Hi @MazumaRex 

Good question.

 

Zaps work while turned ON for new data going forward.

The HubSpot Zap app does not have a trigger for Contact Removed from List.

 

You’d likely need to use the HubSpot API to get Contacts on a List at a given time: https://legacydocs.hubspot.com/docs/methods/lists/get_list_contacts

 

App APIs can be used in Zaps with the Webhook app as an action step: https://zapier.com/apps/webhook/help

The Schedule app can be used to trigger Zaps at set times: https://zapier.com/apps/schedule/help

Using App APIs is an advanced approached, so consider hiring a Zapier Expert for help: https://zapier.com/experts

 

For existing data, might be best to do an initial manual export from HubSpot and import into GSheets.

Thanks for the quick reply! Working on setting up this right now. 

 

So far have started with:

Trigger: Schedule by Zapier

Action: “Webhook by Zapier” 

 

As for your note on “The HubSpot Zap app does not have a trigger for Contact Removed from List.”, is it possible for the whole list to be refreshed on a schedule by using the App API you mentioned?  I agree, an expert is probably needed, but now I am just curious whether this ‘data refresh’ feature is possible to do easily without one. 

 

Again, thanks! 

@MazumaRex 

Please clarify what you mean by data refresh and where.

GSheets doesn’t have an option to clear a GSheet Worksheet data.

GSheets has a Delete Row option but that will leave blank rows.

Hey @MazumaRex were you able to get your Zap up and running? I’m curious to see what you were able to come up with as a solution, or if you ended up reaching out to an expert?🤔

Terms & Conditions