Writing Multiple Rows in Google Sheet

Describe the issue/error/question

I want to write multiple Row in Google Sheet after I parsed all the Data

Please share the workflow

Share the output returned by the last node

[

[

{

"SKU": "Novalac - Allernova Infant Formula For Milk Protein Allergy Cases 400g",

"Price": "122.33",

"Currency": "AED"

},

{

"SKU": "Novalac - IT3 Growing Up Formula For Constipation 800g",

"Price": "96.39",

"Currency": "AED"

},

{

"SKU": "Novalac - Genio Growing Up Formula 800g",

"Price": "69.93",

"Currency": "AED"

},

{

"SKU": "Novalac - IT1 Infant Formula For Constipation 400g",

"Price": "50.72",

"Currency": "AED"

}

]

]

What is written in the Google Sheet is the following

My Question is what’s the best way to write the extracted rows in the Google Sheet. Since I can’t set variable in (SET Node) to loop over all iterations.

Information on your n8n setup

  • n8n Version : 0.182.0
  • Running on Windows app and Docker for testing both

Hi @MXA_Music, is the output you have shared from your Set node? If so, the problem might simply be that you don’t have enough rows in your sheet.

Can you try adding sufficient rows to your sheet and then switching from the Delete to the Clear operation on your first Google Sheets node? This way, your rows will remain available rather than being deleted and you should be able to write data into them.