FullContact
+
Google Sheets
+
Microsoft Excel

FullContact in your spreadsheet

Import live, refreshable data from FullContact in Microsoft Excel and Google Sheets.

Import FullContact data in your spreadsheet

FullContact helps you find and verify professional profile information. This FullContact spreadsheet integration for Google Sheets and Microsoft Excel enables you to import contact information from Hunter. This add-on will enable you to integrate on-demand, refreshable identify data without leaving your spreadsheet.

For example, with this Excel and Google Sheets add-on you can:

  • Enrich person contact information based on email address, including name, age, gender, location, organization and social media handles including Twitter, Facebook, and LinkedIn.
  • Enrich company domain information, including name, location, Twitter and LinkedIn URLs, website, number of employees and category.

Click here to learn more about the specific syntax for each of the FullContact spreadsheet functions.

Demonstration

Getting Started

Flex.io makes it easy to create, use and share custom spreadsheet functions that import data from services you know and love. Click on the button below to use the FullContact function collection with Microsoft Excel or Google Sheets. Please note that you'll need a FullContact account with an API key to use this integration.

Need Help?

Have questions? Need help with installation? Need other FullContact functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!

Functions and Syntax

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

FullContact People Enrichment

Return a person's profile information based on their email address.

Syntax

=FLEX("YOUR_TEAM_NAME/fullcontact-enrich-people", email, [properties])

Parameters

Property Type Description Required
email string The email address of the person you wish you find. true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/fullcontact-enrich-people", "tcook@apple.com")
=FLEX("YOUR_TEAM_NAME/fullcontact-enrich-people", "bill.gates@microsoft.com")
=FLEX("YOUR_TEAM_NAME/fullcontact-enrich-people", "jeff@amazon.com", "full_name, title, bio")

Notes

The following properties are allowed:

  • full_name: the full name of the person (default)
  • age_range: age range of the person
  • gender: gender of the person
  • location: location of the person (varies depending on data quality)
  • title: current or most recent job title of the person
  • organization: current or most recent place of work of the person
  • twitter_url: URL of the person's Twitter profile
  • facebook_url: URL of the person's Facebook profile
  • linkedin_url: URL of the person's LinkedIn profile
  • bio: biography of the person
  • avatar_url: URL of the person's photo

FullContact Organization Enrichment

Return information about an organization based on domain name.

Syntax

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

Parameters

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

Sample Usage

=FLEX("YOUR_TEAM_NAME/fullcontact-enrich-org", "apple.com")
=FLEX("YOUR_TEAM_NAME/fullcontact-enrich-org", "stripe.com", "twitter_url, linkedin_url")
=FLEX("YOUR_TEAM_NAME/fullcontact-enrich-org", "fullcontact.com", "website, logo, founded, employees")

Notes

The following properties are allowed:

  • name: the name of the organization (default)
  • location: the location or address of the organization
  • twitter_url: URL of the organization's Twitter profile
  • linkedin_url: URL of the organization's LinkedIn profile
  • bio: biography of the organization
  • logo: URL of the organization's logo
  • website: URL of the organization's website
  • founded: the year the organization was founded
  • employees: the approximate number of employees in the organization
  • locale: the locale of the organization
  • category: the category of the organization -- possible values are Adult, Email Provider, Education, SMS, or Other

FullContact Find Person

Return a person's profile information based on their email address and LinkedIn profile.

Syntax

=FLEX("YOUR_TEAM_NAME/fullcontact-find-person", email, linkedin, [properties])

Parameters

Property Type Description Required
email string The email address of the person you wish you find. true
linkedin string The LinkedIn username of the person you wish to find. true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/fullcontact-find-person", "tcook@apple.com")
=FLEX("YOUR_TEAM_NAME/fullcontact-find-person", "bill.gates@microsoft.com")
=FLEX("YOUR_TEAM_NAME/fullcontact-find-person", "jeff@amazon.com", "full_name, title, bio")

Notes

The following properties are allowed:

  • full_name: the full name of the person (default)
  • age_range: age range of the person
  • gender: gender of the person
  • location: location of the person (varies depending on data quality)
  • title: current or most recent job title of the person
  • organization: current or most recent place of work of the person
  • twitter_url: URL of the person's Twitter profile
  • facebook_url: URL of the person's Facebook profile
  • linkedin_url: URL of the person's LinkedIn profile
  • bio: biography of the person
  • avatar_url: URL of the person's photo

Use FullContact in your spreadsheet now!