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
Note: Your Looker instance must be on Looker 5.6 or higher.
To enable the action in Looker, go to your Admin panel. Then in the Platform section, click the Actions Tab. (Admin > Platform > Actions).
Select "Enable" on the Action that you would like to enable.
In Airtable, navigate to your Airtable account page. [https://airtable.com/account].
On the Airtable account page, generate and copy an API key.
On the Looker Actions page, paste your Airtable API key into the Airtable API Key field.
Great, now you’ve set up your API keys so that Looker can communicate with Airtable!
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.
In your Airtable API page select the Base you want to send data to [https://airtable.com/api].
Select the base present in the URL and copy it.
For example, the base would be appXXJyTxBBHH6CbR in this API URL:
- 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
In Looker, view a Look or explore data to see the data you want to send to Airtable.
Then start to send the data now or schedule the data to be sent later or periodically.
In the Send or Schedule window’s Destination field, select "Airtable".
In the Airtable Base field, paste the Airtable base that you copied in a prior step.
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.
Your data will be sent to Airtable and displayed in the Airtable table!