Looker Actions - Airtable

[jamie_davidson]

Updated: July 30, 2024

Looker Actions - Airtable

Looker is launching an Airtable Action that will allow sending data directly to an Airtable base from within Looker. This action will let Looker customers push data directly into a table with an established schema for use within Airtable, on a one-off or scheduled basis.

Enable the Airtable Action

1. To enable the action in Looker, go to your Admin panel. Then in the Platform section, click the Actions Tab. (Admin > Platform > Actions).
2. Select “Enable” on the Airtable action.

The Action is now configured for use.

Send Data to Airtable

Grab Airtable API Information

You’ll need to get some information from Airtable before setting up the Send or Schedule of data from Looker.

1. In your Airtable API page select the Base you want to send data to [https://airtable.com/api].

2. Select the base present in the URL and copy it.
   For example, the base would be appXXJyTxBBHH6CbR in this API URL:[https://airtable.com/appXXJyTxBBHH6CbR/api/docs#curl/introduction]

3. Scroll to find the Airtable table you want to send data into. You’ll need to specify that table later.

In this example, you will send data to the Users table.

Create and Send or Schedule a Report

1. In Looker, view a Look or explore data to see the data you want to send to Airtable. In order to test, there must be data available to send and an Airtable schema has to be set up to match the data. The names of the columns in the Airtable table must match the column names in the Looker "data" section of the Explore. The types also must match, so numbers MUST go into number and timestamps can be dates.
2. Then start to send the data now or schedule the data to be sent later or periodically.
3. In the Send or Schedule window’s Destination field, select “Airtable”.
4. In the Airtable Base field, paste the Airtable base that you copied in a prior step.
5. In the Airtable Table field, type the name of the table that should receive this data. In the following example, the data will be sent to the Users table.

6. Click Send.

7. Your data will be sent to Airtable and displayed in the Airtable table! 

8. Click on Authorize and your data will be sent to Airtable and displayed in the Airtable table!