topic Re: Exporting Data via API in APIs & Integrations

Exporting Data via API

taran42 — Fri, 04 Sep 2020 17:38:56 GMT

I am looking to have an automated script that I will export some of my data from Hubspot (Companies, Contacts and Deals) via the API and save that data in a separate Excel file for each. I looked into the API tutorials that Hubspot had to offer and it looks like using the API will export the data I want into a JSON format. How then can I take that data and transfer it into an Excel document?

I have seen a similar extract performed in PowerShell and Python, but I am not versed enough in either of those to write the script for myself.

Re: Exporting Data via API

Mike_Eastwood — Sat, 05 Sep 2020 01:14:57 GMT

Hi @taran42

You'd need a script to convert the JSON data to CSV or Excel – it's not rocket surgery but it would require custom code.

Our team builds Custom HubSpot Integrations, please contact me if you'd like to know more.

Cheers

Mike

Re: Exporting Data via API

taran42 — Tue, 08 Sep 2020 13:52:12 GMT

Mike, thanks for the reply. Do you know if there is a way to pull Hubspot data directly into a CSV? Or is the only output from Hubspot JSON (and then converting that)?

Re: Exporting Data via API

Mike_Eastwood — Tue, 08 Sep 2020 23:44:12 GMT

Hi @taran42

You can manually export a spreadsheet from HubSpot.

Or use the APIs to get JSON.

Working with CSVs programatically is flakey so JSON is a much better format.

Have fun

Mike

Re: Exporting Data via API

taran42 — Wed, 09 Sep 2020 19:21:21 GMT

Mike, thank you for your help. I was able to pull the JSON from Hubspit via the API in Python and then converted it to a CSV with the Pandas module.

Re: Exporting Data via API

johnelmer — Tue, 06 Oct 2020 00:33:32 GMT

There is now an app in the HubSpot App Marketplace called Ultimate Data Export for HubSpot. You can export the following data tables and their associations directly to Microsoft Excel:

Contacts
Web Analytics
Companies
Deals
Deal History
Owners
Campaigns
Engagements
Emails
Products
Tickets
Forms
and more related subdata such as Pipelines and Associations.

Please mark this as a solution if it helps address your needs.

John

Re: Exporting Data via API

shoes2334 — Thu, 27 May 2021 19:06:03 GMT

Hi John.

Thanks so much for this awesome product.

Is there a way to use your product directly through an API for automation?

Thanks!

Re: Exporting Data via API

johnelmer — Fri, 28 May 2021 12:43:23 GMT

@shoes2334 There are a couple of options in the HubSpot App Marketplace that can meet your needs. One option is the Excel Integration for HubSpot. Using this app, your HubSpot data can be set up to refresh in Excel on a regularly scheduled basis.

Re: Exporting Data via API

GKasireddy — Thu, 17 Feb 2022 07:38:08 GMT

Hi taran42,

How to pull contacts list data from HubSpot into Excel file via API. Please provide any API you are using?

I am using the below API for fetching contacts list.

https://api.hubapi.com/crm/v3/objects/contacts

Thank you.

Re: Exporting Data via API

taran42 — Thu, 17 Feb 2022 20:40:12 GMT

@GKasireddy The API you linked should work for getting the data out of Hubspot (I used v2). Once you get the JSON file file, you can use Python to convert that into an Excel file or another tool. Ultimately I brought the JSON data into Alteryx as a BLOB and converted it there.

Re: Exporting Data via API

GKasireddy — Fri, 18 Feb 2022 06:58:55 GMT

Thanks taran42. It is working.

Re: Exporting Data via API

DduPlessis — Wed, 13 Jul 2022 16:12:48 GMT

Hi @Mike_Eastwood

Is there a way to pull relevant data from HubSpot to an Adobe integration to fill in a Certificate template? Like for example your First and Last name

Re: Exporting Data via API

DduPlessis — Fri, 15 Jul 2022 09:28:44 GMT

Hi @Mike_Eastwood

Is there a way to pull relevant data from HubSpot to an Adobe integration to fill in a Certificate template? Like for example your First and Last name

Re: Exporting Data via API

dreamerdad — Fri, 09 Dec 2022 18:57:24 GMT

Can someone clarify the API query parameters I should use to pull utm source data as shown below? Alternatively, I'd like to schedule weekly reports to my email address with the report being sent in the form of a CSV attachment and then auto-pull that csv attachment into a google sheet (via google apps script) and then use that google sheet as a data source in our Looker data studio report. Is there any way to do the former? Any way to do the latter using Ultimate Data Export for HubSpot? I would prefer to use the Hubspot API directly rather than via Ultimate Data Export for HubSpot

Re: Exporting Data via API

ytulsi — Mon, 23 Jan 2023 16:28:04 GMT

Certain types of exports can now be done via API. This feature is in public beta. More information here: https://developers.hubspot.com/docs/api/crm/exports

Re: Exporting Data via API

JasonTisdall — Mon, 17 Feb 2025 15:24:25 GMT

Hi John

We would like to be able to triggere regular exports of Deal dat from various pipelines. Other spreadsheets within our systems can then pick this data up automatically.

Is that something you can help with?

cheers Jason

Re: Exporting Data via API

johnelmer — Mon, 17 Feb 2025 16:20:40 GMT

@JasonTisdall Ultimate Data Export was developed to be a one-time manually triggered export of virtually all HubSpot data available via the APIs. It comes to you as an Excel file via email. It's not the right long-terms solution regular data exports.

I suggest looking at our app in the HubSpot App Marketplace called MS SQL Server Integration for HubSpot. Rather than exporting your data to Excel like UDE, this integration automatically extracts, transfers and loads your HubSpot data into your own secure SQL Server database. (The SQL Server data warehouse in Azure is included in the subscription cost and is automatically configured when you purchase a subscription. Subscriptions allow for unlimited users at a flat rate.)

Once your HubSpot data is synchronized with the SQL Server data warehouse, the SQL database automatically refreshes from HubSpot on a scheduled basis (several refresh rates are available). You can connect this SQL database to any other application that has a SQL connector (such as Microsoft Excel).

Re: Exporting Data via API

JasonTisdall — Mon, 17 Feb 2025 17:24:01 GMT

John
Thanks. I'll look into it
Jason

Re: Exporting Data via API

RobertYoung — Wed, 02 Apr 2025 09:18:47 GMT

If you're aiming to export a lot of data regularly, building your own custom script can definitely work, but you'll need to manage pagination and error handling carefully.

Alternatively, using a third-party tool like Skyvia might save you some headaches—it handles those API quirks behind the scenes and lets you automate the exports easily.

Re: Exporting Data via API

zafarkahn — Sat, 05 Apr 2025 16:42:57 GMT

Nice