IA Agent read only first Row on Google Sheet

Questions
1

Describe the problem/error/question

IA Agent read only first Row on Google Sheet, the Ggoogle Sheet Tool read is okk, it reading from the first to the last row

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

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

Hey @Yann_LOUISIN welcome to the n8n community!

As i can see in your ‘Get Row(s)’ node you have given ‘Data Location on Sheet’ but there instead of specifying yourself let the AI Agent decide that, with this the AI will have access to the rows and will be able to assist you with the related queries, use that 'star/magic’ button on the right of the range and then try running the workfow.

image
image466×288 6.51 KB

Let me know if this helps!

Cheers!