Airtable

Overview

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.

Destinations

Setup

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.

App

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 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.

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.

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.

Notes

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 help@grouparoo.com.

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