How to Use Integromat Webhooks in Airtable

When you need to send your Airtable data to multiple sources or don’t have access to a direct connection, a webhook can help you connect to various sources. 

A webhook is a custom URL that accepts data from an app. It’s useful when you want quick access to information sent from one app to another. You can use a webhook to connect to Integromat from Airtable automations. 

When you send your information to Integromat via a webhook, you can connect it to any of Integromat’s integrated apps or further connect to any other service using their HTTP module. Airtable is even a #1 Favorited App used by several Integromat Certified Partners.

 

 

Table of Contents

 

Use Airtable Automations to connect to Integromat webhooks

Before starting

Set up your On2Air trigger for Sales of $25,000 and over

Create a webhook URL with the Webhooks app in Integromat

Add the On2Air trigger and webhook script to the automation

Set up the data structure in Integromat

Send your Airtable data to Google Sheets

Send your Airtable data to even more apps in Integromat

Using On2Air and Integromat webhooks for your Airtable data

 

Use Airtable Automations to connect to Integromat webhooks

 

This tutorial will show you how to add a webhook to Airtable automations using the ‘Run Script’ option. We’ll provide you with the code to start sending your Airtable data to Integromat, where you can then send your data to any other app in Integromat. 

 

This setup will use a company sales base. We will use On2Air: Actions to capture sales over $25,000 and send multiple records in bulk to Integromat. We will use this in combination with our Scheduler automation to send it on a set schedule.

 

The scheduler will process the automation every hour. When a sale is added to the Leads table with an amount of $25,000 and higher and a Status of Won, the sales information will be sent to Integromat via the webhook. Then, the data from Airtable will be sent to Google Sheets. 

 

 

Before starting

 

• Be sure you have connected your Airtable account to On2Air.

 

• Copy our Sales base from Airtable into your workspace. It includes a Leads table, a view filtered to Sales $25,000 and over and Status marked as Won, and fields with a Sales Person Name, Company Name, Status, Amount, Date Closed, and another Date field labeled INTERNAL – Comparison.

 

• You’ll also need an Integromat account. You can use Webhooks on the free plan, but it does have a webhook queue size of 10.

 

• A Google account to set up a spreadsheet in Google Sheets
  

 

Optional: Set up the Scheduler automation in the Sales base. The scheduler will process the data on your desired schedule. If you choose not to do this, you can create an automation based on your needs. You’ll need to create a trigger in Airtable automations, then add the Run a script option as the Action. Once you have the Run a script option selected, you can continue with the tutorial.

 

Set up your On2Air trigger for Sales of $25,000 and over

 

On2Air: Actions allows you to capture multiple Airtable records at a time and send them to other apps. This trigger will grab all Leads over $25,000 that have a status of Won. On2Air: Actions provides an advanced option to connect to Airtable and allows you to capture multiple records instead of just a single record.

 

• First, create a Trigger in On2Air: Actions of ‘Multiple Records Updated’
  
  • New Trigger > Multiple Records Updated
• Choose your Airtable connection
  
• In the Configuration, choose the Sales base, the Leads table, and the Over 25K view
  

 

 

• For the Selected Fields, choose Sales Person Name, Company Name, Amount, and Date Closed
  
• For the Trigger mode, choose Date
  
• For the Date field, choose the Date Closed field
  
• For the Comparison Field, choose the INTERNAL – Comparison field
  
• Click Save Trigger Details
  
• Enable the Trigger

 

 

 

 

Create a webhook URL with the Webhooks app in Integromat

 

Now that you’ve created the Trigger in On2Air, you need to get the webhook URL from Integromat. 

• Open Integromat and click + Create a new scenario
• Search Webhooks and choose the Webhooks app
• Choose Custom Webhook as the Trigger
• Click Add to add a new webhook URL
• Name your webhook and click Save
• You will see a Custom Webhook URL displayed
• Change the Maximum number of results to 10
• Click Copy address to clipboard and paste the URL somewhere you can grab it again (or come back to Integromat later)
• Click OK

 

 

 

 

Add the On2Air trigger and webhook script to the automation

 

After you set up the Scheduler automation, you’ll need to add another Action to the end of the automation.

• Copy the code from your On2Air Trigger
  • To do this, open your trigger in On2Air and click Installation 
  • Choose Automation as your Installation Source
  • Select an API Key
  • You can choose to Include Documentation or not
  • Click Copy to Clipboard

 

• Add the Run script action in your Airtable scheduler automation after the Update record action
• Paste the On2Air script into the text box in the Run Script action

 

 

• Next, grab your Webhook URL again
• Add the following script to the text box below the On2Air trigger

 

//^^^^^^^^^^^^^^^^^^ BEGIN Send to Integromat webhook ^^^^^^^^^^^^^^^^^^^^^^^^^//

const webhook = async( hook, data ) => {
    return await fetch(hook, {
        method: 'POST',
        headers: {
        'Content-Type': 'application/json; charset=utf-8'

             },
        body: JSON.stringify(data)
    })
}

