Skip to content
Airtable

Connect Airtable and HubSpot

Start a client’s workflow in Airtable and act in HubSpot, or the other way round, on the client’s own accounts.

Each app by itself: Airtable integration and HubSpot integration, with how to connect it, its scopes and its limits.

What the pair is used for

  • HubSpot contacts, whether from a form, an import or typed in by hand, can be copied into an Airtable table with first name, last name, email and lifecycle stage.
  • When a deal reaches the stage you name, a row records the deal name, amount, pipeline and stage, which gives a jobs or delivery table its next piece of work.
  • Support tickets opened in HubSpot can be listed in Airtable by subject, priority, pipeline and pipeline stage.
  • Built the other way, a row added to the base, or one entering a view, can feed HubSpot’s “Add or update a contact”, which keeps a person who appears twice as one contact.

Every way Airtable and HubSpot join

A workflow starts from a trigger in one app and runs a step in the other, on the client’s accounts. Where the library has a starter for it, it installs that pairing into a client switched off; any other pairing is two steps on the canvas.

From Airtable to HubSpot

Triggers in Airtable with steps in HubSpot
When this happens in AirtableThis runs in HubSpotHow fastStarter
A record is addedAdd or update a contactWithin 15 minutesTwo steps on the canvas
A record is addedCreate a contactWithin 15 minutesTwo steps on the canvas
A record is addedUpdate a contactWithin 15 minutesTwo steps on the canvas
A record is addedList contactsWithin 15 minutesTwo steps on the canvas
A record is changedAdd or update a contactWithin 15 minutesTwo steps on the canvas
A record is changedCreate a contactWithin 15 minutesTwo steps on the canvas
A record is changedUpdate a contactWithin 15 minutesTwo steps on the canvas
A record is changedList contactsWithin 15 minutesTwo steps on the canvas

From HubSpot to Airtable

Triggers in HubSpot with steps in Airtable
When this happens in HubSpotThis runs in AirtableHow fastStarter
A deal moves to a stageCreate a recordWithin 5 minutesInstall the starter
A deal moves to a stageFind recordsWithin 5 minutesTwo steps on the canvas
A deal moves to a stageUpdate a recordWithin 5 minutesTwo steps on the canvas
A new contact is addedCreate a recordWithin 5 minutesInstall the starter
A new contact is addedFind recordsWithin 5 minutesTwo steps on the canvas
A new contact is addedUpdate a recordWithin 5 minutesTwo steps on the canvas
A support ticket is openedCreate a recordWithin 5 minutesInstall the starter
A support ticket is openedFind recordsWithin 5 minutesTwo steps on the canvas
A support ticket is openedUpdate a recordWithin 5 minutesTwo steps on the canvas

Set up the starter

Create a record in Airtable when a new contact is added in HubSpot

  1. 1Install the starter into the client from Templates → Library. It lands switched off.
  2. 2Connect the client’s HubSpot, for “A new contact is added”
  3. 3Connect the client’s Airtable, for “Create a record”
  4. 4Fill in Airtable: Base ID (From the base’s URL: airtable.com/appXXXX/…)
  5. 5Fill in Airtable: Table (For example Leads)
  6. 6Match Airtable’s fields to the client’s own: Their email, First name, Last name, Lifecycle stage
  7. 7Switch it on. Within 5 minutes: HubSpot is checked every 5 minutes.
The installed workflow on the canvas: HubSpot’s “A new contact is added” trigger leading to Airtable’s “Create a record” step.

What it produces

The Airtable step as it runs for an example client, Lakeview Consulting, when Emma Collins asks for a consultation: each value the starter fills in.

Base ID
appXXXXXXXXXXXXXX
Fields
{"First name":"{{ trigger.payload.properties.firstname }}","Last name":"{{ trigger.payload.properties.lastname }}","Lifecycle stage":"{{ trigger.payload.properties.lifecyclestage }}","Their email":"{{ trigger.payload.properties.email }}"}
Table
Leads

Setup notes for this pair

  • Airtable takes values only into columns whose names match. Create “First name”, “Last name”, “Lifecycle stage” and “Their email” for contacts, “Deal”, “Amount”, “Pipeline” and “Stage” for deals, or “Subject”, “Priority”, “Pipeline” and “Status pipeline stage” for tickets, or rename them in the step.
  • Stage and pipeline arrive as HubSpot’s internal values, which can differ from the labels people see in HubSpot.
  • For a build from Airtable’s changed-record trigger, the table needs a “Last modified time” field. HubSpot’s “Create a contact” fails on an email it already has.

Field mapping, starter by starter

Each value a starter’s step is given, and where it comes from. Words in brackets are filled in when it runs; change any of it after installing.

Create a record for new contacts

Create a record in Airtable when a new contact is added in HubSpot

The values Create a record in Airtable when a new contact is added in HubSpot sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"First name":"[the contact’s first name, from HubSpot]","Last name":"[the contact’s name, from HubSpot]","Lifecycle stage":"[the contact’s lifecyclestage, from HubSpot]","Their email":"[the contact’s email, from HubSpot]"}
Table[Airtable: Table]

Create a record for deal stage moves

Create a record in Airtable when a deal moves to a stage in HubSpot

The values Create a record in Airtable when a deal moves to a stage in HubSpot sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Amount":"[the deal’s amount, from HubSpot]","Deal":"[the deal’s name, from HubSpot]","Pipeline":"[the deal’s pipeline, from HubSpot]","Stage":"[the deal’s dealstage, from HubSpot]"}
Table[Airtable: Table]

Create a record for new support tickets

Create a record in Airtable when a support ticket is opened in HubSpot

The values Create a record in Airtable when a support ticket is opened in HubSpot sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Pipeline":"[the ticket’s hs pipeline, from HubSpot]","Priority":"[the ticket’s hs ticket priority, from HubSpot]","Status pipeline stage":"[the ticket’s hs pipeline stage, from HubSpot]","Subject":"[the ticket’s subject, from HubSpot]"}
Table[Airtable: Table]

Airtable and HubSpot and their logos are trademarks of their owners, used here only to say what Thrum works with; no endorsement is implied.

Thrum is cooking.

Get early access and you’ll be among the first in. Early members get a launch perk.