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
| When this happens in Airtable | This runs in HubSpot | How fast | Starter |
|---|---|---|---|
| A record is added | Add or update a contact | Within 15 minutes | Two steps on the canvas |
| A record is added | Create a contact | Within 15 minutes | Two steps on the canvas |
| A record is added | Update a contact | Within 15 minutes | Two steps on the canvas |
| A record is added | List contacts | Within 15 minutes | Two steps on the canvas |
| A record is changed | Add or update a contact | Within 15 minutes | Two steps on the canvas |
| A record is changed | Create a contact | Within 15 minutes | Two steps on the canvas |
| A record is changed | Update a contact | Within 15 minutes | Two steps on the canvas |
| A record is changed | List contacts | Within 15 minutes | Two steps on the canvas |
From HubSpot to Airtable
| When this happens in HubSpot | This runs in Airtable | How fast | Starter |
|---|---|---|---|
| A deal moves to a stage | Create a record | Within 5 minutes | Install the starter |
| A deal moves to a stage | Find records | Within 5 minutes | Two steps on the canvas |
| A deal moves to a stage | Update a record | Within 5 minutes | Two steps on the canvas |
| A new contact is added | Create a record | Within 5 minutes | Install the starter |
| A new contact is added | Find records | Within 5 minutes | Two steps on the canvas |
| A new contact is added | Update a record | Within 5 minutes | Two steps on the canvas |
| A support ticket is opened | Create a record | Within 5 minutes | Install the starter |
| A support ticket is opened | Find records | Within 5 minutes | Two steps on the canvas |
| A support ticket is opened | Update a record | Within 5 minutes | Two steps on the canvas |
Set up the starter
Create a record in Airtable when a new contact is added in HubSpot
- 1Install the starter into the client from Templates → Library. It lands switched off.
- 2Connect the client’s HubSpot, for “A new contact is added”
- 3Connect the client’s Airtable, for “Create a record”
- 4Fill in Airtable: Base ID (From the base’s URL: airtable.com/appXXXX/…)
- 5Fill in Airtable: Table (For example Leads)
- 6Match Airtable’s fields to the client’s own: Their email, First name, Last name, Lifecycle stage
- 7Switch it on. Within 5 minutes: HubSpot is checked every 5 minutes.

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
| Airtable value | Filled 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
| Airtable value | Filled 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
| Airtable value | Filled 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.