Question

Export contacts in HubSpot list to Google Sheet every hour


Hi all.

First post here.

 

I’m trying to work with the Zapier Scheduler, to every hour export the contacts of a hubspot list into a google sheet.


I only triggers i can manage to work with are ‘when a contact is added to a list’ rather than export the contents of the list

 

any suggestions?

 

thanks


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

2 replies

thanks Rob - i’ll give it a try 

Userlevel 7
Badge +9

Hi @SeekingHelp,

 

Here’s the workflow you’ll need to build:

  • Trigger: Schedule by Zapier: Set your time
  • Action: You can’t just use search option as it’ll only send a single contact, instead, you need to use “webhook by Zapier” and make an API call to hubspot list endpoint. The result will be a series of line-items of all of your contacts in that list: https://legacydocs.hubspot.com/docs/methods/lists/get_list_contacts
  • Action: Use “Looping by Zapier” to take one item at a time
  • Action: Google sheet: add a row