Airtable

Powered by Zapier.

What is Airtable?

Airtable is a database that works like a spreadsheet, bases, tables, and records, used for everything from CRMs and content calendars to project trackers and inventories. Keeping a base current is steady manual work: adding records, updating fields, looking things up across tables. This connection lets Fabric's assistant handle that for you, in plain language.

What Fabric's assistant can do with Airtable

Once your Airtable is connected, Fabric's AI assistant can act on your bases from plain-language requests.

Find and read. Find records, tables, and bases by name or ID, get all records in a table, and get a base's schema, so you can pull the data you need, and let the assistant understand how a base is structured before it acts.

Create and update records. Create records, create records in bulk, create-or-update, update a record or many at once, delete records, and add a comment to a record, so keeping a base current becomes something you ask for rather than type in.

Build structure. Create bases and tables, so standing up new data stays quick without building it by hand.

You describe what you want and the assistant maps it to the right Airtable action or trigger.

You stay in control

The assistant acts only when you ask. For anything that removes or overwrites data, deleting a record, updating one or many in a way that overwrites, it confirms with you before going ahead, unless you've told it not to for a particular task. Finding, reading, and getting a schema never change anything.

When keeping a base current is a recurring job, you can set up a Fabric AI job that runs on a schedule, adding records from another source, updating a tracker, tidying a table, so the routine data work runs itself while you keep approval over anything that deletes or overwrites.

Search your Airtable from Fabric

Alongside the assistant, connecting Airtable adds keyword search over your records from Fabric's main search, so a record is findable by matching text in the same place you search the rest of your library, rather than searching Airtable separately.

How people use it

No-code builders keep their bases current by asking the assistant to add and update records, rather than filling in fields by hand.

Teams have new or changed records trigger follow-on actions, so a base that records something can set the next step in motion.

Anyone running a base as a CRM or tracker can pull records by describing what they want, and create or update them by asking.

People with recurring base upkeep set up a scheduled AI job to handle it, while keeping approval over anything destructive.

Frequently asked questions

What does the Airtable connection do?

It lets Fabric's AI assistant manage your Airtable, taking actions like finding records, creating and updating them, reading a base's schema, and creating bases and tables. It also adds keyword search over your data in Fabric.

What can the assistant do in Airtable?

It can find records, tables, and bases by name or ID, get all records, get a base schema, create records individually or in bulk, create-or-update, update one or many records, delete records, add comments to records, and create bases and tables. You ask in plain language rather than choosing from a fixed list.

Does the assistant change my base on its own?

No. It acts only when you ask, and for anything that deletes or overwrites data it confirms with you first, unless you've deliberately told it not to for a specific task. Finding, reading, and getting a schema change nothing.

Can it understand how my base is structured?

Yes. It can read a base's schema, so it works with your tables and fields as they actually are rather than guessing at the structure.

Can I automate record updates?

Yes. A Fabric AI job can run on a schedule, for example adding records from another source or updating a tracker, while you keep approval over anything destructive.

Can I search my Airtable from Fabric?

Yes, by keyword, from Fabric's main search, so a record is findable by matching text alongside the rest of your library.

How is this different from the Google Sheets connection?

Both work with structured data. Google Sheets is a spreadsheet, rows, cells, and formatting; Airtable is a relational database, bases, tables, records, and schema. Choose the one your data lives in.

Will it delete or overwrite records without asking?

No. Nothing that removes or overwrites data happens without your confirmation, unless you've chosen to let a specific task run without it.

Is my Airtable data secure?

Everything in Fabric is encrypted in transit and at rest. The connection acts on your bases with your authorisation, and you control what it does. The details are in the privacy and security guide and Fabric's privacy commitment.

Does this work through MCP or the API?

Fabric also exposes your library and connected tools to external AI through its MCP server and API; this connection is the built-in way to have Fabric's own assistant work with your Airtable.

Does Fabric work with other tools alongside Airtable?

Yes. Airtable is one of many connections. You can also connect Notion, Google Drive, and Gmail, and automate across many apps with Zapier.