I use a script how move rows in other sheet and delete them if condition match. It works but sometimes it’s long. How can i speed up this please ? I try this but it’s not working. I think i can’t combine sh1.getRange(sh1.getLastRow()+1, 1,vals.lenght , vals.length).setValues(result) with sh0.deleteRows(i+1) or the problem is for (var i=vals.lenght-1;i>0;i–) ?? Answer I believe your
How to do I locate a Google SpreadSheet ID?
https://developers.google.com/apps-script/guides/rest/api#parameter_and_return_types When using the Google Execution Api for Java, the ID of the spreadsheet isn’t very easy to understand. Here is the …