Question

Export Dynamic List From HubSpot to Google Sheets, weekly?

  • 26 April 2022
  • 4 replies
  • 133 views

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! 

 

 

 

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

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! 

Userlevel 7
Badge +14

@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.

Userlevel 3
Badge +4

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?🤔