[ad_1] Moving sheets/tabs of a color to end of list of tabs using Google Sheets API version 4 function moveSheetsOfAColorToEnd(color) { var color=color || ‘#ff0000’; if(color) { var ss=SpreadsheetApp.getActive(); var shts=ss.getSheets(); for(var i=0;i<shts.length;i++) { if(shts[i].getTabColor()==color) { Sheets.Spreadsheets.batchUpdate( { requests:[ { “updateSheetProperties”: { “properties”: { “sheetId”:shts[i].getSheetId(), “index”: shts.length }, “fields”: “index” } } ] }, ss.getId()); … Read more