Export contacts in HubSpot list to Google Sheet every hour | Zapier Community

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

Page 1 / 1

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