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

This collection of FullContact spreadsheet functions enables you to collect or analyze data from your FullContact account directly from your spreadsheet. For example, enrich existing data in your spreadsheet with on-demand, refreshable lookups from FullContact.

Learn more about FullContact spreadsheet functions and syntax here.

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 'full_name'). 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
  • 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 People 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 'name'). 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
  • 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

Use FullContact in your spreadsheet now!