Wanting to use zapier to pull contact data from hubspot based on a contact property criteria and then create a new worksheet all the contacts returned.
This isn’t dependant on a property changing in hubspot, rather I’d just like to pull all the contact data for current customers in Hubspot and put them into a new worksheet in google.
Thoughts?
Best answer by Troy Tessalone
Most Zap app integrations are best suited to act upon 1 record at a time (trigger/action/search) in real-time VS taking action on bulk records on a scheduled (cron) job.
Bulk records present a different set of challenges to factor in when trying to do automation.
For example, a bulk record set could include from 0-infinite number of records.
Some apps don’t work well trying to handle large volumes of data at one time.
(e.g. GSheets has file size limits to be mindful of.)
There are race limits and throttling aspects to deal with with the apps involved.
Along with pagination and max records per page, offsets, filtering, sorting, etc.
Generally, bulk actions are best suited for leveraging an app’s APIs: https://developers.hubspot.com/docs/api/overview
App APIs to handle bulk actions are often custom coded to serve specific use cases such as yours.
To be clear, I’m not saying it can’t be done using Zapier, but it would involve a much more advanced approached using technical concepts beyond the basic plug and play capabilities that Zapier focuses on.
+14Hi
Without over engineering an automated solution, it may be best/simplest to set a reminder and do this Task manually once per month in HubSpot.
Check out these HubSpot articles about exporting data:
https://knowledge.hubspot.com/crm-setup/export-contacts-companies-deals-or-tickets
https://knowledge.hubspot.com/lists/export-your-lists
https://knowledge.hubspot.com/account/export-your-content-and-data
Thanks, I get that I can have it done manually. Interesting thing is we are on a Zapier community thread with a product that is all about automation, yet a very simple thing … get data from one source and put it into another is … a manual task. I’m very confused.
I get the over-engineering part and I appreciate that. I am looking for an automated solution to a pretty simple problem. Maybe zapier isn’t that tool. Not sure yet.
Thanks much for your suggestions.
+14Most Zap app integrations are best suited to act upon 1 record at a time (trigger/action/search) in real-time VS taking action on bulk records on a scheduled (cron) job.
Bulk records present a different set of challenges to factor in when trying to do automation.
For example, a bulk record set could include from 0-infinite number of records.
Some apps don’t work well trying to handle large volumes of data at one time.
(e.g. GSheets has file size limits to be mindful of.)
There are race limits and throttling aspects to deal with with the apps involved.
Along with pagination and max records per page, offsets, filtering, sorting, etc.
Generally, bulk actions are best suited for leveraging an app’s APIs: https://developers.hubspot.com/docs/api/overview
App APIs to handle bulk actions are often custom coded to serve specific use cases such as yours.
To be clear, I’m not saying it can’t be done using Zapier, but it would involve a much more advanced approached using technical concepts beyond the basic plug and play capabilities that Zapier focuses on.
+14Here’s a GSearch about “HubSpot scheduled exports” which may lead you in the right direction: https://www.google.com/search?q=hubspot+scheduled+export
Also, you may want to consider hiring a Zapier Expert to help: https://zapier.com/app/get-help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
