I’m using the Google Sheets node with the Update Row operation, but it doesn’t return any output data. After the update runs, the next nodes don’t get any items unless I enable “Always Output Data” or add a follow-up read. Is this expected behavior?
Here’s a screenshot of the node’s setup:
Its strange bcs other nodes with the same configuration have created an output.
Yes with “always output data” turned on. But the node has it turned off as you can see in the image. The others therefore too, only that in the other workflow it produces output that is passed back into the loop. I have checked for all things you recommended but the rate limit. How do I do that?
No, that’s not the expected behavior. After the node successfully updates the row, you should get an output item with the columns and values without enabling “Always Output Data” option,
You can test this yourself with any new workflow and test sheet.
So, there’s probably something with your workflow. If you’d like to share it, that would help figure out where the issue is..
yeah sure but it doesnt work to share the file here. I can send you the drive link if you can pass me a gmail adress.
you can share it here like this:
Thanks for the tip. Due to character limits i can only send you the last third and without the openai prompts.
Thanks for sharing @MrHoneybadger
This node caught my attention “Edit Fields3”
The syntax for referencing is not correct: {{ $items('Edit Fields4')[0].json.Firmenname }}
which may cause an error when reading Firmenname (using to match), and as a result, the sheet won’t be updated and you won’t get any output
Here is the correct syntax to reference, for example:
{{ $('Edit Fields4').item.json.Firmenname }}
Please update the rest in the same way and let me know what result you get, this is most likely the issue..
I wanted to reference the first item of the 3. Do you know how else to do that?
you can try use this:
{{ $('Edit Fields4').first().json.Firmenname }}
Take a look here, or ask the AI in the docs directly to give you the correct syntax for your needs:
Let me know if that fixes the issue, or if you’re still having problems with your workflow.
Thank you I got it fixed!
Glad it’s fixe @MrHoneybadger, If any of my replies helped you, I’d appreciate it if you could mark one as the solution..
I would, but I fixed it another way. Didnt see your reply.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.