Airtable

Airtable

  • Purpose: Connect to an Airtable base to analyze spreadsheet-database data.
  • When to use it: Great for teams managing structured data in Airtable who want to build dashboards without exporting manually.
  • How to create it:
    1. Go to Data Sources and click Add.
    2. Select Airtable.
    3. Name: Enter a unique name for this connection.
    4. API Key: Your Airtable personal access token (generated at airtable.com/account).
    5. Base ID: The ID of your Airtable base (found in the base URL: https://airtable.com/appXXXXXXXX).
    6. Table Name: The exact name of the table to connect.
    7. View: (Optional) Load a specific view’s filtered and sorted records instead of all rows.
    8. Click Test Connection to verify, then Save.

Airtable Configuration

Note: Use a Personal Access Token with data.records:read scope — legacy API keys are deprecated by Airtable.