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

[Guilherme_Kurten]

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:

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

[mohamed3nan]

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…

[Guilherme_Kurten]

Done it, here’s the Merge node output:

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:

[mohamed3nan]

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

[Guilherme_Kurten]

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