Crunchbase

Crunchbase Functions & Syntax

Overview

Crunchbase is a platform for finding business information about private and public companies, investors and investment rounds. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can interactively query private and public company data from Crunchbase without leaving your spreadsheet.

What you can do

With this integration, you can:

  • Interactively search and filter Crunchbase data
  • Lookup investors for a list of companies
  • Find key people at venture capital firms
  • Find key people at recently acquired companies
  • Enrich email lists with company data

What you need

You need to have an Crunchbase Enterprise API key to use this integration. Also, if you haven't already installed the Flex.io add-on for Excel or Google Sheets, you need to set this up as well.

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Crunchbase Organization Enrichment

Return information about an organization based on domain name.

Syntax

=FLEX("YOUR_TEAM_NAME/crunchbase-enrich-org", domain, [properties])

Sample Usage

=FLEX("YOUR_TEAM_NAME/crunchbase-enrich-org", "spacex.com")
=FLEX("YOUR_TEAM_NAME/crunchbase-enrich-org", "apple.com")
=FLEX("YOUR_TEAM_NAME/crunchbase-enrich-org", "https://www.apple.com")
=FLEX("YOUR_TEAM_NAME/crunchbase-enrich-org", "apple.com", "permalink, name, short_description, founded_on")
=FLEX("YOUR_TEAM_NAME/crunchbase-enrich-org", "apple.com", "short_description, region_name, founded_on, num_employees_min, num_employees_max, contact_email, linkedin_url")
=FLEX("YOUR_TEAM_NAME/crunchbase-enrich-org", "", "*")

Parameters

Property Type Description Required
domain string The domain name of the organization from which you want to retrieve information. For example, "apple.com". If no domain is specified, the function returns the properties names. true
properties array The properties to return (defaults to all properties). See "Returns" for a listing of the available properties. false

Returns

Property Type Description
permalink string The Crunchbase permalink identifier for the organization
name string The name of the organization
stock_exchange string The stock exchange for the organization
stock_symbol string The stock ticker for the organization
primary_role string The primary role of the organization
short_description string A short description of the organization
profile_image_url string A profile image URL for the organization
domain string The domain for the organization
homepage_url string The homepage URL for the organization
facebook_url string The Facebook URL for the organization
twitter_url string The Twitter URL for the organization
linkedin_url string The LinkedIn URL for the organization
city_name string The city name for the organization
region_name string The region name for the organization
country_code string The country code for the organization
rank string The Crunchbase organization rank
contact_email string The contact email for the organization
phone_number string The phone number for the organization
founded_on string The date the organization was founded on
total_funding_usd string The total funding dollars for the organization in USD
number_of_investments string The number of investments made in the organization
num_employees_min string The minimum number of employees in the organization
num_employees_max string The maximum number of employees in the organization
role_company string Whether or not the organization is a company
role_investor string Whether or not the organization is an investor
role_group string Whether or not the organization is a group
role_school string Whether or not the organization is a school
investor_type string The investor type
founded_on_trust_code string The founded_on trust code
is_closed string Whether or not the organization is closed
closed_on string The date the organization closed, if applicable
closed_on_trust_code string The closed-on trust code

Notes

Crunchbase Lead Investor

Returns information about the lead investor for a company for a particular round

Syntax

=FLEX("YOUR_TEAM_NAME/crunchbase-lead-investor", domain, round, [properties])

Sample Usage

=FLEX("YOUR_TEAM_NAME/crunchbase-lead-investor", "spacex.com", "venture")
=FLEX("YOUR_TEAM_NAME/crunchbase-lead-investor", "g2.com", "angel")
=FLEX("YOUR_TEAM_NAME/crunchbase-lead-investor", "g2.com", "A")
=FLEX("YOUR_TEAM_NAME/crunchbase-lead-investor", "g2.com", "B", "name, announced_on, money_raised")
=FLEX("YOUR_TEAM_NAME/crunchbase-lead-investor", "", "", "*")

Parameters

Property Type Description Required
domain string The domain name of the organization for which you want to retrieve information. For example, "google.com". If no domain is specified, the function returns the properties names. true
round string The type of round to find the lead investor for; options include "Seed", "Angel", "Venture", "A", "B", etc. and are case-insensitive. true
properties array The properties to return (defaults to all properties). See "Returns" for a listing of the available properties. false

Returns

Property Type Description
permalink string The Crunchbase permalink identifier for the investor
name string The name of the investor
stock_exchange string The stock exchange for the investor
stock_symbol string The stock ticker for the investor
primary_role string The primary role of the investor
short_description string A short description of the investor
profile_image_url string The profile image URL for the investor
homepage_url string The homepage URL for the investor
funding_type string The funding type
series string The series type
series_qualifier string The series type qualifier
announced_on string The date the investment was announced
money_raised string The total amount raised in the funding round
money_raised_currency_code string The currency of the total amount raised in the funding round

