Send personalized in-app messages using AirTable & Integromat

There are plenty of awesome no-code tools out there, tools like AirTable and Integromat enable you to build fully-fledged products without writing a single line of code.

In this guide, we're going to query our user table located on AirTable and send a personalized in-app message to each user.

Demo table with unique user identifiers and first names

Our Integromat Scenario

  1. Airtable - Query our customer information.
  2. Iterator - Go through each record and fetch customer details.
  3. HTTP - Send the in-app message via Gist.
Pull data from Airtable, Iterate over every record, and send the in-app messages

We begin by connecting our AirTable demo view to Integromat. Add the connection, select our base, and choose the table.

Note: You can also add queries to filter by recently added.

Pulling all data from Users table

The iterator module allows us to get records from our AirTable query and extract the fields we need. In our case, we need the User Token and Name fields.

Iterating over records and fetching user tokens & first names only

The last step will use the data from the iterator to build a message and send it to every user in the list.

Setting up the Gist webhook

Add an HTTP module after the iterator and configure with the following:

Headers

  • X-Bourbon-Organization-Id value can be copied from integrations.
  • X-Gist-Service-Key a new service key needs to be created from service keys.

Content

  • Body type: Raw
  • Content type: JSON (application/json)

Request Content

{
    "userToken": "{{3.`User Token`}}",
    "messageId": "welcome",
    "priority": 1,
    "expiry": "{{addMinutes(now; 15)}}",
    "properties": {
        "name": "{{3.Name}}"
    }
}

Let's break the request down:

  • User Token - The unique identifier for our user
  • Message Id - The Gist message we want to show
  • Priority - 1 means top priority, messages are shown in order of priority
  • Expiry - We want the message to expire 15 minutes from now
  • Properties - Can include any custom property. In this case, we want to include the user's first name in the message.

Full webhook documentation is available here.

Adding personalization through properties

Running the scenario will send a personalized message to every user in the table. Gist is available on Web, iOS & Android so the customer can be reached on the platform of their choice.

Interested in hooking up Integromat with Gist? head over to gist.build and create your free account.