Function formatReport

EndtoEndAutomatedDecks.js:116–165

()

}

function formatReport() {
  auth();
  var input = pullVariables()
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var aggSheet = ss.getSheetByName('Category');
  var aggSheet2 = ss.getSheetByName('Vendor');
  var reportSheet = ss.getSheetByName('Output') || ss.insertSheet('Output');
  reportSheet.clear();

  var aggData = aggSheet.getDataRange().getValues(); // Pivot Data
  var aggData2 = aggSheet2.getDataRange().getValues(); // Pivot Data

  cache = CacheService.getUserCache();
  token = cache.get("token");
  if (token == "") return "ERROR";
  Logger.log(`Token = ${token}`);
  url = `https://us-central1-aiplatform.googleapis.com/v1/projects/${project}/locations/us-central1/publishers/google/models/gemini-1.5-pro:generateContent`  
  data = {
    contents: {
      role: "USER",
      parts: { "text": `${input.var7}` + ' Only reffer to the data provided do not make anything up. This is the Aggregated data:'+ aggData2 + '---- This is the Full Data:' + aggData}
    },  
    generation_config: {
      temperature: 0.3,
      topP: 1,
      maxOutputTokens: 1000        
    }
  }
  const options = {
    method: "post",
    contentType: 'application/json',   
    headers: {
     Authorization: `Bearer ${token}`,
    },
    payload: JSON.stringify(data)
  };

  const response = UrlFetchApp.fetch(url, options);
  if (response.getResponseCode() == 200) {
    json = JSON.parse(response.getContentText());
    answer = json.candidates[0].content.parts[0].text;
    Logger.log(answer);
    var commentary = reportSheet.getRange("J3");
    commentary.setValue(answer);
    commentary.setWrap(true);
  }
  else{
  Logger.log("ERROR");
  }
}

function onOpen() {
  var ui = SpreadsheetApp.getUi();