This class provides direct access to the user's default calendar, as well as the ability to retrieve additional calendars that the user owns or is subscribed to. (line 53) (i'm translating from italian) and in the doget: argument not valid: id (line 27) Browse other questions tagged google-sheets google-apps-script google-sheets-timestamp or ask your own question. I get some errors: in the setup function(2nd time run): TypeError: unable to call "getId" of null. Search the world's information, including webpages, images, videos and more. google-apps-script. Google has many special features to help you find exactly what you're looking for. Add Reminders will process the sheet and for each row, the reminders will be sent on the date mentioned according to the settings made. Getting started with google-apps-script; Apps Script Web Apps; Client calls to Google apps-script; Create a custom function for Google Sheets; DriveApp; Add a folder to the root drive; Create a new file in Google drive from a blob; Create a new folder in a Google Drive root; Create a new text file and add it to the root folder Class CalendarApp: Allows a script to read and update the user's Google Calendar. Step 1: In the Google Sheet, start the add-on from the menu bar Add-ons > Add Reminders > Set up / edit reminders . Querying the data through Google Apps Script is a way to simulate Query Explorer data and personally I always have the Query Explorer open in a tab to validate the queries. The Overflow Blog The Overflow #25: New tools for new times