// Guy Assif - guyks1@gmail.com // Rony Season - ronysason@gmail.com function doGet(request){ var output = approveCurrentEvent(); Logger.log(output); return ContentService.createTextOutput(output).setMimeType(ContentService.MimeType.JSON); } function approveCurrentEvent() { const SECOND = 1; const MINUTE = 60 * SECOND; const HOUR = 60 * MINUTE; const DAY = 24 * HOUR; const WEEK = 7 * DAY; var cal = CalendarApp.getCalendarsByName("MeetingRoom")[0]; if (!cal) { return {status: 'error'}; } var calendarId = 'primary'; var start = new Date(); var end = new Date(); start.setSeconds(start.getSeconds() - 2*HOUR); end.setSeconds(end.getSeconds() + 5 * MINUTE); var items = cal.getEvents(start, end), length = items.length, response = {}; var item = items[0]; if (length && (new Date() - item.getStartTime()) > 10 * MINUTE * 1000){ var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1dd6GiUKelaD6pPb-_pCgLEpDKfXYWK7HVnhJ-oLccxE/edit"); var searchSheet = ss.getSheetByName('Sheet1'); searchSheet.appendRow([item.getId()]); } return {status: 'success'}; }