
Google Apps: From Google Calendar to Google Spreadsheet
Convert Google Calendar schedules into rows in Spreadsheet.
Snippet options
Download: Download snippet as google-apps-from-google-calendar-to-google-spreadsheet.js.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!
function caltest3(){ //http://www.google.com/google-d-s/scripts/class_calendar.html#getEvents // The code below will retrieve events between 2 dates for the user's default calendar and // display the events the current spreadsheet var calid = "calendar id"; // Calendar ID var cal = CalendarApp.getCalendarById(calid); // Get the id of calendar that will be use var sheet = SpreadsheetApp.openByUrl("spreadsheet url"); var mainSheet = sheet.getSheetByName("sheet name");//sheet name var numRows = mainSheet.getMaxRows(); for(var row=2;row<numRows;row++) { var range = mainSheet.getRange(row, 1); var status = range.getValue(); range = mainSheet.getRange(row, 6); var id = range.getValue(); var events = cal.getEventSeriesById(id); if(status!="TBA") { var title=events.getTitle(); var desc=events.getDescription(); var loc=events.getLocation(); mainSheet.getRange(row, 2).setValue(title); mainSheet.getRange(row, 8).setValue(desc); mainSheet.getRange(row, 11).setValue(loc); } } }
Create a free my code stock.com account now.
my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!
Find out more and register nowYou can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.