RichTextApp 이용하여 구글 시트 셀 내의 특정 문자 색 바꾸기

function ReplaceTextToRichText() {
  const ss = SpreadsheetApp.openById("1jt84gI9KLHchUzyMxT1g9CXGNLh4csjb5M77w9-JHvQ");
  const sheet = ss.getSheetByName("시트2");


  const range2 = sheet.getRange("E2:E");

  const texts2 = sheet.getRange("G2:G").getValues().flat();
  var count = 0;
  for(i=0;i<texts2.length ;i++){
    if(texts2[i] == ""){
      count = i;
      break;
    }
    
  }

  const texts =texts2.slice(0,count);

  Logger.log(texts)

  const textStyle2 = SpreadsheetApp.newTextStyle()
    .setItalic(true)
    .setBold(true)
    .setForegroundColor("green")
    .build();

  const object = {
    replaceTextToRichText: 
      // { range: range1, texts: texts1, textStyle: textStyle1 },
    [  { range: range2, texts: texts, textStyle: textStyle2 }]
    
  };
  const res = RichTextApp.ReplaceTextToRichText(object);

  console.log(res);


}