Skip to main content

How to build a Chatbot based on your Airtable Data

The ChatGPT Chatbot using Airtable Data automation gives each Airtable record its own chatbot link. The chatbot follows instructions and uses information from a field you choose in that record.

Before you start

You need an OpenAI API key added to your miniExtensions workspace. The chatbot link requires a paid workspace or an active trial.

Setup

  1. In Airtable, prepare a text or formula field containing the instructions and information the chatbot should use. For example, combine a record’s name and description in a formula field.

  2. Create the ChatGPT Chatbot using Airtable Data automation in the workspace and base containing your records.

  3. Under ChatGPT, choose the Table and your OpenAI API key.

  4. Set System Message Field to the field containing your chatbot instructions and context.

  5. Open Formula For ChatGPT and copy the formula. Add it to a new formula field in the same Airtable table, or use it as the URL formula for an Airtable button field.

  6. Open the link for a test record and ask a question about the information in its system message. Check the response before sharing the link.

What information can the chatbot use?

The chatbot does not automatically read the rest of your table or base. Include every detail it needs in the selected system message field. A formula field can combine information from other fields in the same record.

Only include information you intend the chatbot to use and discuss with the people who receive its link.

Beta usage limit

This automation is in beta. It currently allows up to 25 messages across the miniExtensions account that owns the automation before a waiting period. If you reach the limit, wait three hours after the last accepted message before trying again.

Did this answer your question?