Arlet
Airtable

Connect Airtable to Gemini Enterprise

Search, read and write Airtable from Gemini Enterprise. Arlet links the two through one MCP connection and takes care of keys and authentication.

Enable Airtable in ArletGemini Enterprise connection guide (docs)

Arlet makes Airtable's official MCP server available from the AI client you already use. There is no OAuth integration to create on the Airtable side. Signing in completes the connection.

Beyond searching, adding and updating records, the AI can create tables and fields, draft automations and submit forms. What it can read or write is exactly what your Airtable account can. The available tools are those provided by Airtable's official server.

How to connect Airtable to Gemini Enterprise

  1. 1

    In the Arlet dashboard, open Integrations → Add an integration and choose Airtable. Sign in with Link Airtable, name the connection and click Create.

  2. 2

    Sign in to Gemini Enterprise with your organization Google account and open the gear icon at the bottom left → Connectors → Add MCP Server.

  3. 3

    In the MCP info tab, enter https://mcp.arlet.dev/mcp/ as the Server URL and "Arlet" as the Name. In the Auth tab, enter the OAuth settings from the Arlet docs (Authorization URL / Token URL / Client ID / Client Secret / Scopes) and click Add.

  4. 4

    In the connector list on the chat screen, click Connect on Arlet, sign in with Google and authorize. Arlet can then be enabled with the toggle.

Adding custom connectors (MCP) requires a Gemini Enterprise subscription and is not available in the consumer Gemini app. See the docs for the values to enter in the Auth tab.

What you can do

Airtable tools that Gemini Enterprise can call.

  • list_bases

    List the bases you can access.

  • search_bases

    Find a base by name.

  • list_tables_for_base

    List the tables in a base.

  • get_table_schema

    Get a table's field definitions.

  • list_records_for_table

    List records with optional filtering and sorting.

  • search_records

    Search records in a table by keyword.

  • create_records_for_table

    Add records to a table.

  • update_records_for_table

    Update existing records.

  • delete_records_for_table

    Delete records by ID.

  • revert_action

    Undo a recent change.

  • create_table

    Create a table.

  • create_field

    Add a field to a table.

  • update_field

    Rename a field or change its description or formula.

  • list_views_for_table

    List a table's views.

  • list_automations

    List the automations in a base.

  • create_automation

    Draft an automation from a trigger and actions.

  • get_form_schema

    Read a form's fields and required conditions.

  • submit_form

    Submit a response to a form.

The tool list follows what Airtable's official MCP server provides and may change.

Example uses

  • Clean up a customer list

    Find blanks and inconsistent values in the customer table and fill them in from company names.

  • Turn daily reports into records

    Pull deals and tasks out of a report or email and add them as records to the right table.

  • Summarize a table

    Pull records by condition and write a report on counts and trends.

  • Design a new tracker

    Describe what you want to track and get a table with fields, plus a draft automation.

Prompts you can use as-is

  • In the Customers table, find rows with an empty Industry and fill it in from the company name
  • Extract today's meetings from this daily report and add them as records to the Deals table
  • In the Tasks table, group everything due this week and still open by assignee
  • Create a table to track job candidates, and draft an automation that posts to Slack when the status changes

Use Airtable with other AI clients