Last Updated: 2022-02-16


Airtable is a low-code platform for app-building that features a database-like tool using spreadsheets for easy to share relational database building. Companies use Airtable as a place to store, share, and collaboratively edit their data in a way that can be applied to many tasks such as inventory, event planning, customer management, task-tracking and more.


Destination NameDescription
Airtable Export RecordsExport Records as Airtable Records in a Table


You will need an Airbase account to sync data between Grouparoo and Airtable. You’ll also need to locate the Airtable API key associated with your account. There is only one API key per account and logged-in users can find it by navigating to the account page. This key gives access to all tables in all bases and can be reset if needed.

If your Airtable account has Metadata API support, Grouparoo will be able to read the schema of the tables in your Airtable account. Data types for your columns will be defined and readable by Grouparoo and those columns will be accessible for mapping.

If your Airtable account is not set up with Metadata API support, having accessible fields for Grouparoo will rely on existing data in the Table to infer types for each column. In this case, you will need a table that is already set up with columns and at least one row of data.

When viewing an Airbase table in your browser, there are elements of the URL you will need to be aware of in order to designate the base and the table for a data sync.

Airtable URL with Base and Table Names


To connect Airtable to Grouparoo, you create an App which tells Grouparoo the details of how to connect to Airtable. This specifies the account used for any Destinations.

App Options

In Grouparoo’s UI config, you specify the options to connect to Airtable and test the connection.

Airtable App Options

Option NameDescription
Airtable API Key (required)The Airtable API Key. You can find this by logging into Airtable and navigating to the account page.
Airtable Base (required)This designates the Airtable Base to sync data to. Each airtable base has a name that is generated and used as part of the URL. This is the portion of a base’s URL that begins with ‘app’.
Airtable API HostThe Host for the Airtable API. This field is auto populated with ‘’

Airtable Export Records

This Destination allows you to sync your Grouparoo Records to Records in Airtable.

Companies use Airtable to organize their information in a user-friendly and collaborative environment that gives the simple structure of spreadsheets the additional functionality of a database.

To create a Destination, you make choices about what data to sync.

Sync Modes

A Destination’s sync mode determines what to update in a Destination. The following are supported by Mailjet:

  • Sync: Add, update, and remove Airtable Records. This option looks for new records, changes to existing records, and deletions.
  • Additive: Only add and update Airtable Records, no removal. This option looks for new Records to add to Airtable and changes to existing Airtable Records, but does not keep track of deletions.
  • Enrich: Only update those Records that already exist in Airtable. Do not add or remove Records. This option will only update existing Records in Airtable.

Destination Options

To further clarify how Grouparoo should sync data to Airtable, there are some options you should choose that designate details about Airtable’s organization.

Airtable Export Records Options

Option NameDescription
Table Name (required)Designates the table in Airtable that has rows representing a Grouparoo Record. This is the Airtable Table to sync data to. Each Airtable Table has a name that is automatically generated and used as part of the URL. This is the portion of a base’s URL that begins with ‘tbl’.
Primary Key (required)Designates the field in the Table that uniquely represents a Grouparoo Record.

Record Data

Mapping Grouparoo Properties to Airtable Record Properties is the key to syncing data to Airtable.

In Airtable, Record Properties can be used to filter and segment data as needed.

Airtable Export Records Properties

Required Properties

There will be one property listed that is required to find or create the correct Records in Airtable. Whatever field you designated in the Destination Options configuration as the primary key for the table you are syncing to will be the required Property to map.

Optional Properties

Any other fields that Grouparoo can detect in the table you are syncing to will be listed as known airtable properties. In order for a property to be known by Grouparoo, it must have a Record in Airtable with a value in that field during this configuration step.

These other properties represent columns in the table Grouparoo will sync data to.

Group Data

Some Destination types support further grouping data to create remote lists or tags. This Destination does not offer that functionality.


We strive to keep our documentation accurate, easy to use, and up to date. If you notice that something has changed or is not addressed in the process of setting up your Grouparoo connection with Airtable, please let us know by reaching out to

As always, if you need support using Grouparoo, reach out to community members in our Slack channel. We are always happy to help!

Join us on Slack