Skip to main content

How to analyze and modify Airtable Data using AI

Updated over a week ago

Our OpenAI Responses automation uses OpenAI's GPT models. It can perform a huge variety of tasks, including translation into most common languages and analysis of attachments. You would simply provide it with the appropriate prompt and it would perform the action (e.g. "Translate this text to French", "Summarize this text", "Rate this applicant on a scale from 1 to 5 based on their past experience")

Configuration

  1. You'd need to add an OpenAI API Key first, as explained here.

  2. Navigate to your dashboard and create the automation in the right Airtable base.

  3. Under Setup, set the OpenAI API Key you added in step 1.

  4. Set the System Instructions. You can provide context to the model here for the task at hand.

  5. Set the Prompt Source to either Static Prompt or Airtable Field. A static prompt would be identical for every record, whereas a prompt from an Airtable field would be different for every record (containing data from that record, e.g. for analysis).

  6. Set the Prompt to something like "Translate this text to French" or pick the Prompt Field.

  7. Then set and Output Field.

  8. Optional: Add Attachment Fields to pull in files for processing.

  9. Under GPT Model, choose the model to use

  10. Optional: Define parameters for the model under Advanced

Did this answer your question?