Open Navigation

Airtable

Airtable works like a spreadsheet but gives you the power of a database to organize anything.

Overview

Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet.

Authentication

When using the airtable connector, the first thing you will have to do is click on 'New Authentication' in the step editor:

add-auth

An API key is required:

Find your API key at https://airtable.com/account.

Click the icon to the right of your key to copy it to your clipboard.

Paste the key into the API Key field.

airtable-auth

Note on Operation usage - Finding the Base & Table IDs

Airtable does not provide an API to find out what bases or tables are accessible to the user. This means that you will have to manually enter the base ID and table ID.

Finding the base ID

  1. Go to https://airtable.com/api & sign in.

  2. Click on Project Tracker.

  3. The URL should be similar to: https://airtable.com/appPDWK5dasdw2/api/docs#curl/introduction. The base ID is the string after https://airtable.com/, so in this example the base ID is appPDWK5dasdw2.

Finding the table ID

  1. Go to https://airtable.com/ & sign in.

  2. Click on the table you wish to use.

  3. The URL should be similar to: https://airtable.com/tblefuahu4265d/viw0T6SXtRlRJUQLR?blocks=hide. The table ID is the string after https://airtable.com/, so in this example the table ID is tblefuahu4265d.

Example - Adding records to a table, when a new order is paid for

This example will demonstrate the Create record operation.

In this example we want to setup a Shopify trigger to create a new record in airtable when an order is paid for.

airtable-workflow

1 - Setup webhook

Using the Shopify trigger. Set the topic to orders/paid.

airtable-trigger

2 - Create record

Using the Airtable connector, Set the operation to Create record and set the Base & Table ID as described above in the Note on Operation usage section.

Add fields to the record, for example:

  • order_id with the JSON path of $.steps.trigger.data.order_number
  • id with the JSON path of $.steps.trigger.data.id
  • total_price_usd with the JSON path of $.steps.trigger.data.total_price_usd

airtable-record

Was this article helpful?
Yes
No