3 ms·
You can configure Google Calendar to expose ICS-formatted HTTP endpoint, then use any of the ICS format parsers for your favourite language to parse them, clean
by p_l 5y ago
You can configure Google Calendar to expose ICS-formatted HTTP endpoint, then use any of the ICS format parsers for your favourite language to parse them, clean up, and load into whatever database you want.
You can also use Google Apps Script to create an action that will load your Calendar data into Google Sheets spreadsheet.
- natIVeli 5y agoOh wow. Thank you. But also - a lot of that went straight over my head. I'm a music producer, so parsers and endpoints and scripts are a little beyond me. But i'm Googling this stuff now. And if there's a simpler solution that would be cool too.
- p_l 5y agoIf you can accept external solution, Zapier seems to have something - I wouldn't be surprised if others do as well. But just in case: ICS is essentially a somewhat standard format for storing calendar entries. If you ever got a calendar event as attachment in file, you probably got it in ICS file (especially common when targeting Apple devices, as ICS is supported by built-in Calendar). So a lot of calendaring etc. software can import ICS, and those that can import over web can be given link that you used to be able to generate from calendar settings in Google Calendar.