Weekly data export to Google Sheets via ZapierSOLVE
Mar 20, 2019 1:41 PM
Struggling with this one a little...
I need to get contacts from HubSpot to a Google Sheet, on a weekly basis. Same criteria for the contacts but of course new ones may be added or some removed each week so needs to be dynamic.
Zapier triggers seem limited, so I ended up going for 'contact has been added to a list'. Set up a workflow that pulls them in, adds them to a list, waits some time and then removes them before waiting 7 days and then going round again.
- They aren't re-enrolling despite having re-enrollment criteria on
- If new contacts meet the criteria in that week, they go into the workflow and then I end up with contacts being added to and removed from the list at random points. Not the simple export of data on a weekly basis that I needed.
Am I missing something here, is there an easier way to do this? Essentially just need a group of people in HubSpot sent to a Google Sheet along with set properties, at say 6am on a Monday morning. Seems so simple!
Advice much appreciated
Solved! Go to Solution.