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.

Userlevel 7

+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

Sign up