Question

Export contacts in HubSpot list to Google Sheet every hour

  • 6 July 2021
  • 2 replies
  • 111 views

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

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

thanks Rob - i’ll give it a try