The following is to push Events from a google sheet to google calendar script:
function addEvents() {
var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lr = ss.getLastRow();
var cal = CalendarApp.getCalendarById(“c_3qjs8u1i5cu0re1coi8ageo51s@group.calendar.google.com”);var data = ss.getRange(“A2:E” + lr).getValues();
for(var i = 0;i<data.length;i++){
cal.createEvent(data[i][0], data[i][1], data[i][2], {location: data[i][3], description:data[i][4] } )
}
}
You have to make sure the sheet is in order of Event Name, Start Date, End Date, Location and Description to use this script or change the second value after data in CreateEvent.
If you don’t want the fuss of using Google App Script , you can use IFTTT which is the most amazing tool for automation.
Updated Script
function addEvents() { var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var lr = ss.getLastRow();
var data = ss.getRange(“A2:E” + lr).getValues();
for(var i = 0;i<data.length;i++){
var cal = CalendarApp.getCalendarById(“dsknjlrd19apqtbgastkc1pnpg@group.calendar.google.com”).createAllDayEvent(data[i][3], new Date(data[i][0]));
}
}
“Wow, great blog.Thanks Again. Great.” Domingo Ruttinger
Im thankful for the post.Really looking forward to read more. Want more. Kattie Dopp