Skip to content

Connect Airtable to HubSpot

Many teams run sales in HubSpot and everything around it in Airtable: onboarding trackers, partner lists, event sign-ups and team rosters. Connecting the two means deals and contacts show up where the rest of the team works, and people collected in Airtable become proper CRM contacts without an export.

Ideas

What you can do with Airtable and HubSpot

Contact syncs, deal copies, onboarding records and lead routing between your Airtable bases and HubSpot. These are ready-made starting points. Anything else you can describe works too.

Build your own

Build any Airtable and HubSpot automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Airtable and HubSpot in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.
  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Only create Airtable projects for HubSpot deals over 10,000 in the Enterprise pipeline, and copy the deal's line items into a linked Airtable table.

Every week, find companies whose Airtable onboarding record has been in the same status for 14 days and create a HubSpot task for the owner.

Use cases

Why people connect Airtable and HubSpot

How the two apps work together

  • ClickRuntime checks HubSpot every few minutes for deals or contacts that changed and writes them to Airtable.
  • Airtable is checked on a schedule for new or updated records that should create or update HubSpot records.
  • Each Airtable record stores the HubSpot ID, so both sides stay matched.
  • Ops records linked to CRM deals

    Delivery teams track projects in Airtable while sales uses HubSpot. When a deal closes, an Airtable project record is created with the client and amount.

  • Partner or event leads into HubSpot

    Event and partner teams collect leads in Airtable. New records become HubSpot contacts with the source property set.

  • Customer data back to the CRM

    Customer success logs onboarding progress in Airtable. Status changes update a HubSpot property so sales can see it.

  • Reporting for finance and ops

    Finance wants deal amounts and close dates next to invoicing data in Airtable. A synced table with deal name, stage and amount covers that.

More apps

Airtable, HubSpot and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Closed deals become Airtable projects

When a HubSpot deal moves to Closed won, create an Airtable project record and post the kickoff details in #delivery on Slack.

Client folders for new projects

When an Airtable project is created from a HubSpot deal, make a Google Drive folder for the client and add the link to both records.

Onboarding emails from Airtable status

When an Airtable onboarding record moves to Kickoff scheduled, email the HubSpot contact a welcome note through Gmail.

Setup

Connect Airtable and HubSpot once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Airtable

Database / No-code

  1. In Airtable, go to airtable.com/create/tokens and create a new token with a name you'll recognise.
  2. Add the scopes the automation needs, such as data.records:read, data.records:write and schema.bases:read.
  3. Add the bases or workspaces the token may use.
  4. Copy the token. Airtable only shows it once.
  5. In the ClickRuntime dashboard, open Connections & secrets and save the token as a secret for Airtable.

HubSpot

CRM / Marketing

  1. In HubSpot, go to Development, then Keys, then Service keys, and create a service key. Or go to Development, then Legacy apps, and create a private legacy app.
  2. Add the scopes your automations need, such as crm.objects.contacts.read, crm.objects.contacts.write and crm.objects.deals.read.
  3. Copy the key, or for a private app open the Auth tab, choose Show token and copy it.
  4. In the ClickRuntime dashboard, open Connections & secrets and save the token as a secret for HubSpot. It is sent as a Bearer token.

FAQ

Questions about connecting Airtable and HubSpot

Which Airtable bases and tables can it use?
Any base your connected Airtable account can open. You choose the base and table for each automation, and fields are matched by name.
Will it create duplicate contacts?
No. Contacts are matched by email address in HubSpot, and the HubSpot ID is written back to the Airtable record so the two stay linked.
Do my Airtable field names need to match HubSpot?
No. You say which Airtable field maps to which HubSpot property, for example Full name to first and last name, when you set it up.
Can my operations team see deals without a HubSpot seat?
Yes. Copying deals or onboarding records into Airtable lets anyone with access to the base see them, without needing a HubSpot login.
Is the sync two-way?
It can be. You say which fields move in each direction.
Can it handle HubSpot associations?
Yes. The script can read the contacts and companies associated with a deal and copy them into linked Airtable records.
What happens to existing records at setup?
You choose whether to do a one-time backfill or only handle changes from setup onward.

Tell your assistant what Airtable and HubSpot should do together

Free plan. No credit card.