How do I extract a list of all Hubspot contacts created in 2024 into a Google Sheet?

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