Filter google sheets based on lookup value

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?

there is a module in sheet to Delete a row , it will delete the row from sheet
add a module add a row , this will add a row to your diff sheet where you want it ,

you can use search sheet module and then use router for >= 50 , add row , delete row
other side will be < 50 , addd row delete a row ,

thank you

2 Likes