Airtable lets your Lovable app read from and write to bases, tables, and records managed by your team in the Airtable app. It’s designed for apps where the source of truth lives in Airtable and you want a custom interface (internal tool, customer-facing portal, or workflow) on top of it. With Airtable, your app can:Documentation Index
Fetch the complete documentation index at: https://docs.lovable.dev/llms.txt
Use this file to discover all available pages before exploring further.
- List bases, tables, fields, and views using the Metadata API
- Create, read, update, and delete records in any base
- Filter, sort, and paginate records using Airtable formulas and views
- Build internal tools and customer-facing apps backed by Airtable data
- Keep a single source of truth in Airtable while exposing a tailored UI to users
Common use cases and example apps
| Example app | Example prompt | Description |
|---|---|---|
| Internal CRM on top of Airtable | Use Airtable and build a CRM that reads contacts and deals from my Airtable base and lets the team update statuses inline. | Turn an Airtable base into a custom CRM. The app reads contacts and deals, lets users update fields, and writes changes back so Airtable stays the source of truth. |
| Customer-facing portal | Use Airtable and build a customer portal where each customer sees only their own orders from my Airtable Orders table. | Expose a filtered view of an Airtable table to customers. The app filters records by customer, renders a tailored UI, and hides the rest of the base. |
| Inventory or asset tracker | Use Airtable and build an inventory app where staff can scan items, view stock, and update quantities in Airtable. | Replace manual Airtable editing with a focused operational UI. The app reads inventory records, supports search and barcode scan, and pushes quantity updates back to the base. |
| Submission form that writes to Airtable | Use Airtable and build a job application form. When someone submits it, create a new record in my Applications table. | Capture user input and create Airtable records. The app validates submissions, formats the payload, and creates a row in the chosen table. |
| Event RSVP and attendee dashboard | Use Airtable and build an RSVP page that writes responses to Airtable and shows a live attendee count to admins. | Run events end-to-end on Airtable. The app collects RSVPs, writes them to a table, and renders a dashboard for organizers from the same data. |
| Directory or catalog | Use Airtable and build a directory where each row in my Airtable base becomes a detail page, with filters by category and tag. | Render an Airtable table as a browsable directory. The app lists items with filters, links to detail pages by record ID or slug, and reads all fields from Airtable. |
| Content calendar or workflow board | Use Airtable and build a content calendar that reads my Editorial base and lets editors move pieces between status columns. | Give a team a focused workflow UI on top of Airtable. The app reads records grouped by status, supports drag-and-drop, and updates the status field in Airtable. |
How to connect Airtable
Workspace admins and owners can connect Airtable. You can create multiple Airtable connections using different Personal Access Tokens. This is useful for separating environments (for example, development and production), scoping connections to different bases, or limiting which operations a given app can perform. When the connection is created, Airtable can be linked to any project in the workspace. Multiple projects can use the same connection.Prerequisites
Before connecting Airtable, make sure you have:- An Airtable account with access to the bases you want to connect
- An Airtable Personal Access Token (PAT) with the right scopes and base access
- Lovable workspace owner or admin role
All API requests made through this connector use your Personal Access Token. API usage counts toward your Airtable plan’s rate limits and record limits, and billing is handled directly by Airtable, not Lovable.
Step 1: Create an Airtable Personal Access Token
A Personal Access Token (PAT) lets your Lovable app authenticate with the Airtable Web API. PATs are scoped, so you choose which bases the token can access and which operations it can perform. To create a PAT:Open the Airtable tokens page
Sign in to Airtable and go to airtable.com/create/tokens.
Create a new token
Click Create new token and give it a descriptive name, for example
Lovable integration.Add scopes
Add the scopes your app needs. Common scopes:
data.records:read: read records from tablesdata.records:write: create, update, and delete recordsschema.bases:read: list bases, tables, and fields (Metadata API)schema.bases:write: create or modify tables and fields
data.records:read, data.records:write, and schema.bases:read. Grant only the scopes your app actually needs.Add base access
Under Access, choose which bases this token can use. You can grant access to specific bases or to all bases in a workspace. Limit access to the smallest set of bases your app needs.
Your Personal Access Token functions like a password. Keep it secure and never share it publicly. You’ll need it in the next step.
Step 2: Connect Airtable to Lovable
You can create multiple connections using different Personal Access Tokens. To connect Airtable:Configure the connection
- Display name: Name the connection, for example
Airtable Prod. - Personal access token: Paste your Airtable PAT.
- Who can access this connection: Keep access limited to specific people or invite the entire workspace. See Connection-level access for more information.
Working with bases, tables, and records
The Airtable Web API exposes two surfaces, and both are available through the connector:- Metadata API: list bases, tables, fields, and views. Useful when you want Lovable to discover the schema of a base without hardcoding IDs.
- Record API: create, read, update, and delete records in a specific table.
Limitations
The Airtable connector wraps the Airtable Web API. The Airtable connector cannot:- Receive Airtable webhooks or change events (apps must poll Airtable for updates)
- Use Airtable Automations or scripting block features from your app
- Support per-end-user authentication
- Exceed Airtable’s per-base API rate limits. Heavy traffic should batch requests
How to unlink projects from a connection
Editors and above can remove specific projects from a connection without deleting the connection entirely. The connection will remain available for other projects. To unlink projects:
When unlinked, those projects will no longer have access to through this connection. If a project needs again, you can link it to any available connection.