Notes

Crunchbase Organizations

Returns a list of organizations from Crunchbase

Syntax

=FLEX("YOUR_TEAM_NAME/crunchbase-organizations", [properties], [filter])

Sample Usage

=FLEX("YOUR_TEAM_NAME/crunchbase-organizations", "*")

Parameters

Property Type Description Required
properties array The properties to return, given as a string or array; defaults to all properties; see "Returns" for available properties false
filter array Search query to determine the rows to return, given as a string or array false

Returns

Property Type Description
uuid string The UUID for the organization
permalink string The permalink of the organization
name string The name of the organization
legal_name string The legal name of the organization
created_at string The date the organization was created in the system
updated_at string Date the information for the organization was last updated in the system
category_names string A delimited list of the names of the categories for the organization
category_group_names string A delimited list of the names of the category groups for the organization
facet_ids string A delimited list of facet ids for the organization
hub_tags string A delimited list of hub tags for the organization
company_type string The type of the organization
short_description string A short description of the organization
description string A description of the organization
permalink_aliases string A delimited list of alternate permalinks for the organization
aliases string A delimited list of alternate names for the organization
location_group_names string A delimited list of the names of the areas where the organization is headquartered
location_names string A delimited list of the names of the places where the organization is headquartered
phone_number string The general phone number of the organization
contact_email string The general contact email for the organization
image_url string The cloudinary url of the profile image
website_url string Link to the homepage for the organization
linkedin_url string Link to the LinkedIn page for the organization
facebook_url string Link to the Facebook page for the organization
twitter_url string Link to the Twitter page for the organization
founded_on string The date the organization was founded
exited_on string The date the organization was acquired or went public
went_public_on string The date when the organization went public
delisted_on string The date when the organization removed its stock from the stock exchange
status string The status of the organization
operating_status string The operating status of the organization
ipo_status string The current public status of the organization
stock_exchange_symbol string The stock exchange where the organization is listed
stock_symbol string Stock ticker symbol
rank integer Algorithmic rank assigned to the top 100,000 most active profiles on Crunchbase
rank_delta_d7 integer Movement in rank over the last 7 days using a score from -10 to 10
rank_delta_d30 integer Movement in rank over the last 30 days using a score from -10 to 10
rank_delta_d90 integer Movement in rank over the last 90 days using a score from -10 to 10
rank_org integer Algorithmic rank assigned to the top 100,000 most active organizations
rank_org_company integer Algorithmic rank assigned to the top 100,000 most active companies
rank_org_school integer Algorithmic rank assigned to the top 100,000 most active schools
rank_principal integer Algorithmic rank assigned to the top 100,000 most active organizations and people
rank_principal_investor integer Algorithmic rank assigned to the top 100,000 most active investors
revenue_range string Estimated revenue range for organization
num_acquisitions integer The total number of acquisitions
num_alumni integer Total number of alumni
num_articles integer The number of news articles that reference the organization
num_current_advisor_positions integer Total number of current board members and advisors an organization has
num_current_positions integer Total number of current team members an organization has on Crunchbase
num_employees_enum string Total number of employees range
num_enrollments string Total number of enrollments range
num_event_appearances integer Total number of events an organization appeared in
num_exits integer Total number of exits
num_exits_ipo integer Total number of exits (IPO)
num_founder_alumni integer Total number of alumni that are founders
num_founders integer Total number of founders
num_funding_rounds integer Total number of funding rounds
num_funds integer Total number of funds raised
num_investments_funding_rounds integer Total number of investment funding rounds
num_investors integer Total number of investment firms and individual investors
num_lead_investments integer Total number of lead investments made
num_lead_investors integer Total number of lead investment firms and individual investors
num_past_positions integer Total number of past team members of an organization
num_portfolio_organizations integer Total number of portfolio organizations
num_relationships integer Total number of relationships a profile has
num_sub_organizations integer Total number of sub-organizations that belongs to a parent organization
investor_type string A delimited list of the type of investors this organization is
investor_stage string A delimited list of the stage of investments made by this organization
funding_stage string The most recent funding status of the organization
funds_currency string Currency type of the total funding amount raised across all fund raises
funds_total integer Total funding amount raised across all fund raises in the specified currency
funds_total_usd integer Total funding amount raised across all fund raises in USD
funding_currency string Currency type of the total amount raised across all funding rounds
funding_total integer Total amount raised across all funding rounds in the specified currency
funding_total_usd integer Total amount raised across all funding rounds in USD
equity_funding_currency string Currency type of the total funding amount raised across all funding rounds excluding debt
equity_funding_total integer Total funding amount raised across all funding rounds excluding debt in the specified currency
equity_funding_total_usd integer Total funding amount raised across all funding rounds excluding debt in USD
last_funding_total_currency string Currency type of the most recent funding round
last_funding_total integer Total funding amount of the most recent funding round
last_funding_total_total_usd integer Total funding amount of the most recent funding round in USD
last_equity_funding_currency string Currency type of the most recent funding round excluding debt
last_equity_funding_total integer Total funding amount of the most recent funding round excluding debt
last_equity_funding_total_usd integer Total funding amount of the most recent funding round excluding debt in USD
last_funding_at string Date of most recent funding round
last_funding_type string Last funding round type
last_equity_funding_type string The most recent funding round excluding debt
owner_uuid string UUID of the parent organization of the sub-organization
owner_permalink string Permalink of the parent organization of the sub-organization
owner_name string Name of the parent organization of the sub-organization
acquirer_uuid string UUID of the organization that made the acquisition
acquirer_permalink string Permalink of the organization that made the acquisition
acquirer_name string Name of the organization that made the acquisition
founder_uuids string A delimited list of the UUIDs of the founders
founder_permalinks string A delimited list of the permalinks of the founders
founder_names string A delimited list of the names of the founders
investor_uuids string A delimited list of the UUIDs of the top 5 investors with investments in this company, ordered by Crunchbase rank
investor_permalinks string A delimited list of the permalinks of the top 5 investors with investments in this company, ordered by Crunchbase rank
investor_names string A delimited list of the names of the top 5 investors with investments in this company, ordered by Crunchbase rank
program_type integer The type of accelerator program
program_duration integer The duration of the acceleration program in number of weeks
program_application_deadline string The deadline for applying to the accelerator program
school_type string The type of school
school_program string The type of school program
school_method string The type of school method
demo_days boolean Whether an accelerator hosts any demo days

