function createEventFromSheet2() { var sheet, i, myevent, mystart, myend, mylocation, added; sheet = SpreadsheetApp.getActiveSheet(); for(i = 2; i <= sheet.getLastRow(); i++) { myevent = sheet.getRange(i, 1) .getValue(); mystart = sheet.getRange(i, 2) .getValue(); myend = sheet.getRange(i, 3) .getValue(); mylocation = sheet.getRange(i, 4) .getValue(); added = sheet.getRange(i, 5).getValue(); if(ad
![GoogleスプレッドシートからGoogleカレンダーにインポート(重複防止)](https://cdn-ak-scissors.b.st-hatena.com/image/square/0b49227a52a7cb8e860969f6f5b28ef13ef62f42/height=288;version=1;width=512/https%3A%2F%2Fstabucky.com%2Fwp%2Fwp-content%2Fuploads%2F2021%2F01%2Fgoogleappsscript_logo.png)