I’m setting up an AI agent that can do pretty much everything with a base in Airtable. I’m trying to get the AI to create a record but for some reason the tool Create Record is not receiving the input for me to map out the Create Record Tool so I pretty much mapped it blind.
Have you tried using a different model? Perhaps GPT 4.1 mini which has a much larger context window. You can also set options for the response format directly without using the output parser.
I did change the database with no luck. I also change the AI input to this one:
"
You are a helpful assistant.
Return a valid JSON object with these fields:
Task: plain string, the task name
Assignee: one of [“Jonathan Nieves”, “Maria Lopez”, “Carlos Rivera”] — match the name exactly, no extra quotes or characters
Status: one of [“Todo”, “In progress”, “Done”] — case must match exactly
Priority: one of [“Low”, “Medium”, “High”]
Do not wrap strings with equal signs or extra quotes.
Example:
{
“Task”: “Go to the gym”,
“Assignee”: “Jonathan Nieves”,
“Status”: “In progress”,
“Priority”: “High”,
}
"
And still the same problem.
I’m starting to think it has to do with the environment.
@Lwissitoon is your n8n Self hosted or on the you pay membership?
I set the Create record node no set fixed values when creating a record. And it created the record with no task name. So, the problem must be between the AI node and the Create Record node. I’m pretty sure is because the Create record node can’t map the values because for some reason the AI node is not sending them. Shi…
The fields are set as the JSON request, I checked and they are exactly the same. I’ve also let the AI handle the mapping but the same result keep happening.
Instead of manually trying to map the values to send you should try enable the “Let the model define this parameter” option on those fields you’re trying to set, at least I was able to get this working against my airtable!
I notice that in the create record node when the field in the Airtable is set to single select then the node doesn’t let the AI choose between the option and you have to configure it to select only one of the singles select options. What I did was change the Airtable fields to single line text and let the AI define automatically the text in the output. Thats a shame because now the fields are not colored depending in which field option you choose, but at least it works for now:
