Process Airtable Rows Instantly—Using Airtable Automations and Integromat

Image for post
Image for post

Airtable Automations, previously available only on Enterprise plans, has now started arriving on Pro plans—and it’s very exciting. Automations brings with it the power to send notifications, through email or messenger apps, or run custom scripts based off of a couple of triggers. This opens tons of new doors for seamless integrations with Zapier or Integromat, to extend its power even further beyond (it may even replace some Zaps for you, completely).

In this article we’re going to combine the power of Automations with Integromat, to create instant feedback triggers. Previously, you had to schedule Integromat to search Airtable records every 5–15 minutes (or up to 1 minute if you upgrade). This is probably fine for most cases, but if you’re using Airtable to sync content to your website, on a platform like Webflow for example, this limit can be less than ideal.

We’ll use the Run a Script action to send rows to Integromat via its Webhooks module—automatically, instantly, and in the background. Depending on your project, this is a big quality of life improvement over the scheduling limits of Integromat triggers, and might be able to save you some data usage by only running when it’s called.

Here’s the automation process:

  1. Airtable row is assigned a label, or is changed
  2. The label causes the row to be added to a filtered view
  3. This triggers the Airtable automation to run a script
  4. The script triggers the Integromat scenario to run
  5. When Integromat finishes, it updates the Airtable row which removes it from the filtered view

Before you start: make sure you have your integromat webhook address handy

Setting up Airtable

Step 1: Create a trigger field

The first step is to make sure you have a field that you want to act as a trigger to run the Airtable Automation. In this example, I’m just using a basic Single-select field titled “Web Status.” When I want the automation to run, I change the status to “Send to Webflow” (as I’m using Airtable to manage posts to my website on Webflow).

Step 2: Create a view

Next, we need to make a new Airtable view to house all of the rows that we are sending. I usually name this something like “Pending Changes” or “Queue.”

Image for post
Image for post

Step 3: Filter the view for your trigger field

In this new view, we’ll create a filter for that Single-select field we added. Now, only rows that we have labeled “Send to Webflow” will show up and be processed.

Image for post
Image for post

Step 4: Add a new automation

Open up the automations pane, and click “+ New Automation.” Then, give it a name.

Image for post
Image for post

Step 5: Add a new trigger

Click “Add a Trigger.” We’ll want to run this automation when our row enters our filtered view, so choose that option. Select the table of data you want to use, and then select the view we set up in step 2.

Image for post
Image for post

Step 6: Setup the action

Click “Add action” and select run a script. This is what we’ll use to ping Integromat to run a scenario. Click the action again to open up the script editor.

Image for post
Image for post

Step 7: Setup the script

Click Add input variable at the top of the window. This step will capture the record ID of the row, so that Integromat knows which row to process.

Under Input variable name, type “recordID”

Under Input variable value, click the blue “+” and select Record ID

Finally, paste the script below into the editor. Make sure to replace the url with your unique webhook, and append ?recordID= to the address as shown below:

let url = "https://hook.integromat.com/XXXXX?recordID=";let inputConfig = input.config();await fetch(url + inputConfig["recordID"]);
Image for post
Image for post

Step 8: Turn on your automation!

Image for post
Image for post

That’s all of our work in Airtable! Let’s jump over to Integromat quick.

Configuring Integromat

Now that we have Airtable setup to send us data on the fly, we need to do a little tidying.

Step 1: Test the webhook

Run the Integromat webhook module to listen for new data, and then change the Website Status field in one of your Airtable rows to see if the setup was successful.

Image for post
Image for post

Step 2: Go wild!

Use the Airtable > Retrieve a record module, and use the recordID data to bring up the rest of the information from your row. From here you’ll have all the power you need to make amazing things! Use Airtable as your Webflow CMS, or use the trigger to make fast updates to other Airtable fields, and much more!

Image for post
Image for post

Step 3: Update your row

After you’re finished transforming and using your data, I like to finish it off by updating my trigger row’s Web Status field from “Send to Webflow” to “Published.” This will remove it from our “Pending Changes” view and provide quick confirmation that the automation was successful.

Image for post
Image for post

Thanks for reading!

If you found this tutorial helpful, you can follow me on twitter for similarly inspired content. If you have any issues or questions, you can also feel free to send me a DM and I’ll gladly help any way I can.

Written by

Designing web and other digital lands

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store