BuildShip Logo
BuildShipΒ Community

Chat with Airtable

Create an AI Assistant that can chat with your data on Airtable. Gets the entire Airtable sheet, so best for smaller datasets.

259

Report this template

Select the reason for reporting

Describe the issue in detail

Share template

Link to template

https://templates.buildship.com/template/E6MyIaF4EuOu/

Inputs

threadId

user101

message

List me all the sofas you have
This is a static example using sample inputs. Remix the template to run it with your own values.

Output

Read me

πŸ€– Chat with Airtable

This template lets you create an AI Assistant that can chat with your data on Airtable. The assistant can pull the data from an Airtable to answer any of the questions.

In this example, the assistant acts as a home specialist, answering user inquiries about product materials, styles or pricing based on the product database on Airtable.

βœ… Prerequisites

Airtable Setup

  • [ ] Airtable API Key (Personal Access Token)
  • [ ] This template uses a sample database. Go to the sample Airtable base and click on "Copy base". This would clone the Airtable to your own base. Copy the Table ID and Base ID and add them to the Airtable node.

OpenAI Setup

This template uses the OpenAI Assistant. Here's what you'll need to successfully test out the template:

  • [ ] Your OpenAI API Key

You can get your OpenAI API Key from the OpenAI Developer Dashboard.

  • [ ] OpenAI Assistant ID

Create an OpenAI Assistant on the OpenAI Developer Dashboard > Assistants, and copy the Assistant ID.

πŸ’‘QUICK NOTE: When getting the Assistant ID it's best to select 'text' as the Response Format.

πŸ§ͺ Testing

Test out the workflow via a message likeΒ List me all of the sofas you have.

✍️ How to Use

Once both the API Keys, Assistant ID, and the Base and Table ID for the Airtable is added, the workflow is ready to be used.

The template comes with a Chatbot Widget trigger which makes it super easy to test the functionality with a chat-like interface.

🌟BONUS: Here's how you can easily embed an AI chat widget on your website or app. Use the configuration script provided in the usage section to use your own AI Assistant Chatbot.

NOTE: You MUST Ship your workflow before testing out the functionality on the chat widget.

🎨 Customization

The default template uses the OpenAI Assistant node. To customize, click on the Additional settings to reveal additional customizable options, like the Thread ID and the Built-in Tools provided by OpenAI, like File Search and Code Interpreter.

Also, if OpenAI isn't what you're looking for πŸ‘€, the Node Explorer contains a variety of AI Assistant nodes with various models and providers, like Claude, Groq, and Azure πŸ‘‡

Simply replace the existing OpenAI node with any of the Assistant option of your choice. Add in the API Key, Instruction, Prompt, and you'll be good to go.

πŸ”— Resources

  • Check out the dedicated documentation for the Assistant Variants: here
  • How to set up an OpenAI Assistant: here
  • Integrating Airtable with BuildShip: here