Airtable is a cloud collaboration service. It’s a spreadsheet-database hybrid: has the capabilities of a database applied to a spreadsheet.
With this integration you can search, read, and update data in your Airtable database much easier than having to create an API.
You can connect your Airtable App in 2 ways:
2. From Chatlayer's homepage menu: mainly before building your bot, when you know you’re going to create requests to one or more Airtable tables
Depending on your Airtable plan, you will have a different maximum number of rows that you can have. Make sure your plan suits your needs before building your database.
Configure your Airtable App directly in an Action bot dialog by clicking the option 'Add action' and then 'Integration':
If there is no Airtable app configured yet (as described in part 2 of this guide), a pop-up will appear:
Or you can also regenerate key:
When clicking the API Key, you’ll be able to see it. So click, select, copy and paste it into the correspondent field of the pop-up:
You’ll see a new field to select integrations from. Choose 'Airtable'
In the Airtable Account field, you’ll see all Apps that you might have already created following the steps in the second part of this guide, or you can create a new one by clicking the 'Connect new account':
Once you pick the integrated App that you already have (or you created a new one), you’ll see the 'Select Action' field. There are three possible actions: Search, Create and Update records from your Airtable
Three new empty fields will appear in this screen. Here’s how you should fill them in:
You’ll get the information for the field “Base” from the Airtable URL. The URL syntax is:
https://airtable.com/appXXXXXXX[use this for “Base”]/tblYYYYYY[use this for “Table”]/…
This is what your Action dialog will look like once it’s filled in:
For the Search Action, fill in the 'Search Field' (use the name of your table's column) and Search Value (a variable that user will input, that should match one of the Search Field's data point) or create your own Search Formula.
Now build your answer syntax:
You'll know it's right when your bot displays the correct data from your table:
You can also create it by clicking '+ Add Account' button, after which you’ll see this pop-up:
Or you can regenerate a key:
Graphical user interface, text, application, email Description automatically generated
When clicking the API Key, you’ll be able to see it. Click, select, copy and paste it into the correspondent field of the pop-up:
This is what it will look like when you’ve successfully connected
When clicking the three dots on the right, you can manage your app integration. There are four actions:
- Reconnect: it will open up a new pop-up allowing you to change the API Key
- Test Connection (soon)
- Change Account Name: will open up a pop-up so you can rename your integrated App
- Remove: Attention! When clicking this button, your App integration will immediately be removed
Change Account Name
Search, Create and Update Record are the possible actions:
To create a record, you must select the Airtable App and the Airtable account (either connecting to an existing one or connection to another), choose the Create Record action, inform Base and Table, as explained in A.8.1(link).
The following step is to fill out the Record fields. In the left-side blank, the name of the column in your Airtable should be informed, and in the right-side blank, the “hard-coded” value or variable (in curly brackets) should be informed.
In the example below, the column to be updated is called ‘Number’ and the variable is called
numberChosen. The variable informed by the user was saved in a previous step through an Input Validation bot dialog.
To Update a record, you must select the Airtable App and the Airtable account (either connecting to an existing one or connection to another), choose the Update Record action, inform Base and Table, as explained in A.8.1(link).
Read about Record ID and Cell Values fields below the picture.
The Record ID is the one highlighted in the URL from the screenshot below – you cannot use the value informed by the customer alone, to refer to the correct ID, you collect the ID informed by the customer in a variable (though an Input Validation bot dialog).
The correct syntax to retrieve the Record ID is
In Cell Values, the name of the column where the value will be updated is informed on the left-side blank, in this case ‘Number’, and the variable which has the new value saved under it in the right-side blank, in this example
The following screenshot shows an example of the flow that are explained in the table further down.
Variable or action taken
User passes the current data point thet they would like to update, which will be saved under variable
Get ticket id
Action taken is the Search Record, with Search Value as the
Get value update
The user informs the updated value that will be saved under variable
Read and update ticket
Record Id is retrieved from Airtable using
Cell values informed are the column name (in this case, Number) and variable saved in the previous step
Now you're all set to create a personalized bot experience for your customers!