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
}
}
}