search

davepar / gcalendarsync

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

Runs fine on my personal account, but seems to not run on business account. #13

Open ToddSchweikert opened 7 years ago

ToddSchweikert commented 7 years ago

Hey There, This script is GREAT! just what I needed. But I can only get this to work on my personal account, and not my business account. I assume that is something that needs to change internally on the business apps side?

davepar commented 7 years ago

Not sure why it wouldn't work. Is your business account managed by an administrator? Maybe they have a setting that doesn't allow running scripts. You could try this:

  1. Open the script editor (from Sheets, it's in the Tools Menu, "Script Editor").
  2. In the "Run" menu select syncToCalendar or syncFromCalendar.
  3. Use the "View" menu to open the "Execution Transcript".

See if there are any errors or warnings in that transcript.

cdagesse commented 6 years ago

same issue for me

[17-09-01 10:57:46:303 EDT] Starting execution [17-09-01 10:57:46:356 EDT] CalendarApp.getCalendarById([nucarautogroup.com_117j1pvce4435s2aq3deoidfgc@group.calendar.google.com]) [0.044 seconds] [17-09-01 10:57:46:358 EDT] SpreadsheetApp.getUi() [0.001 seconds] [17-09-01 10:57:49:924 EDT] Ui.alert([Cannot find calendar. Check instructions for set up.]) [3.566 seconds] [17-09-01 10:57:49:979 EDT] Execution failed: TypeError: Cannot call method "getEvents" of null. (line 304, file "Code") [3.614 seconds total runtime]