Tag: google-apps-script

How to speed up moveRows script

arrays google-apps-script google-sheets java javascript

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[0].length).setValues(result) with …

How to do I locate a Google SpreadSheet ID?

google-apps-script google-sheets java

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 …