setVarToTab()

in src/connectors/sheets-connector.js [442:457]


  setVarToTab(tabId, key, value) {
    let tabConfig = this.tabs[tabId];
    let sheet = this.getSheet(tabId);
    let data = sheet.getDataRange().getValues();
    let propertyLookup = this.getPropertyLookup(tabId);

    let i = 1;
    propertyLookup.forEach(property => {
      if (property === key) {
        let range = sheet.getRange(
          tabConfig.skipRows + i, tabConfig.skipColumns + 1);
        range.setValue(value);
      }
      i++;
    });
  }