Airtable automation action: Generate with AI

Prev Next

Plan availability

Paid plans only with varying limitations

Permissions

  • Owners/Creators - Create, delete, duplicate, configure, or rename an automation and edit an automation's description.

  • Editors - View an automation's configuration or copy an automation's URL.

Platform(s)

Web/Browser, Mac app, and Windows app 

Related reading

Creating an automation - Learn how to set up your first automation in Airtable.

Note
Consider having Omni create an automation for you. With Omni's AI capabilities, you can use plain text requests to build, update, and query in your Airtable base.


Using AI in automations

With AI in Airtable Automations, you can combine the power of AI to build automated workflows such as:

  • When negative customer feedback is submitted, summarize it, and share it in Slack with the appropriate team(s)

  • Summarize team updates on Friday and send an email of the summary with the team every Monday morning

  • Fill out an interface form, then have AI generate a guide in google docs and share the draft with content editors

Automations that involve the Generate with AI action will incorporate at least three components, but can certainly contain more depending upon the complexity of the workflow that you are wanting to automate:

  1. An automation trigger that will tell Airtable to begin the automation and queue up the AI to run the prompt.

  2. A "Generate with AI" action step with the prompt, randomness, and model sections configured.

  3. One or more automation action steps that takes the content generated by the AI and does something with it - writes it to a record in Airtable, sends it in an email, posts it to Slack, etc.

Configuring an automation using the “Generate with AI” action

In this example, we will us AI in an automation that will send an email every Monday morning with a summary of all meetings last week.

Note

You'll want to adjust any sample settings listed in the walkthrough below to match the field, view, and table names in your base. Use this example, just as a reference to think about the overall structure of building this type of automated workflow.

To configure an automation using the “Generate with AI” action:

  1. Open your Airtable home screen.

  2. Open the base where you want to create an automation.

  3. Click Automations.

  4. Click + Create new.

  5. Click + Create automation.

  6. Click + Add trigger.

    1. Once clicked, the available triggers will display for you to choose from.

    2. Create a new automation with an "At a scheduled time" trigger set to run every 1 week on Mondays at 6:30 a.m. Test the trigger and move on once the trigger successfully tests.

  7. Next, we will use a "Find records" action to find only meetings from the past week. In this example, we will set the "Table" to be Weekly meetings, then "Find records based on" a View, and then set the "View" to be This past week's meeting.

  8. Next, you'll add the “Generate with AI” action step. Here you will configure the prompt, randomness, and model. Let's focus on the prompt since randomness and model are covered in this article. For the prompt, we want a mix of static text to give the AI model context along with the dynamic details about the meeting that the AI model can interpret to generate a summary.

  9. You will also want to add a Send email automation action so that you can send the summarized meeting notes to your colleagues via email. Configure the "To" and "Subject" fields according to your needs. Then, in the "Message" you'll want to insert a token of the “Generate with AI” action's "Response." This response is the output that the AI generates based on the settings you configured in the prior steps of this automation.

Limitations

The total number of words in your query and response must be under a certain amount set by the AI model being used on the backend and Airtable’s automation system. This includes the words in the fields referenced by your query. If you exceed these limits in your query, you will see an error message. If the AI's response exceeds the limits, the text will be truncated.

  • Lower powered AI models: Up to ~12,000 words

  • Higher powered AI models: Up to ~90,000 words

  • In addition to the model word limitations, the prompt cannot exceed 64,000 characters.

Note

For more information about model types and credit limitations is available in this article.

FAQs

I’m running into an error with my automation, what do I do?