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()Get values
const values = spreadsheet
.getSheetByName('sheet name')
.getDataRange()
.getValues()Set values
spreadsheet
.getRange(range)
.setValues(values)Add custom menu
const onOpen…
