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:
- Airtable row is assigned a label, or is changed
- The label causes the row to be added to a filtered view
- This triggers the Airtable automation to run a script
- The script triggers the Integromat scenario to run
- 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.”
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.
Step 4: Add a new automation
Open up the automations pane, and click “+ New Automation.” Then, give it a name.
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.
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.
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"]);
Step 8: Turn on your automation!
That’s all of our work in Airtable! Let’s jump over to Integromat quick.
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.
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!
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.
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.