Struggling a bit with Google Sheets

[The_Word_On_Tech]

Hey guys! I’m new to N8N and by no means a dev. I’ve somehow miraculously managed to get far enough in my first workflow to the point that if I can fix this issue the workflow will work very well for my purposes. The issue I am having is with the Google Sheets Update Row node. I spent probably 8 hours trying to get it to work using the Apend or Update row node or the Update Row Node (and I tried just about every other node except create/delete sheet). The result seems to occur when I choose the Apend or Update node, but the problem is instead of updating the cells under the Completion column which are empty it fills out the sells directly under the rows where no data is present for any columns.

Google Sheets Read Node

[
  {
    "row_number": 2,
    "Input": "ice maker"
  },
  {
    "row_number": 3,
    "Input": "Silly banana chips"
  },
  {
    "row_number": 4,
    "Input": "paper sheets half inch"
  },
  {
    "row_number": 5,
    "Input": "chilly hot dogs"
  },
  {
    "row_number": 6,
    "Input": "madagascar burning peppers"
  },
  {
    "row_number": 7,
    "Input": "burgers and fries combo"
  },
  {
    "row_number": 8,
    "Input": "sofa supreme purple"
  },
  {
    "row_number": 9,
    "Input": "iron claw"
  },
  {
    "row_number": 10,
    "Input": "porcelain mug"
  }
]

OpenAI Message Model Node

[
  {
    "index": 0,
    "message": {
      "role": "assistant",
      "content": "Portable ice maker"
    },
    "logprobs": null,
    "finish_reason": "stop"
  },
  {
    "index": 0,
    "message": {
      "role": "assistant",
      "content": "Banana Chips"
    },
    "logprobs": null,
    "finish_reason": "stop"
  },
  {
    "index": 0,
    "message": {
      "role": "assistant",
      "content": "Half-Inch Grid"
    },
    "logprobs": null,
    "finish_reason": "stop"
  },
  {
    "index": 0,
    "message": {
      "role": "assistant",
      "content": "Spicy Hot Dogs"
    },
    "logprobs": null,
    "finish_reason": "stop"
  },
  {
    "index": 0,
    "message": {
      "role": "assistant",
      "content": "Spicy Peppers"
    },
    "logprobs": null,
    "finish_reason": "stop"
  },
  {
    "index": 0,
    "message": {
      "role": "assistant",
      "content": "fast food"
    },
    "logprobs": null,
    "finish_reason": "stop"
  },
  {
    "index": 0,
    "message": {
      "role": "assistant",
      "content": "Purple Sofa"
    },
    "logprobs": null,
    "finish_reason": "stop"
  },
  {
    "index": 0,
    "message": {
      "role": "assistant",
      "content": "claw hammer"
    },
    "logprobs": null,
    "finish_reason": "stop"
  },
  {
    "index": 0,
    "message": {
      "role": "assistant",
      "content": "Porcelain mug"
    },
    "logprobs": null,
    "finish_reason": "stop"
  }
]

Edit Fields Node

[
  {
    "message": {
      "content": "Portable ice maker"
    }
  },
  {
    "message": {
      "content": "Banana Chips"
    }
  },
  {
    "message": {
      "content": "Half-Inch Grid"
    }
  },
  {
    "message": {
      "content": "Spicy Hot Dogs"
    }
  },
  {
    "message": {
      "content": "Spicy Peppers"
    }
  },
  {
    "message": {
      "content": "fast food"
    }
  },
  {
    "message": {
      "content": "Purple Sofa"
    }
  },
  {
    "message": {
      "content": "claw hammer"
    }
  },
  {
    "message": {
      "content": "Porcelain mug"
    }
  }
]

Google Sheets AppendOrUpdate: Sheet

[
  {
    "Completion": "Portable ice maker"
  },
  {
    "Completion": "Banana Chips"
  },
  {
    "Completion": "Half-Inch Grid"
  },
  {
    "Completion": "Spicy Hot Dogs"
  },
  {
    "Completion": "Spicy Peppers"
  },
  {
    "Completion": "fast food"
  },
  {
    "Completion": "Purple Sofa"
  },
  {
    "Completion": "claw hammer"
  },
  {
    "Completion": "Porcelain mug"
  }
]

In the above image, the Google Sheets AppendOrUpdate Node is putting the data lower than it should, appending and not updating the rows I am trying to update.

• n8n version: Version 1.34.2
• Database (default: SQLite): SQlite
• n8n EXECUTIONS_PROCESS setting (default: own, main): I have no idea
• Running n8n via : I believe its npm I’m not 100% sure I’m self-hosted desktop
• Operating system: Windows 11 Home

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

[barn4k]

hello @The_Word_On_Tech

You should choose the Update operation (append will append the data after the last non-empty row) and choose the right column to match on. I don’t know how are you goind to match, but if the precedence is the same, then use Merge node to merge the Completion variable and row_number from the gSheets Read node, then match on row_number.

Example:

[The_Word_On_Tech]

The strange thing is I don’t even have Update Operation as a node option. Like I can see you have update:sheet on the last part. I don’t see that kind of node available for me.