Yaroslav Bondar bonyaroslav
tomjaimz
/ ICS Import.gs
Last active
June 4, 2024 10:23
Google App Script code to import events from a Calendar (.ics) file into Google Sheets.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() { | |
| SpreadsheetApp.getUi().createAddonMenu().addItem('Upload', 'upload').addToUi(); | |
| } | |
| function upload() { | |
| SpreadsheetApp.getUi().showModalDialog(HtmlService.createHtmlOutput( | |
| '<form><input type="file" name="file" onchange="var reader = new FileReader(); reader.onloadend = (e) => google.script.run.withSuccessHandler(google.script.host.close).importICS(e.target.result); reader.readAsText(this.parentNode.file.files[0]);"></form>' | |
| ), 'Select .ics file'); | |
| } |