Help with Google Sheets Append Issue in Workflow

Questions
, ,
1

I’m facing an issue where my n8n workflow processes 10 MCQs but only appends 1 row to Google Sheets.

Describe the problem/error/question

Hello n8n Community,

I’m building a workflow to parse multiple-choice questions (MCQs) from a Google Doc, process them with OpenAI, and append the results to a Google Sheets document. The workflow successfully parses 10 MCQs (verified in the execution output), but only 1 row is added to the sheet despite the Google Sheets node receiving all 10 items.

Workflow Details:

  • Nodes Used: Google Docs (Get), Code (Parse MCQs), Split In Batches, OpenAI (Generate Answers), Set, Merge, Google Sheets (Append).

  • Issue: The Google Sheets node’s output shows 10 items processed, but the sheet only reflects 1 new row.

  • Input to Google Sheets: Each item contains fields like quizNo, subject, question, optionA, optionB, optionC, optionD, correctAnswer, etc.

  • Config: Append operation, manual column mapping, “Use Append Endpoint” enabled.

Troubleshooting Tried:

  • Verified input data structure (10 separate JSON objects).

  • Checked column mappings (match sheet headers).

  • Ensured Google credentials have full Sheets access.

  • Tested with a new blank sheet (same result).

Possible Causes Considered:

  • Nested data structure causing single-row write.

  • Mapping or API endpoint misconfiguration.

  • Overwriting in loop despite Merge node.

I’d appreciate any insights or suggestions to fix this. Could it be a batching issue or a need to adjust the Google Sheets node settings? Screenshots or workflow JSON can be shared if needed. Thanks for your help!