vHi, since my previous attempt to solve the Google Sheets problem was unsuccessful, I've created a simple scenario that illustrates my challenge.
There is a Google sheet with sheets: DATA, X1, X2, ... Xn
- In the sheet, DATA are variables
- There is a SCRIPT node that calculates via JS simple multiplication - row by row
- Result of multiplication of variables from each row has to be appended by the last node into a different sheet accordingly to X1, X2, to Xn
Simple?
When the scenario was executed, all the results were appended into sheet X1.
Could you help me solve my puzzle ?