Connect Airtable to airsource

Last updated: 2026-05-23

How to obtain a Personal Access Token (PAT) and extract Base / Table IDs so airsource SaaS can sync data into your Airtable Base. About 5 minutes, browser-only.

What you need

An Airtable account (Free plan works)
An Airtable Base where data will be written (create it first)
The destination table(s) (e.g. Subscriptions, Customers)

Step 1: Issue a Personal Access Token (PAT)

Sign in to Airtable, click your avatar in the top-right, then Developer hub (or open https://airtable.com/create/tokens directly)
Click Create new token
Name: something recognizable such as airsource SaaS
Under Scopes, check all of the following:
- data.records:read (read existing records)
- data.records:write (write new records)
- schema.bases:read (read table structure)
Under Access:
- Click Add a base and select the Base you want to connect
Click Create token
A string starting with pat... is displayed
Click Copy to save it (the token is never shown again once you close this screen)

Step 2: Get your Base ID

Open the Airtable Base you want to connect in your browser
Check the URL: https://airtable.com/appXXXXXXXXXXXXXX/tblYYYYYYYYYYYYYY/...
The 17-character string starting with app... is your Base ID

Step 3: Get your Table ID

Click the tab for the table you want to connect
Check the URL again: https://airtable.com/appXXX.../tblYYY.../viwZZZ...
The 17-character string starting with tbl... is your Table ID

If you want to sync into multiple tables, note the ID for each one.

Step 4: Review your table structure (recommended, optional)

airsource's AI mapping infers fields from your Airtable schema automatically, but accuracy improves if you use names like the following:

Recommended field name	Field type	Purpose
Customer ID	Single line text	Unique key such as Stripe Customer ID (recommended as Primary field)
Email	Email	Customer email address
Status	Single select	active / past_due / canceled / trialing
Plan	Single select	Plan name
MRR	Currency (USD)	Monthly recurring revenue
Created At	Date (Include time)	Creation timestamp
Last Synced	Date (Include time)	Last sync timestamp (updated automatically by airsource)

Exact match is not required. The AI treats variants like Email, Email Address, e-mail, and mail as the same field.

Step 5: Register with airsource

Open https://airsource.io/onboard and paste:

Field	Example
Airtable PAT	`pat...`
Base ID	`app...`
Table ID	`tbl...`

Troubleshooting

Q. I can't find the PAT creation screen

Open https://airtable.com/create/tokens directly
If you see "You don't have permission", a paid (Team) plan may be required; sign in again from a Free account

Q. I lost my PAT

In Developer hub, Revoke the existing token and create a new one
Remove the old PAT in airsource and register the new one

Q. airsource returns "Base not found"

The Base ID may be wrong
The Base may not have been added under the PAT's Access section

Q. What if the table already has data?

airsource deduplicates by stripe_id (or the source-side unique key)
It automatically decides between updating existing rows and inserting new ones (upsert)
Existing data is never destroyed

Security notes

The PAT is stored in an encrypted JSONB column in Supabase
It is deleted within 24 hours of account closure
You can narrow the token to Read-only in Airtable (sync will not work in that case — Read + Write is required)