INNER CODE UNIT · TypeScript

isErroneousPrompt

google-marketing-solutions/feedgen · src/app.ts:612

function isErroneousPrompt(prompt: string): boolean {
  return prompt.startsWith(CONFIG.sheets.formulaError);
}

function refreshConfigSheet() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(
    CONFIG.sheets.config.name
  );
  const prompt = getConfigSheetValue(CONFIG.userSettings.title.fullPrompt);

  if (isErroneousPrompt(prompt)) {
    MultiLogger.getInstance().log(
      'Manually refreshing Config sheet by adding and deleting a row...'
    );
    sheet?.insertRowBefore(1);
    SpreadsheetApp.flush();
    Utilities.sleep(5000);
    sheet?.deleteRow(1);

View source record →