Google Sheets wrong results in AI Agent

Questions
1

Describe the problem/error/question

Hi everyone,

I’m currently working on an n8n workflow where I’m building a chatbot. The bot is supposed to retrieve information about a customer from a Google Sheets database based on user input (e.g., “Ziltner”). The data is correctly read from Google Sheets and passed to the OpenAI node.

However, I’m facing the following issue:
Even when the customer is present in the data (e.g., “Ziltner”), the OpenAI node responds with “No match: The customer Ziltner does not exist in the data.”

Sometimes the node finds the person but only returns one result out of three matches.

For other names, it finds only one match, even though there should be two.

Then there are names where it works perfectly and returns all the correct results.

I’m running out of ideas about what could be causing this.

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.75.2
  • Database (default: SQLite): SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**Docker
  • **Operating system:**Ubuntu
2

Your problem is mostly related to:

  • The model you are using (smarter models are better for data analysis)
  • The prompt (improve your prompt to be more precise and descriptive)

But you could also try updating your n8n to version 1.80.5. or newer.
Some bug with AI tools were fixed.

Can you also share an screeshot of an example chat?
Show us the data that has been retrieved and what the AI is saying.