Airtable

Database

Use Airtable as a living operational database for your AI agents. 2 record triggers kick off workflows when data changes. 17 actions cover full CRUD across bases, tables, records, and comments.

2 triggers 17 actions available

Exception flagged during purchase order processing

Agent creates record in Airtable Exceptions table with issue type and source

AP manager notified via Slack with direct link to Airtable record

Agent checks record status before taking downstream action

Manager marks record Resolved in Airtable to trigger resolution

Agent reads resolution and applies it to originating ERP transaction

What This Integration Enables

Airtable integration gives agents bidirectional access to Airtable databases: reading records to make decisions, creating records to log activity, updating records when workflow steps complete, and reacting to record changes via triggers. Agents use Airtable as both a data source and a workflow coordination layer.

Without FlowRunner

Manual exception tracking Exceptions logged in email threads or missed entirely

No structured queue AP manager hunts through inboxes to find issues

Delayed resolution ERP corrections happen days after exceptions are found

With FlowRunner

Structured exception queue Every issue tracked with full context in Airtable

Direct ownership Each exception assigned and linked in one click

Automated resolution ERP updated the moment Airtable record is marked resolved

Use Case Scenarios

Exception Tracking and Resolution

An agent processing purchase orders creates a record in the Exceptions table in Airtable each time it flags an issue: duplicate invoice, price mismatch, missing PO. Each record contains the issue type, the source document, and the recommended action. The AP manager opens Airtable each morning and sees a structured queue of exceptions to resolve. When they update a record status to Resolved, On New or Updated Record fires, the agent reads the resolution, and applies it to the originating ERP transaction automatically.

Content Calendar Automation

A marketing team uses Airtable to manage their content calendar. When a record is created with status Ready for Publishing, On New or Updated Record fires. The agent retrieves the content, publishes it to the appropriate channel (Webflow, social media), updates the record status to Published, and logs the publish timestamp and URL in the record. The team manages the editorial process in Airtable. Publication happens without touching additional systems.

Project Onboarding

A new client project is approved. The agent creates a new Airtable base from a standard template, creates the initial task records for the first sprint, invites the project team members via Slack, and posts the project base link to the team channel. The project is set up in the tool the team uses without any manual configuration.

Human-in-Loop Highlight

When an agent flags an exception record in Airtable, it does not just create the record and wait. It sends a Slack message to the responsible team member with a direct link to the Airtable record: "New exception flagged in your queue: [Issue Type] for [Vendor/Invoice]. Review and mark resolved here: [link]." The team member resolves it in Airtable. The record update triggers the agent to complete the downstream action. One interface, clear ownership, no email threads.

Agent processes routinely

Detects exception requiring judgment

Clear match Continues automatically

Ambiguous Routes to human via Slack

Human decides

Agent resumes with decision

Agent Capabilities

17 actions

Base and Table Management

Create Base Creates a new Airtable base. Used in project provisioning workflows: when a new project is approved, the agent creates a dedicated Airtable base with the standard project tracking structure automatically.
Create Table Creates a new table within an existing base. Used when a workflow needs to add a tracking layer to an existing base without manual setup.
Update Table Modifies table configuration. Used for schema management workflows.
Get Base Schema Retrieves the field definitions for all tables in a base. Used when agents need to understand the data structure before reading or writing records.
Get Bases Returns a list of accessible bases. Used for navigation and workflow orchestration across multiple bases.

Record Operations

Create Record Creates a single new record in a table. Used to log workflow events, track exceptions, or create work items that need human follow-up.
Create Records Creates multiple records in a single operation. Used for bulk data imports and batch processing workflows.
Create or Update Record Checks for an existing record matching specified fields and updates it if found, creates it if not. Used in synchronization workflows where duplicates must be avoided.
Update Record Modifies fields on an existing record. Used to track status changes as workflow steps complete: a record moves from Pending to In Review to Approved.
Find Record Searches for a single record matching criteria. Used as a lookup step before creating a new record to check for existing entries.
Find Many Records Returns multiple records matching filter criteria. Used in reporting, monitoring, and bulk processing workflows.
Delete Record Removes a single record. Used in cleanup workflows when a temporary tracking record is no longer needed.
Delete Records Removes multiple records in a single operation. Used for batch cleanup.

Comments

Create Comment Adds a comment to a record. Used to log agent actions, decisions, and context directly on the Airtable record.
Get Latest Comments Retrieves recent comments on a record. Used when agents need to check prior notes or context before taking action.
Update Comment Modifies an existing comment. Used for correction workflows.
Delete Comment Removes a comment. Used for cleanup.

Triggers

2 triggers

Event Triggers

On New Record Fires when a new record is created in a monitored table. Used to kick off workflows the moment someone adds a row: a new vendor entry triggers a vendor onboarding workflow, a new project record triggers resource allocation, a new request record triggers the intake process.
On New or Updated Record Fires when a record is created or when any field in an existing record changes. Used for change-driven workflows: when an approval status changes to Approved, the agent triggers the next step automatically.

Start building with Airtable

$100 in credits. No card required. Connect in minutes.

Start Building Free Book a demo