I have added google sheet which has 100 columns and 100 rows. “Stock” column has integer values 0 to 100.
I want to read each row if stock value is >= 50 then cut that row from google sheet and add it into new sheet (i.e sheetA). If stock value is <= 50 then cut that row from google sheet and add it into new sheet i.e sheet B.
I don’t see any option for cut + paste for google sheet module. Any suggestions how can I implement this workflow?