Integration spotlight: Crunchbase

Overview

Our Crunchbase integration makes finding companies and investors simple, easy, and efficient.

API limits

Each request made costs $0.01 and returns as many data points as possible within dashdash’s cell limits.

Functions

Our Crunchbase integration contains the following functions:

Function Description
GET_COMPANY_DETAIL_CRUNCHBASE Get a company’s details using its name or domain.
GET_INVESTOR_DETAIL_CRUNCHBASE Get an investor’s details using their name or domain.
SEARCH_COMPANIES_ADVANCED_CRUNCHBASE Get companies matching your search criteria.
SEARCH_COMPANIES_AT_EVENT_CRUNCHBASE Get companies that attended an event.
SEARCH_COMPANIES_BY_EX_EMPLOYER_CRUNCHBASE Get companies that match founder details.
SEARCH_COMPANIES_BY_FOUNDER_EXITS_CRUNCHBASE Get companies that match founder details.
SEARCH_COMPANIES_BY_FUNDING_CRUNCHBASE Get companies that match funding details.
SEARCH_COMPANIES_BY_INVESTORS_CRUNCHBASE Get companies based on their investors.
SEARCH_COMPANIES_BY_KEYWORDS_CRUNCHBASE Get companies based on your keywords.
SEARCH_COMPANIES_BY_SIZE_CRUNCHBASE Get companies based on the number of employees.
SEARCH_EVENTS_CRUNCHBASE Get events based on your criteria.
SEARCH_FUNDING_ROUNDS_CRUNCHBASE Get companies that match funding details.
SEARCH_INVESTORS_BY_ACTIVITY_CRUNCHBASE Get investors that participated in a given funding round.

GET_COMPANY_DETAIL_CRUNCHBASE

Get comprehensive details about a company using its name or domain.

:memo: Note: We return all the lead investors for a given funding round and up to four non-lead investors.

Syntax

GET_COMPANY_DETAIL_CRUNCHBASE(domain_or_name, [location])

Parameter Mandatory Description
domain_or_name Yes Company name or domain. For example: "apple" or "apple.com".
location No One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".

Examples

To get details about apple.com:

=GET_COMPANY_DETAIL_CRUNCHBASE("apple.com")

To get details about apple.com located in California:

=GET_COMPANY_DETAIL_CRUNCHBASE("apple.com", "California")

Company detail example

GET_INVESTOR_DETAIL_CRUNCHBASE

Get comprehensive details about an investor using their name or domain.

Syntax

GET_INVESTOR_DETAIL_CRUNCHBASE(domain_or_name, [location])

Parameter Mandatory Description
domain_or_name Yes Investor name or domain. For example: "Accel" or "accel.com".
location No One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".

Examples

To get details about accel.com:

=GET_INVESTOR_DETAIL_CRUNCHBASE("accel.com")

To get details about accel.com located in California:

=GET_INVESTOR_DETAIL_CRUNCHBASE("accel.com","California")

Investor detail example

SEARCH_COMPANIES_ADVANCED_CRUNCHBASE

Get a list of companies that match your search criteria.

Syntax

SEARCH_COMPANIES_ADVANCED_CRUNCHBASE(employees, [location], [industry], [last_funding_date], [last_funding_amount], [last_funding_type], [total_funding], [investor1], [investor2])

Parameter Mandatory Description
employees Yes Number of employees. For example: ">50".
location No One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".
industry No One or more industries or industry groups. For example: "Banking", "Banking,Fintech", or "Lending and Investments".
For a list of supported industries, check Crunchbase’s documentation.
last_funding_date No Last funding round date. For example: ">2015", ">2015-02-01", or "[2010-01-01;2019-01-01]".
last_funding_amount No Last funding round capital, in USD. For example: ">200000".
last_funding_type No Last funding round type. For example: "angel" or "[angel;seed]".
For a list of supported funding types, check Crunchbase’s documentation.
total_funding No Total capital raised, in USD. For example: ">400000".
investor1 No Investor name. For example: "Accel".
investor2 No Another investor name. For example: "Benchmark".

