Export contacts in HubSpot list to Google Sheet every hour

  • 6 July 2021
  • 2 replies

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?



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:
  • 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