【GAS】スプレッドシートに入力したキーワードで検索してヒットした画像をGoogleドライブに保存する

1
/**
2
 * @description Check whether the element is an empty value.
3
 * @param {any} element
4
 * @return {boolean}
5
*/
6
function checkEmpty(element) {
7
  return element !== undefined && element !== 0 && element !== null && element !== "";
8
}
9

10
/**
11
 * @description Check whether empty element is existing.
12
 * @param {any[]} array
13
 * @return {boolean}
14
*/
15
function isEmptyExisting(array) {
16
  let empties = array.filter(element => !checkEmpty(element));
17
  if(empties.length > 0){
18
    return true;
19
  }
20
  return false;
21
}
22

23
/**
24
 * @description Search by keywords specified in the sheet and save into the Google Drive.
25
 * @param {boolean} isRecording
26
 * @return {boolean}
27
*/
28
function searchToSaveImageToDrive(isRecording=true) {
29
  const folderIdToSaveLogoBySearching = FOLDER_ID_TO_SAVE_LOGO_BY_SEARCHING;
30
  const sheetName = SHEET_NAME_6TH;
31
  const startRow = ROW_INDEX_5TH_TO_START_OUTPUTING_RECORDS;
32
  const startColumn = COLUMN_INDEX_5TH_OF_FILE_LIST_TO_SAVE_IMAGE_BY_SEARCH;
33

34
  console.log(`searchToSaveImageToDrive: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa`);
35
  let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
36
  let records = sheet.getRange(startRow, startColumn, sheet.getLastRow() - startRow + 1, 2).getValues();
37
  records = records.filter(values => !isEmptyExisting(values));
38
  console.log(records);
39
  console.log(`searchToSaveImageToDrive: cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc`);
40

41
  let gottenBlobs = records.map(rec => {
42
    return searchByKeywordToGetImages(rec[0], rec[1]);
43
  });
44
  console.log(gottenBlobs);
45
  console.log(`searchToSaveImageToDrive: dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd`);
46

47
  let saveImageFiles = gottenBlobs.map(blobInfo => {
48
    return createImageFilesFromBlobs(blobInfo, folderIdToSaveLogoBySearching);
49
  });
50
  saveImageFiles = saveImageFiles.filter(value => checkEmpty(value));
51
  console.log(saveImageFiles);
52
  console.log(`searchToSaveImageToDrive: ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg`);
53

54
  const myPromise = new Promise((resolve, reject) => {
55
    recordLog(MY_SCRIPT_NAME, "searchToSaveImageToDrive", isRecording);
56
  });
57
  console.log(`searchToSaveImageToDrive: iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii`);
58

59
  let folderUrl = `https://drive.google.com/drive/folders/${folderIdToSaveLogoBySearching}`;
60
  displayHtml("index_html", "Saving Files By Searching Terminated...", `<h2>Done.</h2><p>${saveImageFiles.length} images saved in ${getHref(folderUrl, "this folder")}.</p>`);
61
  console.log(`searchToSaveImageToDrive: kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk`);
62

63
  return true;
64
}

1
/**
2
 * @description Check whether the element is an empty value.
3
 * @param {any} element
4
 * @return {boolean}
5
*/
6
function checkEmpty(element) {
7
  return element !== undefined && element !== 0 && element !== null && element !== "";
8
}
9

10
/**
11
 * @description Check whether empty element is existing.
12
 * @param {any[]} array
13
 * @return {boolean}
14
*/
15
function isEmptyExisting(array) {
16
  let empties = array.filter(element => !checkEmpty(element));
17
  if(empties.length > 0){
18
    return true;
19
  }
20
  return false;
21
}

1
/**
2
 * @description Search by specified keyword to get blob object.
3
 * @param {string} keyword
4
 * @param {string} gettingBlobName
5
 * @return {any{}}
6
*/
7
function searchByKeywordToGetImages(keyword, gettingBlobName){
8
  const apiKey = API_KEY_TO_SEARCH_BY_CUSTOM_SEARCH_API;
9
  const searchEngineId = SEARCH_ENGINE_ID_TO_SAVE_IMAGE;
10
  let blob, extension, blobFullName;
11
  let keywordToSearch = keyword.replaceAll(" ", "+").replaceAll("　", "+");
12
  keywordToSearch = `${encodeURIComponent(keywordToSearch)}+logo`;
13
  let searchUrl = `https://www.googleapis.com/customsearch/v1?q=${keywordToSearch}&cx=${searchEngineId}&searchType=image&key=${apiKey}&num=1`;
14
  let response;
15
  try{
16
    response = UrlFetchApp.fetch(searchUrl);
17
  }catch(error){
18
    return {"blob": null, "name": null};
19
  }
20

21
  let results = JSON.parse(response.getContentText());
22
  console.log(results);
23
  console.log(`searchByKeywordToGetImages: eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee`);
24

25
  if (results.items && results.items.length > 0) {
26
    let imageUrl = results.items[0].link;
27
    let imageResponse;
28
    try{
29
      imageResponse = UrlFetchApp.fetch(imageUrl);
30
    }catch(error){
31
      return {"blob": null, "name": null};
32
    }
33
    blob = imageResponse.getBlob();
34
    console.log(blob);
35
    console.log(`searchByKeywordToGetImages: gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg`);
36

37
    // 元の画像のURLからファイルの拡張子を取得します
38
    extension = imageUrl.substring(imageUrl.lastIndexOf('.'));
39
    // 拡張子がある場合、クエリパラメーターまたは他のパスの一部を含まないようにします
40
    if (extension.indexOf('?') !== -1) {
41
      extension = extension.substring(0, extension.indexOf('?'));
42
    }
43
    // 拡張子らしき文字列が6文字以上もしくは拡張子が正しく取得できない場合は、デフォルトとして.jpgを使用
44
    if (extension.length >= 6 || extension.indexOf('/') !== -1) {
45
      extension = '.jpg';
46
    }
47
    blobFullName = `${gettingBlobName}${extension}`
48
    console.log(blobFullName);
49
    console.log(`searchByKeywordToGetImages: iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii`);
50
  } else {
51
    console.log('No images found for: ' + keywordToSearch);
52
    console.log(`searchByKeywordToGetImages: jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj`);
53
  }
54
  console.log(`searchByKeywordToGetImages: kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk`);
55

56
  return {"blob": blob, "name": blobFullName};
57
}

1
/**
2
 * @description Create image files into the Google Drive.
3
 * @param {any{}} blobInfo
4
 * @param {string} folderId
5
 * @return {DriveApp.File}
6
*/
7
function createImageFilesFromBlobs(blobInfo, folderId=FOLDER_ID_TO_SAVE_LOGO_BY_SEARCHING){
8
  let folder = DriveApp.getFolderById(folderId);
9
  console.log(`createImageFilesFromBlobs: eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee`);
10

11
  if(Object.prototype.toString.call(blobInfo["name"]) === "[object Null]"){
12
    return null;
13
  }
14

15
  let fileName = blobInfo["name"];
16
  let file = DriveApp.createFile(blobInfo["blob"].setName(fileName));
17
  file.moveTo(folder);
18
  console.log(`createImageFilesFromBlobs: iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii`);
19
  console.log('Image saved to Drive with name: ' + fileName);
20

21
  console.log(`createImageFilesFromBlobs: kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk`);
22

23
  return file;
24
}