search

davepar / gcalendarsync

Apps Script for syncing a Google Spreadsheet with Google Calendar
MIT License
161 stars 46 forks source link

calendar id in cell #43

Open tgoldenlion opened 6 years ago

tgoldenlion commented 6 years ago

if i want a variable calendar id, and not having to open the script everytime to change it, can i recode the calendarid = to match a specific cell?

tgoldenlion commented 6 years ago

i have unsuccessfully tried:

var calendarId = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Info").getRange("D2").getCell(1, 1).getValue(); Logger.log("Calendar id: %s", calendarId);