Untitled

function insertImages() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var startRow = 5;  // Change this to the row where you want to start inserting images (e.g., row 5)
  var urlColumn = 1; // Change this to the column where the image URLs are
  
  var imageUrls = [
    "https://palia.wiki.gg/images/2/28/Bahari_Bee.png",
    "https://palia.wiki.gg/images/2/28/Bahari_Bee.png",
    "https://palia.wiki.gg/images/2/28/Bahari_Bee.png",
    "https://palia.wiki.gg/images/2/28/Bahari_Bee.png",
    "https://palia.wiki.gg/images/2/28/Bahari_Bee.png"
  ];

  for (var i = 0; i < imageUrls.length; i++) {
    var imageUrl = imageUrls[i];
    
    if (imageUrl) {
      var formula = '=IMAGE("' + imageUrl + '")';
      sheet.getRange(startRow + i, 16).setFormula(formula); // Column P is the 16th column
    }
  }
}