Can't append row correctly without mapping to column names in google sheet

[harry_12]

Hello, In my workflow there it search for respective spreadsheet and append the row. but the problem is I have sequence of values I want to append in sequence of columns without mapping to column names but I can’t do it. in some of the sheet I have different names but the append is in same sequence in all spreadsheets irrespective of column name.

Q) Is there any way we can map automatically without mentioning the column names to update with.

In set row values right now I have hardcoded the header but I don’t want to use header as I have some columns differently named. I just want to leverage the sequence.

return {“Open Date”: openDate,“Invoice Date”: invoiceDate,“Description”: description,“Notes”: null,“Invoice Number”: invoiceNumber,“Cost”: cost,“Mileage”: mileage}

Please suggest what should be the correct return format to use without column names and map automatically to google sheet.

Thank you!

[Piotr_Sikora]

Hi @harry_12

Have you been trying option “Map automatically” with respective adjustments in your returned object?

[Celestius]

Hey @harry_12

I suggest using the “Map automatically” option and also hard-code the row where you want to append your raw data.

[harry_12]

@pit_potitavonun and @Celestius

I tried the Map Automatically option.

but it fails because still because it try to search exact column names I have in previous node (javascript) output in the spreadsheet header.

Anyways, I found a solution is using HTTP module rather than spreadsheet