function doGet(){ //Logger.log(ContentService.createTextOutput(GetEvents())); return ContentService.createTextOutput(GetEvents()); } function GetEvents(){ var Cal = CalendarApp.getCalendarsByName('Rubbish')[0]; var Now = new Date(); var Tomorrow = new Date(); var Later = new Date(); Tomorrow.setDate(Tomorrow.getDate()+1); Tomorrow.setHours(0); Tomorrow.setMinutes(1); Later.setDate(Later.getDate()+1); Later.setHours(0); Later.setMinutes(2); currentTime=Utilities.formatDate(Now, 'Europe/Berlin', 'HH:mm') Logger.log(Now); Logger.log(Tomorrow); Logger.log(Later); var events = Cal.getEvents(Tomorrow, Later); //Logger.log(events.length); str = currentTime+"_" ; for (var i = 0; i < events.length; i++){ var event_title=""; event_title=events[i].getTitle().toLowerCase().toString(); if (event_title.includes("rest")) str+= "RubbishBin_"; else if (event_title.includes("bio")) str+= "GreenBin_"; else if (event_title.includes("gelber")) str+= "YellowBag_"; else if (event_title.includes("papier")) str+= "PaperBin_"; else str += event_title + '_' ; //str += '\n'; } str = str.substring(0, str.length - 1); //Logger.log(str); return str; }