Examples

To get all companies that have more than 30000 employees:

=SEARCH_COMPANIES_ADVANCED_CRUNCHBASE(">30000")

To get all companies that have more than 30000 employees, are located in the United States, are in the Fintech industry, and had a funding round since 2015 that was more than 3000 USD:

=SEARCH_COMPANIES_ADVANCED_CRUNCHBASE(">30000","United States","Fintech",">2015",">30000")

Advanced company search example

SEARCH_COMPANIES_AT_EVENT_CRUNCHBASE

Get a list of companies that attended an event.

Syntax

SEARCH_COMPANIES_AT_EVENT_CRUNCHBASE(event, [employees], [location])

Parameter Mandatory Description
event Yes Event name. For example: "Web Summit 2018".
employees No Number of employees. For example: ">50".
location No One or more countries, regions, states, or cities. For example: "Portugal" or "Porto, Lisboa".

Examples

To get companies that attended Web Summit 2019:

=SEARCH_COMPANIES_AT_EVENT_CRUNCHBASE("Web Summit 2019")

To get companies that attended Web Summit 2019, have more than 100 employees, and are located in the Netherlands:

=SEARCH_COMPANIES_AT_EVENT_CRUNCHBASE("Web Summit 2019",">100","Netherlands")

Companies at event example

SEARCH_COMPANIES_BY_EX_EMPLOYER_CRUNCHBASE

Get a list of companies with founders or execs who worked at a specific company.

Syntax

SEARCH_COMPANIES_BY_EX_EMPLOYER_CRUNCHBASE(location, founded_on, ex_employer1, [ex_employer2])

Parameter Mandatory Description
location Yes One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".
founded_on Yes Company founding date. For example: ">2015", ">2015-02-01" or "[2010-01-01;2019-01-01]".
ex_employer1 Yes Previous employer. For example: "Google".
ex_employer2 No Another previous employer. For example: "Apple".

Examples

To get companies that are located in New York, were founded before 2017, and where one of the founders used to work for google:

=SEARCH_COMPANIES_BY_EX_EMPLOYER_CRUNCHBASE("New York","<2017","google")

Company by ex-employer example

SEARCH_COMPANIES_BY_FOUNDER_EXITS_CRUNCHBASE

Get a list of companies headed by founders who were previously at a company that exited.

Syntax

SEARCH_COMPANIES_BY_FOUNDER_EXITS_CRUNCHBASE(p1, p2, p3)

Parameter Mandatory Description
location Yes One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".
founded_on Yes Company founding date. For example: ">2015", ">2015-02-01" or "[2010-01-01;2019-01-01]".
exit_amount Yes Exit amount of the founder’s previous company. For example: ">30000000".
exit_on Yes Date of a previous exit. For example: ">2016", ">2015-02-01" or "[2010-01-01;2019-01-01]".

Examples

To get companies located in the United States, were founded on or after 2015, and were bought out for over 30000000 before 2018:

=SEARCH_COMPANIES_BY_FOUNDER_EXITS_CRUNCHBASE("United States",">2015",">30000000","<2018")

Companies by founder exits example

SEARCH_COMPANIES_BY_FUNDING_CRUNCHBASE

Get a list of companies based on your funding search query.

Syntax

SEARCH_COMPANIES_BY_FUNDING_CRUNCHBASE(last_funding_date, last_funding_type, last_funding_amount, total_funding, [location], [industry], [employees])

Parameter Mandatory Description
last_funding_date Yes Last funding round date. For example: ">2015", ">2015-02-01" or "[2010-01-01;2019-01-01]".
last_funding_type Yes Last funding round type. For example: "angel" or "[angel;seed]". For a list of supported funding types, check Crunchbase’s documentation.
last_funding_amount Yes Last funding round capital, in USD. For example: ">200000".
total_funding Yes Total capital raised, in USD. For example: ">400000".
location No One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".
industry No One or more industries or industry groups. For example: "Banking", "Banking,Fintech", or "Lending and Investments". For a full list of supported industries, check Crunchbase’s documentation.
employees No Number of employees. For example: ">50".