Notes

Crunchbase People

Returns a list of people from Crunchbase

Syntax

=FLEX("YOUR_TEAM_NAME/crunchbase-people", [properties], [filter])

Sample Usage

=FLEX("YOUR_TEAM_NAME/crunchbase-people", "*")

Parameters

Property Type Description Required
properties array The properties to return, given as a string or array; defaults to all properties; see "Returns" for available properties false
filter array Search query to determine the rows to return, given as a string or array false

Returns

Property Type Description
uuid string The UUID for the person
permalink string The permalink of the person
name string The full name of the person
first_name string The first name of the person
middle_name string The middle name of the person
last_name string The last name of the person
gender string The gender of the person
primary_job_title string The primary job title for the person
primary_organization_uuid string The UUID of the organization associated with the primary job for the person
primary_organization_permalink string The permalink of the organization associated with the primary job for the person
primary_organization_name string The name of the organization associated with the primary job for the person
created_at string The date the person was created in the system
updated_at string The date the information for the person was last updated in the system
facet_ids string A delimited list of facet ids for the person
short_description string A short description of the person
description string A description of the person
permalink_aliases string A delimited list of alternate permalinks for the person
aliases string A delimited list of alternate names for the person
location_group_names string A delimited list of the names of the areas where the person is located
location_names string A delimited list of the names of the places where the person is located
image_url string The cloudinary url of the profile image
website_url string Link to the homepage for the person
linkedin_url string Link to the LinkedIn page for the person
facebook_url string Link to the Facebook page for the person
twitter_url string Link to the Twitter page for the person
born_on string The date the person was born
died_on string The date the person died
rank integer Algorithmic rank assigned to the top 100,000 most active profiles on Crunchbase
rank_delta_d7 integer Movement in rank over the last 7 days using a score from -10 to 10
rank_delta_d30 integer Movement in rank over the last 30 days using a score from -10 to 10
rank_delta_d90 integer Movement in rank over the last 90 days using a score from -10 to 10
rank_person integer Algorithmic rank assigned to the top 100,000 most active people
rank_principal integer Algorithmic rank assigned to the top 100,000 most active organizations and people
rank_principal_investor integer Algorithmic rank assigned to the top 100,000 most active investors
num_articles integer The number of news articles that reference the person
num_current_advisor_jobs integer Total number of current advisors and board roles the person has
num_current_positions integer Total number of current Jobs the person has
num_event_appearances integer Total number of events a person appeared in
num_exits integer Total number of exits
num_exits_ipo integer Total number of exits (IPO)
num_founded_organizations integer Number of organizations that the person founded
num_investments integer Number of investments the person has participated in
num_investments_funding_rounds integer Total number of investment funding rounds
num_jobs integer Total number of jobs the person has
num_lead_investments integer Total number of lead investments made
num_partner_investments integer Total number of investments the person has partnered in
num_past_advisor_jobs integer Total number of past board and advisor roles the person has
num_past_jobs integer Total number of past jobs the person has
num_portfolio_organizations integer Total number of portfolio companies associated to the person
num_relationships integer Total number of relationships a profile has
investor_type string A delimited list of the type of investors this person is
investor_stage string A delimited list of the stage of investments made by this person

Notes

Need help?

Have questions? Need help getting started? Need other Crunchbase templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!