A comment to Updating Google Calendars from a Google Spreadsheet, where I showed how to get events described in a Google spreadsheet into a Google Calendar wondered if the other way around is possible? … It would be great for logging hours for projects or declaring working hours 😉
Yes:-) Twenty seconds ago, this spreadsheet was empty:
A quick run of a script and I populated it from my default calendar using Google Apps script. Once again, all I did was peek through the docs and pull out the fragments I needed: Here’s the script:
So now not only can we use a spreadsheet as a database we can also use a calendar in a similar way, and if necessary, link them all together?