Import Crunchbase Data To Google Sheets

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

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 get information about companies such as fundings, investments, mergers and acquisitions, Crunchbase is the authoritative source. To closely track and keep up with the developments in the business sphere, we can integrate Crunchbase with Google Sheets and get its data delivered to us. We’ll learn how in this article.

Using Amigo Data, a Google Sheets extension, 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.

Steps on how to import Crunchbase data 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

Install the Amigo Data add-on

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace. Click here to install.

Install the Amigo Data add-on

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 access to your personal API key, complete the steps below:

1. Login/Sign Up to your Crunchbase account

2. Navigate to Account Settings

Navigating to the Account settings page

3. Select View All Integrations

4. Select Crunchbase API

Getting Crunchbase API

5. Click the GET ACCESS button

Get access button

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

Generating Crunchbase API key

8. The key will be generated after a few seconds and shown in dialog box. Copy the key.

Crunchbase API Key

Get the endpoint of the data to import to Google Sheets

We’ll be using 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 SwaggerHub page

To access request and response functionality within 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

Then select an endpoint category.

Choosing and endpoint

Click the Try it out button.

Try it out button

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 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 endpoint URL we’ll use to import the data to Google Sheets. Copy the URL. Note also the headers.

Import the data to Google Sheets

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

Launch Amigo Data extension

Then select Custom API from the list of sources.

Choose Custom API as the source to connect

Paste the endpoint URL in the API URL field.

Pasting the endpoint

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 we don’t have to repeat the whole process of importing the data. You can set a refresh schedule to update the data at regular intervals–hourly, daily, weekly or on certain days.

This article used the Crunchbase free plan (Basic API) 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 paste the 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.

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