Here are my favorite 30 Google Apps Script snippets. These snippets will save your time. SpreadsheetApp Access to Spreadsheet ( standalone scripts ) const spreadsheet = SpreadsheetApp.openById("Spreadsheet ID") Spreadsheet ID can be obtained from the spreadsheet URL https://docs.google.com/spreadsheets/d/[ Spreadsheet ID ]/edit Access to Spreadsheet ( Container-bound scripts ) const spreadsheet = SpreadsheetApp.getActive()