You can create a new record in Airtable every time your chatbot collects specific user data using our Integromat - Make integration. More than that, you can even proceed to calculations.

Let's say that you installed a lead qualification chatbot on your website.

You need to send your lead data to Airtable every time someone ends a conversation with your chatbot. Or, at least, follow a specific conversational path.

Here are the steps to follow:

Create your Joonbot

Create your qualification path by asking questions and saving the answer under specific variable names.

Add a webhook block at the end of your qualification path. You'll edit the webhook block later.

Create your Airtable

Add all the qualification elements that you want to save in columns. 

So every time you have a new lead, it will create a new record with all the info you need.

Create your Integromat / Make scenario

1. Create a new scenario and add the trigger custom webhook.

2. Create a webhook by clicking on the "Add" button and name it the way you want.

3. Copy the Webhook URL

4. Go into your Joonbot and click on your webhook block and the "edit my webhooks" button.

5. Click on the "Create webhook" button, name your webhook, choose POST as webhook method, paste the Webhook URL in the field below and save.

6. Now, click on the Joonbot logo on the upper left and go back to your chatbot.

Click on your Webhook block and choose the webhook you just created.

Choose "No" for the Asynchronous option.

7. Now, go back to Integromat / Make and add the new action to your scenario: the Airtable Create a Record.

8. Connect your Airtable account, and pick your database and table. 

Now you need to map your columns with your Joonbot variables.

9. Add a new action into your Integromat / Make scenario: the Webhook response.

⚠️ Joonbot webhook block expects a JSON, so you need to send back a JSON format.

You don't need to give any specific data to your Joonbot, so here is what you can add:

{"hook_response": "ok"}

10. Time to test now!

Within Integromat / Make, you can click on run once and test.

If everything is ok, activate your integration. Ensure you have the right option selected: "Immediately as data arrives".

If something doesn't work

If you make some changes in your Joonbot, don't forget to redetermine your data structure in your custom webhook block.

Re-run to see if everything is ok now.

Also, maybe there is something wrong with your Webhook block in Joonbot. First, check that your webhook block has a webhook selected and that the URL is correct.

Bonus

You can add a date column!

You don't need to use the Joonbot variable {{today}}.

Here is how to proceed:

1. Add a column date in your Airtable and pick the format you want. You can include time if you want.

2. Go to your Integromat / Make scenario, into your Airtable block, refresh and map your date column with the "now" variable.

3. Done!

If something doesn't work

If you make some changes in your Joonbot, don't forget to redetermine your data structure in your custom webhook block.

Re-run to see if everything is ok now.

Also, maybe there is something wrong with your Webhook block in Joonbot. First, check that your webhook block has a webhook selected and that the URL is correct.

If your chatbot is ok and you tested your Integromat integration, and it's a success, then open a tab and paste the webhook URL. Maybe there is an issue with the JSON payload.