Airtable

Connect one Airtable base to Formula Bot with read-only OAuth and explicit table selection.

Connect Airtable to Formula Bot to analyze selected base tables in chat and refreshable dashboards. The connector is read-only and never asks you to paste a personal access token.

Requirements

  • Access to the Airtable base you want to connect
  • Formula Bot's Airtable connector enabled in your environment
  • Permission to approve the schema.bases:read and data.records:read OAuth scopes

Connect a base

  1. Go to Connectors, then Airtable.
  2. Select Authorize Airtable and approve read-only access.
  3. Choose one authorized base.
  4. Select the tables Formula Bot may read, or choose Select all.
  5. Name the connector and save it.

“Select all” is a snapshot of tables visible during setup. Tables added later are not automatically authorized. Use Manage to change table selection, and Refresh selected schema after fields or views change.

Data behavior

  • Formula Bot fetches records through Airtable's Web API using table, view, and field IDs.
  • Preview requests return at most 1,000 rows. Top-N and complete requests return at most 100,000 rows.
  • A complete result over 100,000 rows fails without publishing partial data. Use a filtered Airtable view or formula to narrow it.
  • Attachments are represented as metadata such as filename, MIME type, and size. Formula Bot does not download attachment files or retain temporary attachment URLs.
  • Dashboard refreshes replay the saved structured Airtable request. They do not infer a new request from chat text.

Quotas and cost

Formula Bot does not incur an Airtable per-call bill, and Airtable does not publish a separate charge to register an OAuth integration. API calls count toward the connected Airtable workspace's plan allowance and remain subject to Airtable's five-requests-per-second per-base limit. Because each records page contains up to 100 records, fetching 100,000 rows can use roughly 1,000 Airtable API calls.

Disconnect and retention

Deleting the last Formula Bot connector that references an Airtable authorization removes Formula Bot's stored OAuth tokens. Generated dataset artifacts follow Formula Bot's normal retention settings. To revoke the connected app at Airtable as well, use Airtable's connected-app settings.

If Airtable reports revoked or expired authorization, choose Reconnect on the connector page. Airtable refresh tokens can expire after extended inactivity.

Troubleshooting

  • Reconnect required: authorize Airtable again; Formula Bot never exposes stored tokens.
  • Base or table missing: confirm the Airtable account can access it and that the table was selected in Formula Bot.
  • Quota or rate-limit error: wait and retry, narrow the request with a view, or review the Airtable workspace plan allowance.
  • Schema too large: select fewer tables so the authorized runtime context stays within the connector budget.

Next steps