Chatlayer Documentation
Get in touchAbout Chatlayer
  • Welcome
  • What's new
  • Send feedback
  • start quickly
    • Leadzy tutorial
      • 0. Introduction
      • 1. New bot, new block
      • 2. Understand your users
      • 3. Collect and display user input
      • 4. Steer the conversation with Conditions
      • 5. Empower your bot with Actions
      • 6. Set up a channel and publish your bot
    • Templates
      • Banking
      • E-Commerce Returns
      • E-Bike Shop
      • E-Scooter Support
      • Feedback
      • Find Nearest Location
      • GPT
      • 🆕Gym
      • Job applications
      • Knowledge base AI template
      • Lead generation
      • 🆕NPS
      • Restaurant
      • Retail
  • navigation
    • Analytics
      • Dashboard
      • Customers
      • Conversations
      • User flow
      • Intents
      • 🆕Funnels [Beta]
    • Bot builder
      • Flows
        • Canvas functionalities
        • Collaborate with team members
        • Manage your flows
        • 🆕[Beta] Export and import flows
      • Bot dialogs view
      • Translations
      • Events
    • NLP
      • Dashboard
      • Intents
      • Expressions
      • Entities
      • Train
      • NLP settings
      • Improve
    • Knowledge base AI
      • Add content to your KBAI
      • Build your KBAI flow
      • Use your KBAI source URL in a button
      • Use tags to limit your KBAI content
      • 🆕Use Tables to store your KBAI questions
      • 🆕Manage handover where KBAI is unsatisfactory
    • History
      • Conversations
      • Execution logs
      • Versions
    • Channels
    • Tables
      • Create a table with records
      • Column types
      • Operate on your records
        • Insert record
        • Update record
        • Retrieve record
        • Delete record
      • API
    • Settings
      • Bot settings
      • Offloading
      • Variables
      • Voice
      • Import/Export
  • build your bot
    • Conversation design
      • Plan your bot
      • Conversation design workflow
    • Flow logic
      • Blocks
        • Message
        • Condition
        • Collect input
        • Action
      • Go-to connections
    • 🆕Emulator
    • Tips & best practices
      • Route your flow depending on the time
      • Improve the Not understood block
        • How to create better not understood messages
        • Not understood counter
        • Not understood Google search
      • Go to previous block
      • Recognizing a returning user
      • Skip introduction message
      • Route your flow depending on the channel
      • Reuse flows
      • Connect two bots to each other
  • understand users
    • Natural language processing (NLP)
      • Basic NLP concepts
      • Detect information with entities
        • Match entities
        • Contextual entities
        • System entities
        • Composite entities
      • NLP best practices
        • Word order and diversity of expressions
      • AI intent booster
      • Train your NLP
      • Context
      • NLP import & export
      • Sentiment analysis
    • Languages
      • Supported languages
      • Make your bot multilingual
      • Change language within the conversation
  • set up channels
    • Add a channel to your bot
    • All channels
      • 🚨Facebook Messenger [Deprecated soon]
        • Facebook Admin Removal
        • Facebook Webview Whitelisting
        • Facebook Messenger API updates for Europe
      • 🚨Google Assistant [Deprecated soon]
      • Webhook
      • Web
        • 🚨Web V1 [Deprecated]
          • Customize web widget
          • Live example web widget
        • 🆕Web V2
          • 🆕From Web V1 to V2
          • 🆕Web V2 methods and options
    • Sinch Conversation API
      • Configure your Sinch Conversation API
      • 🆕 Make the most of RCS with Carousels
      • WhatsApp Business API
  • integrate & code
    • API calls
      • Configure your API integration
      • Advanced API features
      • V1 API Reference
      • Custom integrations 101
    • Code editor
      • [Example] Sending data to Airtable (POST)
      • [Example] Retrieving data from Airtable (GET)
      • [Example] Making SOAP requests
    • App integrations
      • Airtable
      • Freshdesk
      • Freshdesk Messaging
      • 🆕Gmail
      • Intercom
      • Mailgun
      • OpenAI: GPT-3, ChatGPT and GPT-4
      • Salesforce
      • 🆕Slack
      • Topdesk
      • Zendesk Support
      • Zendesk Sunshine (beta)
    • 🆕Expression syntax
    • Human handover & live chat
      • Sinch Contact Pro
      • #Interact
      • Genesys Cloud
      • Offloading Webhook
      • Salesforce Service Cloud
      • Sparkcentral by Hootsuite
      • Zendesk Chat
    • Chatlayer messages specifications
  • Publish
    • Publish your bot
      • Publish a flow
  • Analyze & maintain
    • Analytics definitions
    • Data retention
    • Maintenance
    • Session
    • Track events for analytics
  • VOICE
    • 🆕Send bot response as audio
    • Voicebots
      • Create a voicebot
      • Voicebot-specific actions
      • Test your voicebot
      • From chat to voice
  • access & support
    • Identity & Access
      • Single Sign-On (SAML SSO)
    • Billing & subscription
    • Get in touch
    • Chatlayer glossary
    • SaaS Regions & IP Ranges
    • Status
    • Debug your bot
      • No correct response
      • Collect input not working
      • Video isn't working
Powered by GitBook
On this page
  • 1 – Via Action block
  • 2. From Chatlayer's homepage menu
  • How to use each type of Action possible in the Airtable App Integration
  • Create Record
  • Update Record

Was this helpful?

  1. integrate & code
  2. App integrations

Airtable

Airtable is a cloud collaboration service. It’s a spreadsheet-database hybrid: has the capabilities of a database applied to a spreadsheet.

PreviousApp integrationsNextFreshdesk

Last updated 4 months ago

Was this helpful?

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:

1. lock when you are building your bot

2. : mainly before building your bot, when you know you’re going to create requests to one or more Airtable tables

Depending on your , you will have a different maximum number of rows that you can have. Make sure your plan suits your needs before building your database.

1 – Via Action block

Configure your Airtable App directly in an Action block 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 block will look like once it’s filled in:

Now build your answer syntax:

You'll know it's right when your bot displays the correct data from your table:

2. From Chatlayer's homepage menu

You can also create it by clicking '+ Add Account' button, after which you’ll see this pop-up:

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

How to use each type of Action possible in the Airtable App Integration

Search, Create and Update Record are the possible actions:

Create Record

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.

Update Record

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.

Airtable Record ID

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 xv).

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!

You can find your API Key in you Airtable Account page. Find out more .

For the Search Action, fill in the 'Search Field' (use the name of your table's column) and Search Value (a 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 .

You can set up the Airtable integration directly from the left side menu on

You can find your API Key in your Airtable Account page. Find out more

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 block.

d
variable
here
app.chatlayer.ai
here
Input Validation
Airtable plan
Via Action b
From Chatlayer's homepage menu
Graphical user interface, text, application, email Description automatically generated
Reconnect
Change Account Name
Remove