Skip to content

Instantly share code, notes, and snippets.

View bonyaroslav's full-sized avatar

Yaroslav Bondar bonyaroslav

View GitHub Profile
@tomjaimz
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.
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');
}