Airtable agent integration
Having issues to get a connection within the agent with the MCP function. Enabled it by creating the connection to Airtable, it's connected.
Only getting errors, plain error, 404 and 403.
First I tried to list records... not working so I went smaller to create arecord but even that I can't get it to work.
So lets go back to the listing.
Let's say I have a column called "Sector" and I want to list all the fields called "Tekst" and form the column "Locatie" I want to select all the "online" fields.
So I need: (without quotation marks)
baseID = 'app2HDRwYNMNPv5VT'
TableID = 'tbl6GP39XnQi33sGh' or 'Aanbod'?
fields = ?
FilterbyFormula = ?
Can't find any extra info about this, can I find more about this in an article?
And what are the minimum settings to test a connection?
2 Replies
Here’s what to check when using the Airtable “List records” tool inside a Voiceflow Agent.
1│ Connection & permissions
• Make sure the Airtable connection was created with a Personal Access Token that has at least “data.records:read” scope for the base you’re querying.
• A 403 usually means the token cannot see the base/table or does not have that scope.
• A 404 generally means either the baseId or tableId you passed is wrong.
2│ Required fields for a quick test
The only values you need to return a result set are:
• Base ID – e.g.
• Open Airtable → Share → Manage access → verify the token has at least read rights.
• Re-authorise the connection inside Voiceflow if you rotated the token. Docs → https://docs.voiceflow.com (Airtable integration) Airtable formula reference → https://support.airtable.com/docs/formula-field-reference
app2HDRwYNMNPv5VT (grab it from the Airtable URL)
• Table ID or Table Name – either tbl6GP39XnQi33sGh or the friendly name Aanbod.
Leave the other inputs empty and run the action; you should get all rows back. If this still throws an error you know the issue is with the base/table reference or token.
3│ Narrowing the results
• fields – a comma-separated list of field names, e.g.Tekst,Locatie
(only those columns will be returned)
• filterByFormula – any Airtable formula wrapped in quotes; to bring back rows whose Locatie = “online”:"{Locatie} = 'online'"
Putting it together for your case
4│ If you still see errors
• Double-check that the Table name / ID is spelled exactly the same (capitalisation matters).• Open Airtable → Share → Manage access → verify the token has at least read rights.
• Re-authorise the connection inside Voiceflow if you rotated the token. Docs → https://docs.voiceflow.com (Airtable integration) Airtable formula reference → https://support.airtable.com/docs/formula-field-reference
Airtable revoked and connected again
Using this info now:
baseId = app2HDRwYNMNPv5VT
Table (name) = tbl6GP39XnQi33sGh or Aanbod
Went for the bare minimum...
This was the response:
{
"name": "Error"
}
When using the API and the pat token, no problems at all.
Airtable MCP Agent seems out of order for me. Who has a working agent at this moment?
Partially working, when using the baseid and tableID the connection can be made to the table. Using the same info in the settings it can't connect..
Copying it from a notepad into the settings.. makes no difference
Any help would be appreciated
Fixed, the issue was in the prompt. It lacked instructions.... 🤦🏻♂️