HubSpot is one of the leading CRMs for fast-growing companies. It allows you to run your marketing and sales pipelines smoothly from a single web application. 

But there is a problem. HubSpot offers limited tools to track and analyze your data. To answer your most pressing analytical queries you need to work with the raw data that is hidden in your CRM.

Unlock HubSpot CRM with Keboola

Keboola is a data platform that allows you to export data from HubSpot (among 250 other integrations) to the destination of your choice. 

With Keboola you can:

• Extract HubSpot data about Companies, Contacts, Deals & Pipelines, Campaigns, Email Events, Engagements, Contact Lists, and Owners
• Transform your data (clean it, aggregate it, compute metrics and KPIs)
• Save the data to a destination of your choice
• Integrate HubSpot data with other BI tools to help you track and analyze your KPIs
• Automate the entire pipeline, so you do not have to worry about weekly or monthly reporting. Just set it and forget it - let Keboola do the heavy lifting for you. 

Did we mention Keboola offers a no-questions-asked, always-free tier, so you can export all your data today. 

In this article, we will show you how to extract and automate your HubSpot data with Keboola.

Step 1: Prerequisites

There are two prerequisites to make the data extraction work:

1. You need to have a working HubSpot account (surprising, isn’t it?)
2. You need to get a HubSpot API key

Let’s go through the steps of getting a HubSpot API key:

1. In your HubSpot account, click the settings icon ⚙ in the main navigation bar.
2. In the left sidebar menu, navigate to Integrations > API key.

1. If a key has never been generated for your account, click Generate API key.
2. If you've already generated an API key, click Show to display your key.

Step 2: Set up Keboola’s HubSpot extractor

Navigate to your Keboola account (or sign-up for a free one) if you have not already and:

1. Select Components in the main navigation bar.
2. Under Directory, type “HubSpot” in the search bar.
3. Click on the Use This button next to the HubSpot data source extractor

Step 3: Configure Keboola’s HubSpot extractor

This step is all about specifying what type of data you would like to see exported.

Start by connecting Keboola’s HubSpot extractor with your HubSpot account by simply copy-pasting the API key from Step 1 into the API token window:

Next, specify the parameters of your HubSpot data collection:

1. Period from date [including] - the start date from which to begin data extraction. It can be specified as an absolute date (in the format YYYY-MM-DD) or as a relative date (e.g. “yesterday” or “1 month ago”). If you leave this field empty, Keboola’s extractor will export all available data.

2. Endpoints - check what information you would like exported.

3. Load types - control what happens to new data. With “Full Load” the existing data will get overridden. With “Incremental Update” only new records will be inserted. 

4. Automate - click on automate (right-hand-side), chose the frequency of how often you would like data updated, and set the entire export on autopilot. No need to worry about exporting data again, Keboola will do the heavy lifting for you. 

5. Click Save to make sure all your configuration preferences are recorded. 

6. (Optional) If you want to extract data now, click on Run component (right-hand-side)

Step 4: View your data

Keboola will automatically extract data from your HubSpot account and organize it according to the schema you selected in the previous step. 

Because we selected multiple tables to be exported (companies, campaigns, …), Keboola will smartly organize that data together in a HubSpot bucket.

To check your data go to Storage in the main navigation menu and find the bucket with your HubSpot data. (pro tip: enter the keyword “hubspot” in the “search all buckets and tables” bar to find it faster).

By clicking on the bucket name (“kds-team-ex-hubspot-crm-5631324” in this example), you get an overview of all your tables and the data inside them.

Step 5: Take your HubSpot data to the next level

Now it is time for you to shine.

There are multiple things you can do with the extracted HubSpot data at this point:

1. Dive deeper and manually inspect data. Simply click on the table name in the last view we showcased to check all the table’s attributes and view sample data.
2. Transform data to reshape it into your desired format. Read our guide to data transformations for inspiration.
3. Dive into the documentation of the HubSpot extractor to even better understand what are your options when configuring your extractions.
4. Connect your data with a BI tool, such as Looker, to visualize and analyze the data further. Here is a complete guide.
5. Export your data to over 100 different destinations, such as OneDrive, Google Drive, Amazon S3, and hundreds more.