Get data from Airtable - CodelessBot

What Does This Plugin Do?

Search and send back information from your Airtable base.

Level of Difficulty: Hard

Compatibility: Chatfuel, ManyChat

Plugin Request URL

To setup this plugin, you have 2 options: use the Quick-Start Template or manually setup the plugin. To manually setup the plugin, refer to these general instructions for Chatfuel or ManyChat.

  • Chatfuel:{{cbot_accesskey}}&secretkey={{cbot_secretkey}}
  • ManyChat:
Other Related Plugins

Example Use Cases


Find user information

Search and send back user information from your Airtable

Track discount codes

Find “the right” discount codes to send to your bot visitors

Pricing & Inventory

Provide users with information on product pricing and quantity remaining

How-To Setup the Plugin

Follow the 3 Simple Steps...or Login to CodelessBot to access the Plugin Wizard!

Step 1. Download & Install the Quick-Start Plugin Template

Login to CodelessBot, navigate to Templates on the sidebar and download the Quick-Start Template. Follow the prompt to install the Template. Next, you'll need to create a copy of the template for this specific plugin. See and follow the instructions below.

(If you've already install the Quick Start Template and created a copy of the plugin template - skip this step!

Chatfuel Instructions

a. From your Chatfuel dashboard, open the new bot called "JSON API Tutorial & CodelessBot Template" 

b. Find the group containing the name of this plugin.

c. Click on the arrow next to the plugin name to clone this group and blocks from the template into your own Chatfuel Bot.

d. Navigate back to the Chatfuel Dashboard

e. Open your Bot and find the new plugin group that you just cloned. 

f. Open the new Plugin block and enter in your CodelessBot access key and secret key.

Tip: Rename the plugin block to something more meaningful. For more details, refer to the Getting Started Guide.

ManyChat Instructions

After you download and installed the Quick Start Template...

  1. From the ManyChat sidebar, click on the Flows"
  2. Open the folder "CodelessBot Templates"
  3. Find the flow containing the name of this plugin. 
  4. Create a copy by click on the three dots icon on the right
  5. Then click on duplicate
  6. Feel free to rename this new flow and move it to a different folder
  7. Open up the flow and click on the "Starting Step" to modify the information you'll be sending to CodelessBot

For more details, refer to the Getting Started Guide.

Step 2. Send information to CodelessBot

To quickly do this, use the Plugin Wizard to answer a few questions. It'll then generate the code with the information below for you to copy and paste into your bot.


The Airtable API key.

More Detail

To find your Airtable API key go to

It should look something like keyXXXXXXXXXXX


The Airtable table name.

More Detail

You can find the table name up at the top. For example, in the screenshot below, the name of the table is “Table 1”.


The value that you want to search for.

More Detail

CodelessBot will search for this value in the field name specified in cbot_search_field.


The comma-separated list of attributes/variables to store the values found in Airtable, if a match is found.


The Airtable base ID.

More Detail
  1. To find your Base ID, go to
  2. From the list, click on your base.
  3. Then look at the URL, it should look something like:
  4. You’ll find your Base ID in the URL. It should start with “app” followed by a series of numbers and letters.


The Airtable field to search for a matching value.

More Detail

You can find the field names just above row 1. For example, in the screenshot below, the field names are Name, Notes, Attachments.


A list of Airtable field names containing the information that you need.

More Detail

If you want to get information from more than one Airtable field, be sure to separate each field name with a comma.

Chatfuel Instructions
  1. In this plugin block, scroll down to the "JSON API" card
  2. Copy and paste the code from the Plugin Wizard into the textbox. (Or you can enter the correct value by referring to the descriptions above.)

Tip: Make sure the "Send as" is set to JSON. Not URL encoded or Full JSON Profile.

ManyChat Instructions

a. Click over to the "Body" tab in this external request 

b. Next, copy and paste the code from the Plugin Wizard into the "Request Body". (Or you can enter the correct value by referring to the descriptions above.)

c. If there are any "Replace With placeholder" in the code, you'll need to replace them with the correct matching custom field by clicking on "Add a Variable".

d. To check if you set this up correctly, click on "Test the Request" on the right and you should get a success "200 OK" response

e. Click on the blue "Save" button

Step 3. CodelessBot will reply with the "answer"

CodelessBot will reply back with the following information:


The value success, nomatch, or multiple depending on whether a single match, no match, or multiple matches were found.

Your Request Information

The information from the matching Airtable record, saved as the attributes/variables in cbot_return.

Chatfuel Instructions

After the JSON API card, you can add additional Chatfuel cards to:

  1. Send a message to the user with the result
  2. Add a new card "Go To Block" with a condition to redirect users to a different blocks depending on the result

Note: These are just some ideas. You are not limited by the 2 ideas above.

ManyChat Instructions

Finally, to save and make use of the results, you'll need to save the answer(s) from the CodelessBot to ManyChat custom field(s). To do this:

a. Click over to the "Response mapping" tab.

b. All the answer(s) are already listed for you under the first column "JSONPath". (For more detail about each one, see description above).

For each answer, select the ManyChat custom field you want to use to store the value from CodelessBot. Feel free to delete any that you don't need.

c. Click on "Save" when you're done. After this external request step, you can add a next step where you're:

  • Sending a message to share the results with users
  • Add a new Condition step to redirect users to a different step or flow depending on the result

More Information


1. What is the max number of fields I can get from Airtable?

You can get up to a maximum of 25 fields. Note that there are additional limits applied to the data that can be returned. For example, the length of the data might impact the number of custom fields you can get from Airtable. For more details review all FAQs below.

2. Is there a max length for the value of a field?

CodelessBot does not limit the data for an individual field, instead we have a restriction of 5,000 characters for the combined length of all field names and their values. Please keep in mind that Airtable, Chatfuel, and ManyChat may have their own restrictions. Refer to their documentation for further details and always test the upper limits of the data you realistically expect to retrieve.

3. What type of setup is required in Airtable for integration with CodelessBot?

First you must have an Airtable account, a base and table with appropriate fields. This plugin will work for free Airtable plans. You do not need a paid Airtable account.

4. What happens to my attribute/variables if no match is found?

Nothing will happen. They will retain their original value. Only cbot_rsp will be returned.

5. Is the search case-sensitive?

Yes. The search is case-sensitive. e.g. Box is not equal to box.

6. Can I set a sort by field so that, if there are multiple matches I can attempt to get a specific record?

No, you do not have the ability to control the sorting of matches. The response code “multiple” is meant as a warning that multiple matches were found. It is not recommended that you allow multiple matches to be found unless it doesn’t matter which match you find. Use a unique key/field to find a record whenever possible.

7. Can I list attributes/variables in cbot_return that have a space character?

Yes, you can have spaces in the values of cbot_return for both Chatfuel and ManyChat.  Using the attribute with the space character is a trivial and straight forward process in Chatfuel. Within ManyChat, if you choose to use a value with a space character, you will need to use a slightly modified JSONPath for the response mapping.  You will need to use something like $[“Custom Field With Space”] instead of the typical value of $.CustomFieldWithoutSpace

8. What if there is more than 1 matching value?

You will know from the “cbot_rsp” field whether there are multiple matches but this plugin was designed to only return on 1 value.

Enhance Your Bot with CodelessBot

CodelessBot plans start from $18/month