Airtable

Description

Airtable is a collaborative platform for organizing data in bases and tables and building custom business workflows.

Setup guide

Sign in with an Airtable account that can access the bases you want to connect. You do not need to create an OAuth app or provide a client secret.

1Select Connect with Airtable and choose the permissions your workflow needs:

• Read Only (default): read records and base structure.
• Read and Write Records: also create, update, and delete records. Choose this option for a pipeline that writes to existing tables.
• Manage Records and Structure: also create or change bases, tables, and fields. Choose this option if your pipeline needs to create fields or tables.
• Custom: select individual permissions. Read Base Structure is required. Read Your Email Address is optional and lets Improvado use your email address as the connection name.

Permissions apply only to the resources you grant in Airtable and cannot exceed your Airtable account's own access. Writing records requires edit access; changing fields or table structure requires Creator or Owner access.

2Start authorization and sign in to Airtable when prompted. Review the requested permissions, select the bases you want Improvado to access, and approve the connection. You will return to Improvado.

3Confirm that the connection is Active and that the expected bases appear in its account list. If a base is missing, check that your Airtable account can access it and reconnect to grant it to Improvado.

4Choose your next step:

• To extract the list of accessible bases, select the Bases report. See how to set up data extraction.
• To send data to Airtable, contact your Improvado account team to configure a custom pipeline. Share the source data, target Base and Table, field mapping, record matching key, insert/update rules, and sync schedule. Include the names and types of any fields that should be created.

To add bases or permissions later, reconnect and approve the updated access. If email access is not granted, the connection name uses your Airtable user ID.

Schema information

The Bases report contains the base ID, name, and your permission level for each accessible base. It lists all bases granted to the connection, regardless of account selection. It does not extract the records inside those bases.

Limits

• Airtable availability may require enablement for your workspace. Contact your Improvado account team if Airtable is not available to you.
• Enterprise administrators must allow API access to organization-owned bases. A connection can succeed while the base list is empty if this access is restricted.
• Authorizing write access does not create a pipeline or start sending data. Airtable writes and field creation must be configured separately in a custom pipeline.

Release notes

For supported operations and permissions, see the Airtable Web API documentation and scope reference.