Error: Cannot call method "getEvents" of null



Yes - like that, but the template I’m having doesn’t have that. Obviously I could add the column, but I don’t know how to code it so that it populates the other sheet…


@iowasurrogate do the following:

  1. Add the column as shown in the screenshot
  2. Adjust your query and add the column (see below)
  3. Run your connection and let me know if the column is now shown on your main holiday tracking spreadsheet