Send personalized in-app messages using AirTable & Integromat
![Send personalized in-app messages using AirTable & Integromat](/content/images/size/w1200/2021/11/Screenshot-2021-11-27-at-17.06.15.png)
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.
![](https://blog.gist.build/content/images/2021/11/Screenshot-2021-11-26-at-16.52.52.png)
Our Integromat Scenario
- Airtable - Query our customer information.
- Iterator - Go through each record and fetch customer details.
- HTTP - Send the in-app message via Gist.
![Airtable as a database, it](https://blog.gist.build/content/images/2021/11/Screenshot-2021-11-26-at-16.53.03.png)
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.
![](https://blog.gist.build/content/images/2021/11/Screenshot-2021-11-26-at-16.53.20.png)
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.
![](https://blog.gist.build/content/images/2021/11/Screenshot-2021-11-26-at-16.53.25.png)
The last step will use the data from the iterator to build a message and send it to every user in the list.
![](https://blog.gist.build/content/images/2021/11/Screenshot-2021-11-26-at-16.54.23.png)
Add an HTTP module after the iterator and configure with the following:
- URL:
https://queue.api.gist.build/api/v1/messages
- Method:
POST
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.
![](https://blog.gist.build/content/images/2021/11/Screenshot-2021-11-26-at-16.54.27.png)
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.
![](https://blog.gist.build/content/images/2021/11/iphone--1--4.png)
Interested in hooking up Integromat with Gist? head over to gist.build and create your free account.