function insertImageDebugTest(){
const ss = SpreadsheetApp.getActiveSpreadsheet();
const summarySheet = ss.getSheetByName('forDebug');
const fileId = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"; // Google Drive のファイルIDを指定
try {
const file = DriveApp.getFileById(fileId);
Logger.log("File found: " + file.getName());
const blob = file.getBlob();
Logger.log("MIME Type: " + blob.getContentType());
Logger.log("Blob size: " + blob.getBytes().length);
// 画像が取得できているか確認
if (blob.getBytes().length === 0) {
throw new Error("Blob is empty. The file might be corrupted or not accessible.");
}
summarySheet.insertImage(blob, 1, 1).setWidth(323).setHeight(140);
Logger.log("Image inserted successfully");
} catch (e) {
Logger.log("Error: " + e.message);
}
}