Importing Data: Airtable

Who can use this feature?

👤  Available on All plans

Connect data from your Airtable to power your apps.

Prepare your Airtable Base

In order to use your Airtable data with Stacker, you will need to check that you have prepared your base to have linked fields.
 

Stacker uses Airtable's link fields to understand the structure of your data, to allow you to show related data together, and to power the permissions system.

Airtable linked data

Prepare your user table

 

If you already have users in your Airtable base, you can use them in stacker, make sure that both a field for the user's name, and a field for their email have been added into your user table.

Example Airtable table

It isn't necessary to have a user table in your data source to set up your app - you can add users individually via email directly in Stacker.

You can also create links between users and data directly in Stacker.

Connect to your Airtable

You can either create a new app, or add a new data connection to an existing app.

1. Name your data connection

We recommend that you give your data connection the same name as the base you're connecting to. This is because you can connect to multiple Airtable bases in Stacker and this should help you manage your connections.  

2. Enter your Airtable API Key

Find your API key on your Account page in Airtable. Generate a new key, or copy the existing one. Follow the instructions below to find your existing API key, or generate a new one.

Airtable API key example

3. Enter your Airtable Base Sharing Link

Follow the instruction below to generate a sharing link to your base.

  1. Generate a sharing link via the 'SHARE' button located at the top right of your base.
  2. Select Base and then go to the Share publicly tab
  3. Toggle on 'Enable shared base link (read-only)'.
  4. Copy the link

Airtable_Instructions_New.png

⚠️ It is important to avoid regenerating both the sharing link and API Key for your base, this will break the connection between Airtable and Stacker.

4. Is your base password-protected?

If so, click on the lock at the bottom and enter the password. Note: If you change your password, you will need to update it in Stacker

Related articles

How-to guides  
Importing data: Google Sheets Importing data: Intercom

Enabling tables and fields

Importing data: Stripe