Jun '25 • 🛠️ dev-help
Google Sheets node creates multiple rows instead of one — how to combine fields into a single row?
I'm working on an n8n workflow where I'm collecting form data via a Webhook and saving it into a Google Sheet.
The problem is that instead of all the fields (name, email, phone, etc.) going into one row, the Google Sheets node writes multiple rows — with each row only containing part of the data.
I already have a Code node right before the Google Sheets node, and I've manually mapped each column. But the data still splits into separate rows. (So now, I switched it back to map "automatically")
I've tried using a Merge node and also looked at autoMapInputData, but no luck yet.
What I’ve tried:
- Checked that the Code node comes right before the Sheets node
- Manually mapped all columns
- Tried reducing to one item in the Code node
- Tried using Merge By Fields with sessionId
My Goal:
I want all data from one form submission (name, email, phone, message, etc.) to go into a single row in Google Sheets.
Any help would be greatly appreciated!
2
6 comments
Google Sheets node creates multiple rows instead of one — how to combine fields into a single row?
skool.com/learn-ai
Learn and become genuinely proficient in AI to get paid for it. From the creators of the AI Automation Agency model.
Leaderboard (30-day)
1
+409
2
+368
3
+358
4
+270
5
+243
Powered by