How can I make updates using two Google spreadsheet nodes 9n my workflow and make sure that the changes appears on a single row on Google sheet

Questions
1

I made multiple append and updates on my workflow using Google sheets but the problem is that it creates a new row and leaving the spaces unfilled in the previous row

Sheets
Sheets453×145 7.55 KB

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the 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

How do you make updates using two Google spreadsheet nodes in your workflow and make sure that the changes appears on a multiple rows on Google sheet?

Feel free to attach your reproducible workflow for us to take a look at, so that we know what exactly you did to make it behave this way.