Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I extract a list of all Hubspot contacts created in 2024 into a Google Sheet?

Hello,

 

I need Zapier to find all HubSpot contacts created in 2024, and then add them into a Google Sheet.

 

How do i do this? I can only seem to get Zapier to find the latest created HubSpot contact, but not all contacts created within 2024/a date range.

Hi ​@cloak 

HubSpot has native export functionality: https://knowledge.hubspot.com/import-and-export/export-records

Thanks Troy,

 

Unfortunately that would be a bit more manually than needed.

 

For further context, after the Google Sheet is populated with the HubSpot contact data, there will be a number of formulas consuming the data and providing various metrics.

The main reason to use Zapier to do this is that I would build the Zap scheduled for it to run every day (can copy over old data etc in Google Sheets) so that it picks up any new HubSpot contacts created and allows the formulas/metrics consuming the data to update as needed.

The problem is, I cant figure out how to just get an extract of all 2024 HubSpot contacts using Zapier and would prefer not to manually run reports and then copy/paste data in Google sheet etc.

​@cloak 

To backfill data it would make more sense to do a one-time manual export of the Contact data from HubSpot to add to the GSheet.

Then you can configure a Zap to trigger for new contacts.

  • HubSpot - New Contact
  • HubSpot - New Contact in List

 

NOTE: Using a GSheet worksheet with formulas in the rows you are trying to add data to could impact the Zap behavior and may lead to unexpected results.
(We don’t have enough info to know how your GSheet is configured that you are trying to use.)

​@cloak 

Furthermore, most Zap actions for apps work on a per record basis, meaning a single record.

For your use case, you would have to explore using the HubSpot API to query for Contact records that meet certain conditions.

Plus, that likely introduces the need to handle pagination as there will only be N results per page that you would need to iterate thru, which adds more complexity to the Zap steps.

 

HubSpot API: https://developers.hubspot.com/beta-docs/reference/api/overview

Zap action: HubSpot - API Request

Reply


Terms & Conditions