https://www.pbainbridge.co.uk/2025/03/replace-text-in-google-sheet-with-image.html

Replace text in a Google Sheet with an image.gs

function replaceTextToImage() {



  // ******************** COMPLETE THESE ITEMS ********************
  var searchText = "";

  var imageURL = "";

  var rowHeight = 100;

  var columnWidth = 100;
  // ******************** COMPLETE THESE ITEMS ********************



  // get spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // get Data sheet
  var dataSheet = ss.getSheetByName('Data');

  // build image
  var image = SpreadsheetApp
    .newCellImage()
    .setSourceUrl(imageURL)
    .build();


  // create TextFinder process to get all Ranges that need changing
  var textFinder = dataSheet.createTextFinder(searchText).findAll();


  // loop through each TextFinder item *****************************
  textFinder.forEach(function getCell(word) {

    // use TextFinder to get Row & Column numbers
    var row = word.getRow();
    var col = word.getColumn();

    // get relevant cell via Range
    var cell = dataSheet.getRange(row, col);

    // insert image
    cell.setValue(image);


    // OPTIONAL: change cell size
    dataSheet.setRowHeight(row, rowHeight);
    dataSheet.setColumnWidth(col, columnWidth);

    // OPTIONAL: centre image
    cell.setVerticalAlignment("middle");
    cell.setHorizontalAlignment("center");


  });
  // loop through each TextFinder item *****************************


};