Skip to main content
Best answer

Updating Hubspot company properties using Looker data for 5k+ companies

  • November 22, 2024
  • 1 reply
  • 15 views

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.

See Hubspot Docs:
https://developers.hubspot.com/beta-docs/reference/api/crm/objects/companies/v3#patch-%2Fcrm%2Fv3%2Fobjects%2Fcompanies%2F%7Bcompanyid%7D

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Badger
Forum|alt.badge.img+5
  • New
  • 134 replies
  • Answer
  • November 23, 2024

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.

See Hubspot Docs:
https://developers.hubspot.com/beta-docs/reference/api/crm/objects/companies/v3#patch-%2Fcrm%2Fv3%2Fobjects%2Fcompanies%2F%7Bcompanyid%7D