I’ve set up an AI agent to query work information. I want to make sure that whenever I ask the AI agent questions related to “work arrangements” or “work items,” it must search the information in Google Sheets before replying.
I’ve tried filling in the system message of the AI agent with the reply rules I want it to follow. However, no matter how I modify or adjust it, most of the time the AI agent skips Google Sheets when it’s running and uses Gemini to generate a reply directly. Therefore, most of the time the reply is incorrect (the reply format is correct, but the information in the reply is completely absent from the Google Sheets form. Gemini will randomly fabricate non-existent work information).
I would like to ask how to set it up so that the AI agent completely relies on the Google Sheets data to answer questions.
Information on your n8n setup
- **n8n version:**1.78.0
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- **Operating system:**Windows 11