Error: Cannot call method "getEvents" of null


I’m trying to use the Holiday Tracking described here:

I keep getting the following error when hitting “RUN”:

Message details

TypeError: Cannot call method “getEvents” of null.

What am I doing wrong? How can I fix this?


Hi @iowasurrogate can you please share your spreadsheets with me (

I will take a look without revealing anything private.



Hi Bobby - I’ve shared the sheets with you. I’ll watch for your feedback, thanks!


@iowasurrogate don’t use https link to the calendar but instead follow the blog instructions to get the correct calendar ID and only paste the ID into the field.


Hi! Thanks for your help. I updated to the correct calendar ID, and I am no longer getting an error when running the script. But it’s also not doing what it’s supposed to. The request is not showing up in the calendar, nor is the Holiday Tracking tab populating correctly.

Any additional help you can provide would be appreciated!



You had some refs error which I fixed. Have you done any changes here manually that caused those refs errors?

Please retry now.




Those errors were there when I copied the sheet. Thanks for fixing.

Will you please advise - the features I’m using here, will I need to purchase a plan to utilize long term, or are these basic/free features?



@iowasurrogate much welcome! :slight_smile:

It’s free. :wink:



This still is not working for me. Now my data from the first spreadsheet (list of employees) is not filling into the holiday tracker spreadsheet.

The holiday tracker tab does not have information. Nor does the “SG Database.”

Hopefully I’m close to making this work?!

Thanks again for your help!


@iowasurrogate cannot confirm. Looking good to me: