Using Google Apps Script, How Can I Replace Text In A Google Sheets Template To Make A New Sheet?

I have a Google Sheet which is being populated by a Google Form. I am using Google Apps Script to add some extra functionality. Please feel free to access and modify these as need

Solution 1:

As far as I can tell, this line means some cells on the sheet were selected:

const A1 = newSheet.getActiveRange();

And script will search and replace within these cells only.

Probably you need to define the range with no reference on active range. Something like this:

const A1 = newSheet.getRange("A1:A"); // or "A1:Z", or .getDataRange()

I don't know what the range you need.

Solution 2:

From the documentation, createTextFinder(findText) only works on a Sheet class, this means you need to define a Sheet variable before replacing text:

constcopy = googleSheetTemplate.makeCopy(`${row[3]}, ${row[0]} Vehicle Order` , destinationFolder);
  const newSheet = SpreadsheetApp.openById(copy.getId()).getSheets()[0];

  newSheet.createTextFinder("{{Customer}}").replaceAllWith(row[3]);
  newSheet.createTextFinder("{{Car}}").replaceAllWith(row[1]);
  newSheet.createTextFinder("{{Color}}").replaceAllWith(row[2]);
  newSheet.createTextFinder("{{Delivery}}").replaceAllWith(row[5]);