Comment on page
Airtable is a cloud collaboration service. It’s a spreadsheet-database hybrid: has the capabilities of a database applied to a spreadsheet.
This integration is currently unavailable. We are working towards resolving the issue. Please subscribe to the newsletter for updates on our fix.
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:
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.
Now you're all set to create a personalized bot experience for your customers!