Set up a connection to Airtable

Tanisha Ray

Updated July 11, 2024 07:20

Airtable is a versatile collaboration platform that combines the flexibility of a spreadsheet with the power of a database, enabling teams to organize, track, and manage projects and workflows in a customizable and intuitive manner.

Set up a connection

After you start the connection, configure it in the Create connection panel and complete all of the required * authentication settings:

Setting	Instructions
Name your connection *	Enter a clear and distinguishable name. Throughout integrator.io imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.
API type *	Choose your Airtable account API type: User info: Get the user record, field, permission, model, and comment details SCIM: Get the user and group details
Auth type *	Select your Airtable account authentication type (either OAuth 2.0 or Token).
OAuth 2.0 client *	Select the OAuth 2.0 client that stores the client ID and client secret provided to you by Airtable. How to retrieve the client ID and client secret To add an OAuth 2.0 client and configure your credentials, click the plus (+) button. Click the edit ( ) button to modify a selected OAuth 2.0 client. For more information, see Create an OAuth 2.0 iClient resource
Token *	Enter your Airtable token. Multiple layers of protection, including AES 256 encryption, are in place to keep your token safe. When editing this connection, you must re-enter this value each time; it is stored only when the connection is saved and never displayed as text. How to retrieve the token
Scopes *	Scopes are OAuth 2.0 permissions that Airtable defines to limit access to your account. How to configure scopes

Tip

This connector documentation describes only the settings shown for the Simple view. For the corresponding HTTP settings, see OAuth 2.0, and token universal connector documentation.

How to retrieve the client ID and client secret

Sign in to your Airtable account.
Navigate to Profile > Developer hub > Developers > OAuth integrations.
Click + Register new OAuth integration.
Enter a Name.
Enter the integrator.io Redirect URL.
Click Register integration.
Navigate to Developer details.
Check the Scopes.
Copy the Client ID.
Copy the Client secret.

How to retrieve the token

Sign in to your Airtable account.
Navigate to Profile > Developer hub > Developers > Personal access tokens.
Click + Create new token.
Enter a Name.
Add the Scopes.
Click Create token.
Copy the Token.

How to configure scopes

Click Scope.
To access all of the scopes in the API, click the » button.

– or –

Check the scopes you want to add and click the > button.
Click Save.