Problems with my workflow

[pruebaia24]

I have a workflow: When a chat message is received → AI Agent (GPT-4.1 mini) with simple memory → Google Sheets as a mini database. The sheet has 2 columns and 4 rows (Questions/Answers). Problem: when querying row 1, it works, but the other rows say there is no specific information. Everything is configured according to Agustín Medina’s video (mini-tutorial from 1:48:46, total duration 14 hours, uploaded 1 month ago). If you want to see the video I followed for the tutorial, of course.

[Piotr_Sikora]

Hi @pruebaia24

Welcome in n8n community.

Could you share your workflow?
Could you share a link to mentioned tutorial?

[pruebaia24]

Hi @Piotr_Sikora

Thanks for replying. I’ve been having trouble with this workflow because it seems simple, but it hasn’t worked for me.

The video is here: https://www.youtube.com/watch?v=D8o3m6GbwGw&t=7239s Starting at 1:48:50.

[Piotr_Sikora]

Hi @pruebaia24

Ive imported your workflow.

As i understand it is FAQ chatbot which has to answer questions from google sheet.

I’m trying to recreate and found one thing:

"pinData": { "chatbot_web": [] },

In chatbot you have pinned data. Isn’t it blocking your AI Agent? Is it done on purpose?

Second question - is it possible to recreate it in english just for forum debugging?

[pruebaia24]

Hello again and thank you for helping me @Piotr_Sikora

Regarding your first question, the last time I tried to test something, I had left it like that; I forgot to remove the PIN.

And finally, here it is in English with some notes you can read to better understand this problem I’m having

[Jekylls]

Hola @pruebaia24 - I’ve just replicated your workflow and it’s working for me - I think you may just want to double check the method of question and see if you get the answer. but I can see it is accessing the whole sheet as expected.

[pruebaia24]

Hello @Jekylls

Honestly, I don’t know why it’s not retrieving the data correctly. I’ve attached the Sheets and AI Agent configurations; perhaps you can help me review them and see if there’s a problem.

I really want to understand why it’s not working properly.

Here are the data and settings.

Configuration:

[Jekylls]

just a hunch but can you test How can I schedule a call? instead off Hi, How can I schedule a call?

[Jekylls]

Actually I did manage to replicate this issue - I repaired it by going into Chatbot_web and removing/adding back the chatinput varible. for some reason this worked for me.

[Piotr_Sikora]

Hi @pruebaia24

Workflow screenshot:

The document:

JSON of the workflow:

Works correctly on my side. Same as on @Jekylls side. Please try to import it and test it. If you have any further questions feel free to ask.

[Jekylls]

last comment from me: I think you would be best just removing and re-adding the googlesheets node. create new google credentials to force it to re-check that excel sheet you have. that’s the only element that seems to be the cause of the issue. Please do let us know if you get this resolved!

[pruebaia24]

Hello, @Jekylls @Piotr_Sikora sorry for taking so long to respond.

I was able to solve the problem, I appreciate the follow-up you gave me and the time you took, I really thank you.

The changes I made that helped me solve it:

1. I followed your advice
2. I used Google Chrome and now I use Drive
3. I created a new account (my previous free version ran out)
4. I re-registered the credentials
5. I created a new Google Sheets document

Honestly, without your help I wouldn’t have been able to, I really appreciate it

[Jekylls]

Very pleased to hear it @pruebaia24 thanks for not giving up and for fulfilling my curiosity. also thanks for the solution Happy Building!