--- title: "Connecting Airtable" description: "Connect your Airtable workspace, grant access to the right bases, and configure how BankSync writes bank data into a table." section: "Integrations" canonical: "https://banksync.io/docs/integrations/airtable" --- Airtable combines the simplicity of spreadsheets with the power of a database. Connect your Airtable account once, grant access to the bases you want to use, then point feeds at a table inside one of those bases. This guide covers connecting Airtable, the base and table structure, and Airtable-specific mapping behavior. [![Configuring Airtable as a feed destination: choosing Airtable, authorizing the workspace, selecting Acme Airtable, and picking the Finance base and Transactions table.](https://cdn.banksync.io/videos/airtable-destination.poster.9a2f38ba3ebe6314.png)](https://cdn.banksync.io/videos/airtable-destination.e393e3f1db685381.mp4) [Watch: Configuring Airtable as a feed destination: choosing Airtable, authorizing the workspace, selecting Acme Airtable, and picking the Finance base and Transactions table.](https://cdn.banksync.io/videos/airtable-destination.e393e3f1db685381.mp4) > **This guide covers:** 'Connecting Airtable as an integration and understanding Airtable-specific options. For the complete feed setup process (accounts, mapping, schedule), see our Creating Your First Feed guide.' ## Connect Airtable Airtable connects via OAuth: you authorize BankSync in an Airtable popup and choose which bases to grant access to. BankSync can only see the bases you grant. **Connect Airtable** 1. **Open the Add Connection dialog** — Go to the Integrations tab and click the add card ("Connect to an Integration"). The "Add Connection" dialog opens. 2. **Pick Airtable** — Find Airtable under "Spreadsheets & docs" (or type "airtable" in the search box) and click it. 3. **Open the authorization link** — Click "Open Authorization Link". Airtable's authorization popup opens. 4. **Choose bases and grant access** — Sign in, select which bases BankSync may access, and approve. BankSync detects the completed authorization and closes the dialog automatically. When it finishes, Airtable appears as a card on your Integrations tab with a Connected status. ![The Integrations tab showing a grid of connected integration cards, including an Airtable connection named Business Airtable with a green Connected status, alongside Google Sheets, Notion, Postgres, and Excel cards and a dashed Connect to an Integration tile.](https://cdn.banksync.io/screenshots/integrations/connections.a945ee6270877dde.png "A connected Airtable integration on the Integrations tab.") > **Add more bases later:** If a base is missing from the picker in a feed's Destination tab, it usually wasn't granted during authorization. Re-run the flow (Add Connection, Airtable, Open Authorization Link) and grant the extra base. Re-authorizing refreshes access in place and does not disturb your existing feeds. ## Airtable structure Airtable organizes data in a hierarchy. In the feed's **Destination** tab you select: **Base → Table**. BankSync then shows the fields available in that table for mapping. - **Workspace** — Top-level container for all your bases - **Base** — A database containing related tables - **Table** — Where your synced records go ## Airtable field types Ensure your Airtable table has the appropriate field types: - **Date** — Use Date field type for transaction dates - **Description** — Use Single line text or Long text for descriptions - **Amount** — Use Number or Currency field type for amounts - **Category** — Use Single select or Multiple select for categories ## Field mapping for Airtable - **Type Validation** — BankSync validates field type compatibility. Mapping a number field to a text field will show a warning. - **Auto-Fill** — Click "Auto fill" to automatically match fields by name. "Amount" will match to "Amount" or "Transaction Amount". - **Batch Processing** — BankSync syncs records in batches of 10 to respect Airtable's API limits and ensure reliable syncing. ## If your Airtable connection expires Airtable access can stop working if the OAuth token expires or you revoke BankSync from your Airtable account settings. Feeds writing to Airtable then stop adding records, and the picker in a feed's Destination tab can't list your bases. To fix it, re-run the connect flow from the Integrations tab (Add Connection, Airtable, Open Authorization Link) and re-grant your bases. Your feeds, their target tables, and field mappings stay intact, and records already written to Airtable are never deleted; the next sync simply resumes. ## Tips for Airtable **Best practices** 1. **Create a dedicated base for finances** — Keep your financial data organized separately from other projects. 2. **Use Currency field type for amounts** — This enables proper formatting and currency symbol display. 3. **Create views for different analyses** — Filter by category, group by month, or sort by amount to gain insights. 4. **Use Airtable automations** — Set up automations to notify you of large transactions or create monthly summaries. > **Airtable Features:** 'Rich field types including currency, dates, and selects. Multiple views (Grid, Calendar, Kanban, Gallery). Built-in automation capabilities. Integrations with 1000+ apps via Zapier.' ## Next steps Once you've connected Airtable, you're ready to create your first feed. [Connect Airtable](https://app.banksync.io) ## Related guides - [Creating your first feed](/docs/bank-feeds/creating-first-feed): the complete walkthrough from bank to Airtable table. - [Configuring field mappings](/docs/bank-feeds/field-mappings): map bank fields onto your Airtable fields. - [How to sync balances](/docs/bank-feeds/sync-balances): track account balances in an Airtable table. - [Managing your integrations](/docs/integrations/managing-integrations): rename, reorder, reconnect, or disconnect this connection later.