Google Sheet node problem

Questions
1

Im using a Basic LLM to create icebrakers sentences. Ive done this before with this same workflow but I think ever since the new update the Google Sheet node is not outputing the data in the exel sheet. When I run the workflow the workflow ends normally but theres no output from the update row in sheet Google sheet node.

What is the error message (if any)? Non

image
image1715Ă—815 88.2 KB

This is the node after running it a fwe times. it receives input data but nothing comes out.

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • **n8n version: 1.108.2
  • **Database: SQLite
  • **n8n EXECUTIONS_PROCESS setting: own
  • **Running n8n via: Docker
  • **Operating system: Ubuntu 24.04
2

Hi @jotyrojo

I just tested it, and it actually doesn’t output anything. The reason is that the “Prompt (User Message)” is not well structured.:
image

image
image425Ă—112 8.7 KB

I edited it to:

fist_name: {{ $json.fist_name }}
email: {{ $json.email }}
organization_name: {{ $json.organization_name }}

and now it’s working,

image
image418Ă—123 10.7 KB

Please try that on your end and let me know the result.

3

now is at least outputting something, but theres still an error:

image
image1708Ă—832 132 KB

And for some reason is not findingthe velues of the mapping from the google sheet after the Basic LLM node. :thinking:

4

I was able to fix it. To trubleshoot i turn on the setting Excecute Once on the Basic LLM node. This led the update row in sheet node to have the incomplete data and ask for it since in the get row were 500 rows and when it reached the update row there was only one row since the basic LLM node was only exceuting once. Damn I’ve wasted 2 days in this.

Thanks for the help @mohamed3nan

5

Glad it wor @jotyrojo, please mark my reply as the solution, thanks..