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

HubSpot is a popular web-based customer relationship management (CRM) tool for managing all your company's relationships and interactions with customers and leads. This HubSpot CRM spreadsheet integration for Google Sheets and Microsoft Excel enables you to import data from your HubSpot account, like leads, contacts, companies and activities. This add-on will enable you to integrate on-demand, refreshable customer management data without leaving your spreadsheet.

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

  • Import a list of your HubSpot contacts data, including first and last name, email, phone title, address and LinkedIn bio.
  • Extract HubSpot CRM deal data including deal name, owner, type and status information.
  • Enrich leads and contact profile using email with information from your HubSpot account, including first and last name, title, address, twitter handle and lifecycle stage.

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

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 CRM 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

=FLEX("YOUR_TEAM_NAME/hubspot-list-contacts")
=FLEX("YOUR_TEAM_NAME/hubspot-list-contacts", "*")
=FLEX("YOUR_TEAM_NAME/hubspot-list-contacts", "first_name, last_name, phone, email")

Notes

The following properties are available:

  • first_name: first name of the contact
  • last_name: last name of the contact
  • email: email address of the contact
  • phone: phone number of the contact
  • phone_mobile: mobile phone number of the contact
  • job_title: job title of the contact
  • address: address of the contact
  • city: city in which the contact is located
  • state: state in which the contact is located
  • zip: zip code in which the contact is located
  • country: country in which the contact is located
  • linkedin_bio: biography of the contact on LinkedIn
  • created_date: date the record for this contact was created
  • modified_date: last date the record for this contact 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 twitter_handle). 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 (default)
  • 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!