Find File in google drive and update file url from gdrive to Google Sheet with preview.

GoogleAppScript.js

function testImageFile(){
  SearchFileInSpecificFolderID('o112');
}

function readMySheet(){
  
   var sheet = SpreadsheetApp.getActiveSheet();
   var data = sheet.getDataRange().getValues();
   for (var i = 1; i < data.length; i++) {
    Logger.log('Product name: ' + data[i][0] + "O"+(i+1));
    //Logger.log('Product number: ' + data[i][1]);
//    Logger.log('Shop: ' + data[i][2] + "ImageName "+ data[i][9]); 
     var fileName = data[i][9];
     var imagePath = SearchFileInSpecificFolderID(fileName);
     //=IMAGE("https://drive.google.com/uc?export=view&id=1homcetgLyyvfE-v8CoVtR-B7rAP_XS1v")
     if(imagePath == '' || imagePath == null || imagePath == undefined || fileName == ''){
       var cell = sheet.getRange("O"+(i+1));
       cell.setValue("Not Found By Vijaysinh");
     }else{
       //Logger.log('fileName: ' + fileName + "imagePath "+ imagePath);
       
       var cell = sheet.getRange("O"+(i+1));
       cell.setValue(imagePath[0]);
       
       var ImageCell = sheet.getRange("P"+(i+1));
       ImageCell.setValue('=IMAGE("https://drive.google.com/uc?export=view&id='+imagePath[1]+'")');
     }
   }
 
  
}

function SearchFileInSpecificFolderID(fileName){
  var results = [];
  var folders = DriveApp.getFolders();
  var FolderId = '1JcLdeY3fSUhTqmzFAwzUfycj5J-V67rA';
  var parentFolder = DriveApp.getFolderById(FolderId);
  var childFolders = parentFolder.getFolders();
  
  while (childFolders.hasNext()) {
    var folder = childFolders.next();
    //Logger.log(folder.getName());
    var contents = folder.getFiles();
    
    while (contents.hasNext()) {
      
      var file = contents.next();
      results.push(file.getName());
      Logger.log(results);
      if(file.getName().includes(fileName)){
         //Logger.log([file.getName(), file.getUrl()].join());
         
         return [file.getUrl(),file.getId()];
      }
    }

  }
  
  
}