Hello! I currently have a Zap set up to take Looker data via the Zapier integration, split it into line items (one record per Hubspot company ID), and a loop to update a company property within Hubspot.
It works but takes up a task for each company, and there are over 5K Hubspot companies to update weekly (over 20k tasks a month).
My question is if I'm even doing this correctly or efficiently? My hope was that Zapier could take the entire Looker payload and process it into Hubspot as one or a handful of tasks.
Thanks in advance!
Best answer by BadgerBest answer by Badger
Hubspot appear to allow batch updates to companies via their API.
I’m not certain about this as it occurred to me, you could use a python code block to post to the API via requests. You would still need to limit the data as you’ll have constraints from Zapier and Hubspot to worry about.
You may get up to 100 company updates every 10 seconds. I’m assuming you could use a wait loop inside the code to slow down the requests, allowing you to double the count each run. You’ll need to watch the script as there are script runtime limits.
I’m assuming this is enough to send around 200 updates you could organise the data or run a series of code blocks or use Looping. It may be possible get all 5000 out in 25 cycles. However, looping has its own limitations.
If it works though you’ll reduce the number of tasks each week.
Hubspot appear to allow batch updates to companies via their API.
I’m not certain about this as it occurred to me, you could use a python code block to post to the API via requests. You would still need to limit the data as you’ll have constraints from Zapier and Hubspot to worry about.
You may get up to 100 company updates every 10 seconds. I’m assuming you could use a wait loop inside the code to slow down the requests, allowing you to double the count each run. You’ll need to watch the script as there are script runtime limits.
I’m assuming this is enough to send around 200 updates you could organise the data or run a series of code blocks or use Looping. It may be possible get all 5000 out in 25 cycles. However, looping has its own limitations.
If it works though you’ll reduce the number of tasks each week.
When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.
More about cookies
Customize which cookies to allow
Marketing cookies
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Social media cookies
label
These cookies are set by a range of social media services that we have added to the site to enable you to share our content with your friends and networks. They are capable of tracking your browser across other sites and building up a profile of your interests. This may impact the content and messages you see on other websites you visit. If you do not allow these cookies you may not be able to use or see these sharing tools.
Analytics/performance cookies
These cookies enable the website to provide enhanced functionality and personalization, and allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. These cookies may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly and we will not know how you are using our site.
Functional cookies
label
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
Essential cookies
Always active
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.