Examples

To get companies that had a seed funding round since 2015 that amounted to over 2000000 and have accumulated over 4000000 in funding:

=SEARCH_COMPANIES_BY_FUNDING_CRUNCHBASE(">2015","seed",">2000000",">4000000")

To get fintech companies that had a seed funding round since 2015 that amounted to over 2000000, have accumulated over 4000000 in funding, and are located in New York with more than 50 employees:

=SEARCH_COMPANIES_BY_FUNDING_CRUNCHBASE(">2015","seed",">2000000",">4000000","New York","fintech",">50")

Companies by funding example

SEARCH_COMPANIES_BY_INVESTORS_CRUNCHBASE

Get a list of companies with that have certain investors.

Syntax

SEARCH_COMPANIES_BY_INVESTORS_CRUNCHBASE(last_funding_date, last_funding_type, location, investor1, [investor2])

Parameter Mandatory Description
last_funding_date Yes Last funding round date. For example: ">2015", ">2015-02-01" or "[2010-01-01;2019-01-01]".
last_funding_type Yes Last funding round type. For example: "angel" or "[angel;seed]". Check Crunchbases documentation for a list of available funding types.
location Yes One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".
investor1 Yes Investor name. For example: "Accel".
investor2 No Another investor name. For example: "Benchmark".

Examples

To get companies that have had an angel or seed funding round since 2015 located in Germany and had Accel as one of their investors:

=SEARCH_COMPANIES_BY_INVESTORS_CRUNCHBASE(">2015","[angel;seed]","Germany","Accel")

Companies by investors example

SEARCH_COMPANIES_BY_KEYWORDS_CRUNCHBASE

Get a list of companies that match your keywords.

Syntax

SEARCH_COMPANIES_BY_KEYWORDS_CRUNCHBASE(keyword, [total_funding], [location], [industry], [employees])

Parameter Mandatory Description
keyword Yes One or more keywords of the company description. For example: "CMS" or "CMS,AI,CRM".
total_funding No Total capital raised, in USD. For example: ">400000".
location No One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".
industry No One or more industries or industry groups. For example: "Banking", "Banking,Fintech", or "Lending and Investments". For a list of supported industries, check Crunchbase’s documentation.
employees No Number of employees. For example: ">50".

Examples

To get companies that have fintech or banking in their company description:

=SEARCH_COMPANIES_BY_KEYWORDS_CRUNCHBASE("fintech, banking")

To get companies in the Lending and Investments industry group that have fintech or banking in their company description, have raised over 400000, are located in the United States and have over 50 employees:

=SEARCH_COMPANIES_BY_KEYWORDS_CRUNCHBASE("fintech, banking",">400000","United States","Lending and Investments",">50")

Companies by keywords example

SEARCH_COMPANIES_BY_SIZE_CRUNCHBASE

Get companies based on the number of employees.
Syntax

SEARCH_COMPANIES_BY_SIZE_CRUNCHBASE(employees, industry, [location], [founded_on], [total_funding])

Parameter Mandatory Description
employees Number of employees. For example: ">50".
industry One or more industries or industry groups. For example: "Banking", "Banking,Fintech", or "Lending and Investments". For a list of supported industries, check Crunchbase’s documentation.
location One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".
founded_on Company founding date. For example: ">2015", ">2015-02-01" or "[2010-01-01;2019-01-01]".
total_funding Total funding amount raised, in USD. For example: ">100000" or "[0;5000000]".

Examples

To get companies in the Banking and Fintech industries with more than 100 employees:

=SEARCH_COMPANIES_BY_SIZE_CRUNCHBASE(">100","Fintech, Banking")

