$ npm i -g google-apps-script
$ gas new myProject && cd myProject
$ gas i -s sheet
$ gas push

var MySpreadSheet = SpreadsheetApp.openById('my-spreadsheet-id-goes-here');
var Sheet1 = MySpreadSheet.getSheets()[0];

sheet_getValue(row, column, sheet);

sheet_setValue(row, column, sheet, value);

sheet_setBackgroundColor(row, column, sheet, backgroundcolor);

sheet_setFontColor(row, column, sheet, fontcolor);