Airtable Connector

Connect Zenmako to Airtable to read, create, and manage records across your bases. This enables AI to query your Airtable data, add new entries, and collaborate through comments.

Getting Your API Token

Airtable uses Personal Access Tokens for API authentication. Follow these steps to generate one:

Go to https://airtable.com/create/tokens

Click Create new token

Give your token a descriptive name (e.g., "Zenmako Integration")

Under Scopes, add the following permissions:

- data.records:read - Read records from bases - data.records:write - Create and update records - schema.bases:read - View base structure and fields - data.recordComments:read - Read comments on records - data.recordComments:write - Add comments to records

Under Access, select which bases the token can access:

- Choose All current and future bases in a workspace for broad access - Or select specific bases for more restricted access

Click Create token

Copy the token immediately (it will only be shown once)

Store your token securely. If you lose it, you will need to create a new one.

Connecting Airtable

Navigate to the Connections page in Zenmako

Click Add Connection and select Airtable

Enter your credentials:

- API Token: Paste the Personal Access Token you generated

Click Save

Click Test Connection to verify the setup works

If the test succeeds, your Airtable connection is ready to use.

Available Actions

Action

Description

listBases	List all Airtable bases accessible with your token
getBaseSchema	Get the complete schema of a base, including all tables and their field definitions
listTables	List all tables within a specific base
listViews	List all views available in a table
listRecords	Retrieve records from a table with optional filtering, sorting, and pagination
getRecord	Get a single record by its ID
createRecord	Create a new record in a table with specified field values
updateRecord	Update an existing record's field values
listComments	View comments on a specific record
createComment	Add a comment to a record

Example Prompts

Try these prompts to interact with your Airtable data:

"List all my Airtable bases"

"Show me the tables in my Product Roadmap base"

"Get all records from the Tasks table where Status is 'In Progress'"

"Add a new contact named John Smith with email john@example.com to my CRM Contacts table"

"Update the status of task rec123abc to 'Completed'"

Common Issues

"Invalid API token" or "Unauthorized" error

This typically means your token is invalid or has been revoked. Solutions:

Verify you copied the complete token without extra spaces

Check that the token has not expired or been deleted in Airtable

Generate a new token if needed

"Base not found" or "Table not found" error

The token may not have access to the requested base. Solutions:

Go to https://airtable.com/create/tokens and edit your token

Under Access, verify the base is included in the token's scope

If using specific base access, add the missing base to the token's permissions