To get companies in the Banking and Fintech industries with more than 100 employees, located in New York since 2015 and have raised over 500000:

=SEARCH_COMPANIES_BY_SIZE_CRUNCHBASE(">100","Fintech, Banking","New York",">2015",">500000")

Companies by size example

SEARCH_EVENTS_CRUNCHBASE

Get a list of all events that match your criteria.

Syntax

SEARCH_EVENTS_CRUNCHBASE(event, [location], [start_date], [end_date])

Parameter Mandatory Description
event Yes Event name. For example: "Web Summit 2018".
location No One or more countries, regions, states, or cities. For example: "Portugal" or "Porto, Lisboa".
start_date No Event start date. For example: ">2015", ">2015-02-01" or "[2010-01-01;2019-01-01]".
end_date No Event end date. For example: ">2015", ">2015-02-01" or "[2010-01-01;2019-01-01]".

Examples

To get all events that have Web Summit 2019 in their name:

=SEARCH_EVENTS_CRUNCHBASE("Web Summit 2019")

To get all events that have Web Summit in their name since 2015:

=SEARCH_EVENTS_CRUNCHBASE("Web Summit",,">2015")

Events example

SEARCH_FUNDING_ROUNDS_CRUNCHBASE

Get a list of companies based on their funding rounds.

Syntax

SEARCH_FUNDING_ROUNDS_CRUNCHBASE(last_funding_type, [last_funding_date], [last_funding_amount], [location], [industry])

Parameter Mandatory Description
last_funding_type Yes Last funding round type. For example: "angel" or "[angel;seed]". For a list of supported funding types, check Crunchbase’s documentation.
last_funding_date No Last funding round date. For example: ">2015", ">2015-02-01" or "[2010-01-01;2019-01-01]".
last_funding_amount No Last funding round capital, in USD. For example: ">200000".
location No One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".
industry No One or more industries or industry groups. For example: "Banking", "Banking,Fintech", or "Lending and Investments". For a list of supported industries, check Crunchbase’s documentation.

Examples

To get companies whose last funding round was an angel round:

=SEARCH_FUNDING_ROUNDS_CRUNCHBASE("angel")

To get Fintech companies located in California who had an angel funding round since 2015 that amounted to over 400000:

=SEARCH_FUNDING_ROUNDS_CRUNCHBASE("angel",">2015",">400000","California","Fintech")

Funding rounds example

SEARCH_INVESTORS_BY_ACTIVITY_CRUNCHBASE

Get a list of investors that participated in particular funding rounds.
Syntax

SEARCH_INVESTORS_BY_ACTIVITY_CRUNCHBASE(funding_type, [funding_date], [raised_amount], [location], [industry])

Parameter Mandatory Description
funding_type Yes Funding round type. For example: "angel" or "[angel;seed]". For a list of supported funding types, check Crunchbase’s documentation.
funding_date No Funding round date. For example: ">2015", ">2015-02-01" or "[2010-01-01;2019-01-01]".
raised_amount No Amount raised, in USD. For example: ">200000".
location No One or more countries, regions, states, or cities. For example: "Germany" or "Berlin, Munich".
industry No One or more industries or industry groups. For example: "Banking", "Banking,Fintech", or "Lending and Investments". For a list of supported industries, check Crunchbase’s documentation.

Examples

To get investors that have participated in a seed round:

=SEARCH_INVESTORS_BY_ACTIVITY_CRUNCHBASE("seed")

To get investors that have invested in Fintech companies located in California during a seed round since 2018 that amounted to over 200000:

=SEARCH_INVESTORS_BY_ACTIVITY_CRUNCHBASE("seed",">2018",">200000","California","Fintech")

Investory activity example

Summary

With our Crunchbase integration, you can get information for just about any company or investor.

And to make things even easier, check out our ready-to-go templates:

Happy building :rocket: !

1 Like