Paperclip’s Airtable connector gives your AI agents tools to find records, inspect table fields and create or update rows through its MCP server. Each tool can be Allowed, Ask first or Off.
Base and table reach comes from the Airtable account you authorize and what you share at its authorization screen.
What agents can do with Airtable
- Inspect a base’s tables
list_bases·list_tables_for_base - Find records and check the table’s fields
search_records·get_table_schema - Create or update table records
create_records_for_table·update_records_for_table
How to connect Airtable
- In Paperclip, open Connectors and select Airtable.
- On the Access step, choose the identity and which agents may use the connection.
- Select Sign in with Airtable and complete browser sign-in. Choose what to share when Airtable asks.
Airtable tools for agents40
Write 40
create_automationCreates an automation (trigger plus actions, including conditional and repeating groups).
Full description
Creates an automation (trigger plus actions, including conditional and repeating groups). Saves the draft configuration only — it is off until the user reviews and turns it on in the Airtable UI. Prefer calling `get_create_automation_instructions` first. Example prompt: - "Set up an automation to send a Slack message whenever a new record is added to my Tasks table"
create_baseCreates a new Airtable base.
Full description
Creates a new Airtable base. Example prompts: - "Create a base called 'Project Tracker' in my workspace" - "Set up a new base for tracking job applications"
create_fieldAdds a new field to an existing table.
create_interfaceCreates a new interface within a base.
Full description
Creates a new interface within a base. Interfaces let you present your base's data in custom layouts that teammates can use without needing direct access to the underlying tables. Example prompts: - "Create an interface for the Projects base" - "Set up a new interface for the HR team"
create_pageCreates a new page within an interface.
Full description
Creates a new page within an interface. Supports visualization, dashboard, and recordDetail page types. Supports kanban, list, calendar, gallery, grid, timeline, and recordReview visualization types for "visualization" pages.
create_records_for_tableCreates records in a table.
Full description
Creates records in a table. Example prompts: - "Add a new task called 'Review Q3 budget' to my Tasks table" - "Create a record in the Contacts table for Maria Chen"
Show all 40 Write tools
Write tools 7–40
create_tableCreates a new table in a base.
Full description
Creates a new table in a base. Example prompts: - "Add a Projects table to my base with Title, Status, and Priority columns" - "Create a Contacts table"
delete_automationDeletes an automation that is off.
Full description
Deletes an automation that is off. Automations that are on must be turned off in the Airtable UI first. Example prompt: - "Delete the unused automation named Weekly digest"
delete_interfaceDeletes an interface, including all of its pages, from a base.
delete_pageDeletes a page from an interface.
delete_records_for_tableDeletes records from a table by ID.
Full description
Deletes records from a table by ID. For example: "Delete record with id recsMsWiMlekQ9cqo."
delete_tableDeletes an entire table, including its records, fields, and views, from a base.
describe_page_elementReturns the configuration options for a page element type (list, grid, kanban, calendar, gallery, timeline, recordReview, number, barChart, lineChart, scatterChart, pieChart, donutChart, pivotTable).
describe_page_typeReturns the configuration options for a page type (visualization, dashboard, and recordDetail).
display_records_for_tableRenders records as an interactive widget (kanban board or levels view).
fetch_automation_input_dataFetches dynamic input options for an automation trigger or action (for example Slack channels or Jira projects).
Full description
Fetches dynamic input options for an automation trigger or action (for example Slack channels or Jira projects). Requires an external account ID from `list_external_accounts`. Example prompt: - "Which Slack channels can I send to in this automation?"
get_automationGets the full configuration of a single automation, including trigger and action inputs and deployment status.
Full description
Gets the full configuration of a single automation, including trigger and action inputs and deployment status. Use `list_automations` first to obtain the automation ID. Example prompt: - "Show me the full configuration of the Slack notification automation"
get_create_automation_instructionsReturns the full specification for creating or updating automations — supported triggers and actions, expression language, catalogs, and examples.
Full description
Returns the full specification for creating or updating automations — supported triggers and actions, expression language, catalogs, and examples. AI tools typically call this once per session before building an automation.
get_form_schemaReturns the layout of a form: its sections, fields, required fields, and visibility conditions.
get_record_for_pageGets a single record from an interface page.
Full description
Gets a single record from an interface page. Works even when users only have access to the interface, not the underlying base.
get_table_schemaReturns a JSON representation of a table's fields, including names, IDs, types, and configuration options.
list_automationsLists automations in a base, including ID, name, deployment status, trigger info, and node summaries.
Full description
Lists automations in a base, including ID, name, deployment status, trigger info, and node summaries. Optionally filter by trigger type. Example prompts: - "What automations are configured in this base?" - "Show me automations that run when a record is created"
list_basesFinds the Airtable bases you have access to.
list_external_accountsLists third-party accounts connected to your Airtable account (Slack, Google, etc.) that can be used in integrations and automations.
list_pages_for_baseLists all interfaces and their pages for a base.
Full description
Lists all interfaces and their pages for a base. Pages can be dashboards, record lists, or overview pages.
list_records_for_pageLists records from an interface page.
Full description
Lists records from an interface page. Works even when users only have access to the interface, not the underlying base.
list_records_for_tableList records from a table, with optional filtering and sorting.
list_tables_for_baseLists the table schema for every table in the base.
list_views_for_tableLists views in a table (ID, name, and type).
Full description
Lists views in a table (ID, name, and type). Useful when an automation needs a view ID — for example, triggers that fire when records enter a view.
list_workspacesLists the workspaces you have access to.
revert_actionReverts a previous eligible mutation by action ID.
search_basesFinds bases matching a name and recommends the best match.
search_candidate_linked_recordsSearches candidate records for a linked-record field.
Full description
Searches candidate records for a linked-record field. Works even when users only have access to the interface, not the underlying base.
search_recordsSearch for records in a table by keyword.
Full description
Search for records in a table by keyword. Example prompts: - "Search my Contacts table for 'Acme Corp'" - "Find records mentioning 'Q1' in the Projects table"
submit_formSubmits a form.
Full description
Submits a form. Example prompt: - "Submit the new-hire intake form for John Doe with a start date of next Monday"
test_automation_webhook_triggerRe-runs an automation webhook trigger test to capture the latest representative request body schema.
update_automationReplaces the full draft configuration of an existing automation (trigger, nodes, name, and description).
Full description
Replaces the full draft configuration of an existing automation (trigger, nodes, name, and description). If the automation is on, live behavior is unchanged until unpublished changes are applied with Update in the Airtable UI. Use `list_automations` and `get_automation` first. Example prompt: - "Update the Slack notification automation to also email the assignee"
update_fieldUpdates an existing field's name or description, or a formula field's expression.
Full description
Updates an existing field's name or description, or a formula field's expression. Changing a field's type or its select choices is not supported. Use the Airtable UI for those changes. Example prompts: - "Rename the Status field in my Tasks table to Stage" - "Change the formula on my Total field to multiply Quantity by Price"
update_records_for_tableUpdates fields on existing records.
Full description
Updates fields on existing records. Only the fields you specify change — everything else is left alone.
update_tableUpdates a table, including changing its name or description.
Tool availability and permissions
This provider-published list describes the server’s tools. Authorization and feature access can reduce the tools available on your connection.
These lists use a conservative permission policy. Read requires a provider read-only hint or a reviewed Paperclip read rule. Evidence that an action changes data or submits information elsewhere puts it in Write. Write also includes actions we cannot verify as read-only. Read describes the reviewed evidence; it does not guarantee that an action has no side effects. A connected account can group actions differently.
This list comes from published provider information. Authorization, plan, deployment version and account settings can limit the actions available. No connected account was tested.
Connection policies
Discovered actions become active under the connection’s existing policies. Review the list after each refresh. You can set any tool to Ask first or Off. Deleting records is not easily undone; Airtable’s revision history is the recovery path.
Airtable connector FAQ
Can I require approval for changes?
Set actions that change data to Ask first to require human approval of each call or Off to prevent calls. Allowed actions run without approval. Read and Write grouping is separate from these settings.
What can agents reach in Airtable?
Agents can reach the bases and tables available to the authorizing account and shared at Airtable’s authorization screen. Paperclip has no base or table picker.
What do I need before connecting?
Use an Airtable account with access to the bases you need. An enterprise administrator may need to allowlist the client. Paperclip registers its client automatically.