Create Google Calendar reminders using the Google Script app

Question

I'm having trouble finding how to create a Google Calendar reminder through Google Script. I'm not talking about an event reminder, as in a reminder sent by email or SMS to you before the event on your calendar. I need to create reminders on a Google calendar. These reminders are depicted with a finger and a string with a bow. Does anyone know a Calendar Service class to use? I guess the reminders will be on the Calendar Service, but for some reason I can't find it.

Here is a link to reminders. I’m talking about them; they are different from event reminders that you can add to an event.

Answer 1

Maybe this will help you:

You need a data entry sheet, and this script will create an event in your calendar called AA:

function create_calendar() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); var index = 2; var lastRow = sheet.getLastRow(); for (;index <= lastRow; index++){ var type = sheet.getRange(index, 1, 1, 1).getValue(); var taskTitle = sheet.getRange(index, 2, 1, 1).getValue(); var taskDesc = sheet.getRange(index, 3, 1, 1).getValue(); var onCalendar = sheet.getRange(index, 4, 1, 1).getValue(); var originalEstimate = sheet.getRange(index, 5, 1, 1).getValue(); var loggedEffort = sheet.getRange(index, 6, 1, 1).getValue(); var startDate = sheet.getRange(index, 7, 1, 1).getValue(); var endDate = sheet.getRange(index, 8, 1, 1).getValue(); var status = sheet.getRange(index, 9, 1, 1).getValue(); if (onCalendar == 'Yes' && startDate && endDate && status != 'Done') { var events = CalendarApp.getCalendarsByName("AA")[0].getEvents(startDate, endDate); delete_events(events); var calendar = CalendarApp.getCalendarsByName("AA")[0].createEvent(taskTitle, startDate,endDate,{description: taskDesc}); } } }