Airtable
Airtable is a cloud collaboration service. It’s a spreadsheet-database hybrid: has the capabilities of a database applied to a spreadsheet.
Last updated
Airtable is a cloud collaboration service. It’s a spreadsheet-database hybrid: has the capabilities of a database applied to a spreadsheet.
Last updated
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:
1. Via Action bot dialog: when you are building your bot
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:
You can find your API Key in you Airtable Account page. Find out more d.
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.
More information on what to fill if you want to use the 'Search Formula' option here.
Now build your answer syntax:
You'll know it's right when your bot displays the correct data from your table:
You can set up the Airtable integration directly from the left side menu on app.chatlayer.ai
You can also create it by clicking '+ Add Account' button, after which you’ll see this pop-up:
You can find your API Key in your Airtable Account page. Find out more here
Or you can regenerate a key:
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
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 {apps.airtable.read_record._id}
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 {numberUpdate}
The following screenshot shows an example of the flow that are explained in the table further down.
Bot Dialog
Variable or action taken
Create update
User passes the current data point thet they would like to update, which will be saved under variable {ticketToUpdate}
Get ticket id
Action taken is the Search Record, with Search Value as the {ticketToUpdate} variable
Get value update
The user informs the updated value that will be saved under variable {numberUpdate}
Read and update ticket
Record Id is retrieved from Airtable using {apps.airtable.read_record._id}
Cell values informed are the column name (in this case, Number) and variable saved in the previous step {numberUpdate} is passed as the new value for that ticket.
Now you're all set to create a personalized bot experience for your customers!
