Skip to content

Instantly share code, notes, and snippets.

class SheetDB {
// Init sheet
constructor(sheetName = null) {
this.ss = SpreadsheetApp.getActiveSpreadsheet();
this.sheet = this.ss.getActiveSheet();
// change to sheet name
if (sheetName) {
this.sheet = this.ss.getSheetByName(sheetName);