Skip to content
Amalgam Support

How to Connect Amalgam to Airtable

Connect Airtable to Amalgam to sync whole Airtable tables into your spreadsheets, Claude or ChatGPT. Airtable connects with a personal access token that you create in Airtable, plus the ID of the workspace that holds your base.

What You Need

Section titled “What You Need”
  • An Airtable login that can see the base you want to connect. Any plan works.
  • An Amalgam account.

A token can never do more than the user who created it. If you are a read-only collaborator on the base, the token is read-only too.

Create the Token in Airtable

Section titled “Create the Token in Airtable”
  1. Go to airtable.com/create/tokens. You can also reach it from your account menu under Developer hub, then Personal access tokens.
  2. Click Create token and name it Amalgam.
  3. Click Add a scope and add these three: data.records:read, data.records:write and schema.bases:read.
  4. Under Access, click Add a base and pick the base, or pick the whole workspace so all its current and future bases are covered.
  5. Click Create token and copy it. Airtable shows the token once; if you lose it, regenerate it.

Airtable’s guide: Creating personal access tokens.

Find Your Workspace ID

Section titled “Find Your Workspace ID”
  1. Go to airtable.com/workspaces and click the workspace that holds your base.
  2. The address bar changes to airtable.com/workspaces/wspXXXXXXXXXXXXXX. The part starting with wsp is your Workspace ID.

Airtable’s guide: Finding Airtable IDs.

Connect Airtable

Section titled “Connect Airtable”
  1. Log in at app.amalgam.me.
  2. Click New Integration and choose Airtable. You can type the name in the search box to find it.
  3. Enter a Company name. This is only the display name in Amalgam.
  4. Paste the token into Private Key and the workspace ID into Workspace ID.
  5. Optionally enter the Table name in the Base you want to work with.
  6. Click Connect.

00 new integration button

airtable form

What You Can Pull

Section titled “What You Can Pull”

The Airtable Query report syncs an entire Airtable table into your sheet. See Reports by Provider.

Troubleshooting

Section titled “Troubleshooting”
  • Airtable returns a permissions error: the token does not have the base added under Access. Open the token at airtable.com/create/tokens, add the base or workspace, and try again. The scopes alone are not enough.
  • Tokens do not expire unless your Airtable enterprise admin has set a limit.