Import Crunchbase Data To Google Sheets

How to import Crunchbase data to Google Sheets
Reading Time: 6 minutes

In this article, we’ll learn how to use Crunchbase API to import Crunchbase data to Google Sheets.

Crunchbase is a platform that provides information about companies–private as well as public. The information it provides includes investment and funding, founding members, initial public offerings, mergers and acquisitions, and company profiles among others. To closely track and keep up with the developments in the business sphere, we can integrate Crunchbase with Google Sheets using Amigo and get its data delivered to us.

Below is a sample of funding data imported from Crunchbase to Google Sheets.

Data imports from Crunchbase to Google Sheets

Using Amigo Data, a data integration and automation tool, we can import Crunchbase data to Google Sheets, automate the data import and receive snapshots of the data directly into our inbox or to Slack.

Here are the steps to import data from Crunchbase to Google Sheets.

  1. Install the Amigo Data add-on
  2. Generate Crunchbase API key
  3. Get the data endpoint 
  4. Import the data to Google Sheets

How to import Crunchbase data to Google Sheets

Install the Amigo Data add-on

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace to import Crunchbase data to Google Sheets.

Click here to install.

Install the Amigo Data add-on to import Crunchbase data to Google Sheets

Alternatively, you can get it from Google Sheets.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo Data and install

Generate Crunchbase API key

To get generate Crunchbase API key, follow the steps below.

1. Log in to your Crunchbase account.

2. Navigate to Account Settings from the Crunchbase home page.

Navigating to the Account settings page

3. Select View All Integrations.

Crunchbase settings page

4. Select Crunchbase API to create an API key.

Getting Crunchbase API

5. Click the GET ACCESS button.

Generating Crunchbase API key

6. Fill in the name, select the use case check the acknowledgement and click ACCEPT.

Selecting a use case for the API

7. Click the GENERATE button to create your Crunchbase API key.

Generating Crunchbase API key

8. The Crunchbase API key will be generated after a few seconds and shown in dialog box. Note the key and keep it confidential.

Crunchbase API Key

Get the endpoint of the data

We’ll use SmartBear SwaggerHub to choose the endpoint and generate the API request URL for the endpoint. The SwaggerHub interface is an easier, more user-friendly and less technical documentation.

Go to the Crunchbase API SwaggerHub page.

To access Crunchbase API data and response functionality within SmartBear SwaggerHub, we need to first authorise it. Click the Authorize button.

Authorizing the Swagger page

In the Value field, enter your API key and click Authorize.

Entering the key to authorize

After authorizing SwaggerHub with the Crunchbase API key, we’ll be able to run API queries in SwaggerHub.

Given on the page is a list of all data endpoints that we can retrieve from Crunchbase.

Select an endpoint category.

Choosing Crunchbase API endpoint

Click the Try it out button.

Running the API

Fill in the query parameters according to your choice.

  • In the entity_id field, enter the permalink or the UUID of the company to look up in the entity_id field. The permalink is usually the name of the entity, eg, stripe to retrieve information about the company Stripe.
  • The fields_ids are information about the attributes of the company, such as social media profiles, company type, founding date, funding stage, funding raised, and so on.
  • The card_ids are information concerned with the functioning of the firm. The possible values are mentioned above the entry field.
Filling in the Crunchbase API parameters

Note: The field_ids can be found by clicking the response schema. The values listed under properties are the field_ids. And those under cards are the card_ids.

Available field id values

Once you’ve filled in the desired parameters, click the Execute button to run the query. The endpoint URL for the specified parameters will be generated and shown in the Responses.

The response URL

The Request URL is the Crunchbase API endpoint URL we’ll use to import Crunchbase data to Google Sheets. Copy the URL. Note also the headers.

Import the data to Google Sheets

Go back to Google Sheets and launch Amigo Data by clicking Extensions→Amigo Data→Connect.

Launch Amigo Data to import data from Crunchbase to Google Sheets

Then select Custom API from the list of sources.

Choose Custom API as the source to connect

Paste the Crunchbase API endpoint URL in the API URL field.

Enter the Crunchbase API endpoint URL

Then expand the Details tab and enter the headers.

Entering the header values

Click the PREVIEW button. Flatten the nested datasets. Then click IMPORT.

Previewing and flattening the data

The data will be imported into Google Sheets in a short while.

Snippet of the imported data

Once the initial connection has been set up, the data can be pulled automatically from Crunchbase into Google Sheets so that you don’t have to repeat the whole process of importing the data. You can set a refresh schedule to update the data automatically at regular intervals–hourly, daily, weekly or on certain days.

Note: This article used the Crunchbase free plan (Basic API) to import Crunchbase data to Google Sheets, which is limited to retrieving a few information about organisation attributes. For information such as funding, investments made, retrieving a list of firms that have raised a certain amount (say, $50 million), investments made by a venture capital firm, and so on, the Crunchbase Enterprise plan is required.

To make any search query such as searching for firms with, say funding between 50 million USD and 100 million USD, we need to make a post request. The query parameters have to entered in JSON.

After entering the parameters, click Execute.

POST response

The response has three parts–the URL, the headers and the body. Each of these has to be entered separately to fetch the data.

Change the method from GET to POST and enter the endpoint URL. Then expand the Details tab and enter -H values as headers and -d (the whole JSON code) as the body. The apostrophes are to be avoided in all the cases.

Then follow the steps mentioned above to import the data to Google Sheets.

For more information, check the Crunchbase API documentation.

Some commonly asked questions

Yes, you can export data from Crunchbase and save them as a CSV file. But for this you need either the “Pro” or the “Enterprise” plan; and you can only download them in bulk. A better approach is to retrieve data from Crunchbase using its API and import them directly into Google Sheets using data integration tools such as Amigo Data.

The Crunchbase API is free for limited use. Its free Basic API allows access to information such as an organization’s social links, description and such other attributes related to the company. For other information like funding, IPOs, investments, and so on, the Enterprise plan is required.

The UUID is a unique identifier used to access the Crunchbase database. Every entity is assigned a unique ID. This ID can be found using the “Autocomplete” endpoint. Enter the organization for which you want to find the UUID or the permalink in the “query” field and run the query to get their values.

See also

There are several other sources from where you can import data into Google Sheets, such as EOD Historical Data, Yahoo Finance, Nasdaq, Twitter, and Binance, to name just a few.

For these and many more, you can visit our blog.

Some similar articles you may be interested in.

Import Zillow Data to Google Sheets

Automate data imports from Bloomberg to Google Sheets

Import NSE Data To Google Sheets

Leave a Reply