Google Sheets Node. How to append or update multiple itens within the same row

Questions
1

Hi, how are you?
I’m currently building an workflow that scrape a link from a spreadsheet and create social media and newsletter summaries for it.

I managed to get everything together, but at the final step, after using the Merge node the following happens:

image
image1637×939 254 KB

Basically:

  1. The data was split and renamed correctly.
  2. When I try to send both the Newsletter field and the Twitter field only one of them is being uploaded at the sheet.

Information on your n8n setup

  • n8n version: Beta latest
  • Database (default: SQLite): -
  • n8n EXECUTIONS_PROCESS setting (default: own, main): -
  • Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
  • Operating system: MacOS Sequoia latest
2

Hi @Guilherme_Kurten

Consider using the Merge node in combine mode to ensure the output is a single item, allowing you to pass $json.Twitter

Let me know if this works for your case…

3

Done it, here’s the Merge node output:

image
image1654×948 275 KB

Unfortunately it didn’t work. I’ve got the same issue.
To provide more clarity:

  1. After the merge node, and sending info to sheets, it’s creating multiple rows instead of appending only one:

image
image1862×1350 468 KB

4

this is still output 2 items,
try “All Possible Combinations”

image
image293×288 9.21 KB

5

It worked! Thank you for your patience! I’m a beginner and not a coder haha.