HubSpot
+
Google Sheets
+
Microsoft Excel

HubSpot in your spreadsheet

Import live, refreshable data from your HubSpot account in Microsoft Excel and Google Sheets.

Import HubSpot data in your spreadsheet

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

Learn more about HubSpot 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 HubSpot function collection with Microsoft Excel or Google Sheets. Please note that you'll need a HubSpot account to use this integration.

Need Help?

Have questions? Need help with installation? Need other HubSpot 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:

HubSpot Contacts List

Returns a list of contacts from HubSpot.

Syntax

=FLEX("YOUR_TEAM_NAME/hubspot-list-contacts", [properties])

Parameters

Property Type Description Required
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

Notes

The following properties are available:

  • first_name: first name of the person
  • last_name: last name of the person
  • email: email address of the person
  • phone: phone number of the person
  • phone_mobile: mobile phone number of the person
  • job_title: job title of the person
  • address: address of the person
  • city: city in which the person is located
  • state: state in which the person is located
  • zip: zip code in which the person is located
  • country: country in which the person is located
  • linkedin_bio: biography of the person on LinkedIn
  • created_date: date the record for this person was created
  • modified_date: last date the record for this person was modified

HubSpot Deals List

Returns a list of deals from HubSpot

Syntax

=FLEX("YOUR_TEAM_NAME/hubspot-list-deals", [properties])

Parameters

Property Type Description Required
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

Notes

The following properties are available:

  • deal_name: Deal name
  • deal_owner: Deal owner
  • deal_state: Deal stage
  • deal_type: Deal type
  • amt: Amount
  • amt_home: Amount in home currency
  • closed_lost_reason: Closed lost reason
  • closed_won_reason: Closed won reason
  • close_date: Close date
  • description: Deal description
  • pipeline: Pipeline
  • contacts_cnt: Number of contacts
  • sales_activities_cnt: Number of sales activities
  • times_contacted_cnt: Number of times contacted
  • last_contacted_date: Last contacted date
  • next_activity_date: Next activity date
  • created_date: Created date
  • updated_date: Last activity date

HubSpot People Enrichment

Returns profile information of a contact in HubSpot based on email address.

Syntax

=FLEX("YOUR_TEAM_NAME/hubspot-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

Notes

The following properties are available:

  • first_name: first name of the person
  • last_name: last name of the person
  • email: email address of the person
  • job_title: job title of the person
  • city: city in which the person is located
  • state: state in which the person is located
  • company: name of the company the person is associated with
  • website: website of the person
  • twitter_handle: the person's Twitter handle
  • twitter_profile_photo_url: URL of the person's Twitter profile photo
  • conversion_event_cnt: number of conversion events the person has completed
  • lifecycle_stage: lifecycle stage
  • created_date: date the record for this person was created
  • modified_date: last date the record for this person was modified

Use HubSpot in your spreadsheet now!