for(let record of trigger_results_2FgWHz){
     await webhook( "https://hook.integromat.com/7w1m4ty0j58jpubevnvlnlcj6theq5lw", record )
}

//^^^^^^^^^^^^^^^^^^ END Send to Integromat webhook ^^^^^^^^^^^^^^^^^^^^^^^^^//

 

• Replace trigger_results_2FgWHz with your trigger ID found in On2Air
  Yours will be trigger_results_XXXXXX

 

 

• Replace the URL with your Webhook URL from Integromat

 

 

 

 

• The entire script should look like this with your Trigger ID and Webhook URL

 

 

• Click Run Test
• Your On2Air Trigger should show as Completed with 0 records returned

 

 

• Click Done

 

 

Set up the data structure in Integromat

 

• Open Integromat again
• Click your Webhook app
• Click Re-determine data structure
• The Webhook is now waiting to receive your data

 

 

• Open your Sales base in a separate tab while leaving the Webhook in ‘listening’ mode
• Open the Run Script action text box 
• Click Test
• You should see the number of records you added displayed as “3 records returned” or however many records you created

 

 

 

• After 5 to 10 seconds, you should see your Webhook app in Integromate display the message Successfully determined letting you know it’s received the data from Airtable.

 

• You should be able to see the Airtable data in the Webhook queue by clicking Webhooks in the main menu. Click the blue Truck icon next to your webhook to see the data.

 

 

 

Send your Airtable data to Google Sheets

 

Next, let’s send the data to a spreadsheet in Google Sheets.

First, create a new spreadsheet in Google Sheets with Sales Person, Company Name, Deal Amount, and Date Closed as headers in the first row in separate columns.

 

• Click Add another module in the icon on the right side of the Webhook app
• Search Google Sheets and select the app
• Select Add a Row
• Click Add to set up your Google Connection
• In Mode, choose Select spreadsheet and sheet
• In Spreadsheet, choose the spreadsheet you created
• In Sheet, choose the Sheet that contains your header data
• Leave Table contains headers as Yes

 

 

• Next, map each data point from Airtable into the corresponding spreadsheet field
• Click OK
• Click Run Once to process your scenario
• You should be able to pull in records from your queue
• Now, turn on your Scenario!

 

 

Send your Airtable data to even more apps in Integromat

 

In addition to sending data to a spreadsheet, you can send the data from your Sales base to other apps in Integromat. You can send the information to other bases in Airtable, to a channel in Slack, or send an email. 

 

Using On2Air and Integromat webhooks for your Airtable data

 

Using On2Air to capture multiple records from your Airtable bases and a webhook in Integromat allows you to connect to multiple apps. You can create an automation in Airtable, use the Run script action, create a trigger in On2Air, and paste the provided script into the text box. With webhooks, you can send your vital business data to any app. 

On2Air allows you to connect multiple Airtable bases together to create, update, or delete records.

You can create a trigger in On2Air to update multiple records, which is not possible in Airtable. You can also update a single record, delete a single record, or delete multiple records.

When you incorporate On2Air into your Airtable automations, the possibilities are endless. You can update or search your records and integrate with Integromat.

Final Thoughts

 

Now, you know how to send Airtable data to Integromat with a webhook! Copy our base for your template, create the automation, add the script, and create a Scenario in Integromat.

 

For more options for automations and to connect your automations to other bases or different software, start a free trial of On2Air: Actions. On2Air gives you more control and customization for your Airtable automations. Learn more about automations like adding a checklist of tasks for each new project and how to connect multiple field records together.

Even More Powerful Automations

Automations in Airtable make it easy to complete basic in-app tasks. However, the automations in Airtable have multiple limitations. On2Air: Actions fills the gap to help you connect your Airtable data better.

If you need more automation power and connection to over 2,500 other apps, try On2Air: Actions, an advanced Airtable connector. 

Sign up for a free trial of On2Air: Actions today!

 

Current Limitations in Airtable Automations:

 

- Unable to integrate with other apps you use

✅ On2Air: Actions integrates with Zapier to connect to over 2,500 other apps

- No bulk record automation - only single records at a time

✅ On2Air: Actions allows you to process multiple records at one time in bulk

- Many field types are not available to use in automations, such as attachments, linked records, lookups, multiple-select, rollups with only values, and collaborator fields with more than one collaborator

✅ On2Air: Actions is able to use every field type available in Airtable

- 1-second limitation on script runs

✅ On2Air: Actions has no script run limitations - scripts allow you to do just about anything in Airtable using JavaScript

- The 'Send email' action is branded with Airtable logo and information

✅ On2Air: Actions allows you to integrate with any email provider you choose

- Limitation on the number of automation runs per month - when you hit the limit, your automations will stop working

✅ On2Air: Actions has no limit on the number of runs per month and the number of actions is significantly higher depending on the plan you choose

- Limitation on the number of automations per base

✅ On2Air: Actions allows for a significantly higher number of automations

 

With On2Air: Actions, you can create automations with more field types, add conditional actions based on previous actions, update multiple records at once, and connect to all your other business software.