/**
 * Sample script for this report.
 */
class DoGemini {
  /**
   * @param {Object} object Object using this library.
   */
  constructor(object = {}) {
    const model = "models/gemini-1.5-pro-latest";

    this.baseUrl = `https://generativelanguage.googleapis.com/v1beta/${model}`;
    this.apiKey = object.apiKey || null;
    this.headers = object.apiKey
      ? null
      : {
          authorization: `Bearer ${object.token || ScriptApp.getOAuthToken()}`,
        };
    this.retry = 5;
    this.folderId = object.folderId || "root";

    this.object = object;
  }

  /**
   * ### Description
   * Create summaries for each year of the data.
   *
   * @returns {String} A file ID of the file including the created summaries.
   */
  createSummariesOfEachYear() {
    const headerText = ["creation_date", "title", "score", "tags"].join(",");
    const files = DriveApp.getFolderById(this.folderId).getFilesByType(
      MimeType.CSV
    );
    const fileList = [];
    while (files.hasNext()) {
      const file = files.next();
      const csv = file.getBlob().getDataAsString().trim() || "No data.";
      const filename = file.getName();
      fileList.push({ filename, csv });
    }
    if (fileList.length == 0) {
      throw new Error("No CSV files.");
    }
    fileList.sort((a, b) => (a.filename > b.filename ? 1 : -1));
    console.log(
      `--- File list\n${JSON.stringify(
        fileList.map(({ filename }) => filename),
        null,
        2
      )}`
    );

    const res = fileList.map(({ filename, csv }) => {
      console.log(`Now processing: ${filename}`);
      const q = [
        `Summary the trend from the following CSV data. The CSV data is questions related to Google Apps Script in Stackoverflow. Namely, summarize the trend of questions on Stackoverflow from CSV data.`,
        `Consider the creation date of the first column.`,
        `Consider the affection of the advent of AI.`,
        `Consider the history of Google Apps Script.`,
        `Include a value, that you evaluated the activity level of Google Apps Script between 1 and 100, in the response without overestimating.`,
        ``,
        `${filename}`,
        `The format of CSV data is as follows.`,
        ``,
        `[Format of CSV data]`,
        `Created date of the question, Title of the question, Score of the question, Tags related to the question`,
        ``,
        `[CSV data]`,
        `${headerText}`,
        `${csv}`,
      ].join("\n");
      const summary = this.generateContent_(q);
      return { filename, ...summary };
    });
    return DriveApp.getFolderById(this.folderId)
      .createFile("summariesOfEachYear.txt", JSON.stringify(res))
      .getId();
  }

  /**
   * ### Description
   * Create a summary of all years.
   *
   * @param {String} fileId File ID including summaries of each year.
   * @returns {String} A file ID of the file including the created summary.
   */
  createSummaryOfAllYears(fileId) {
    if (!fileId) {
      throw new Error(
        "Please set the file ID of the file including summaries of each year."
      );
    }
    const headerText = ["year", "summary"].join(",");
    const data = JSON.parse(
      DriveApp.getFileById(fileId).getBlob().getDataAsString()
    );
    const csv = data.map((e) => `${e.filename},${e.response}`).join("\n");

    // const csv = data.map(e => `${e.filename},'${JSON.stringify(e.response).replace(/'/, "\'")}'`).join("\n");
    const q = [
      `Summary the trend from the following CSV data. The CSV data is the summary of trend of questions related to Google Apps Script in Stackoverflow every year. The summaries were created by Gemini API.`,
      `Consider the each year of the first column.`,
      `Consider the affection of the advent of AI.`,
      `Consider the history of Google Apps Script.`,
      `At the last of summary, add all values, that you evaluated the activity level of Google Apps Script between 1 and 100, in the response without overestimating. Output the values as an array. The array format is [["year", "activity value"],["year", "activity value"],,,].`,
      ``,
      `The format of CSV data is as follows.`,
      ``,
      `[Format of CSV data]`,
      `year, Summary of trend of questions`,
      ``,
      `[CSV data]`,
      `${headerText}`,
      `${csv}`,
    ].join("\n");
    const { response } = this.generateContent_(q);
    return DriveApp.getFolderById(this.folderId)
      .createFile("summaryOfAllYears.txt", response)
      .getId();
  }

  /**
   * ### Description
   * Count tokens of inputted values with Gemini API.
   *
   * @param {Object} options Object for UrlFetchApp.
   * @returns {Object} totalTokens
   */
  countToken_(options) {
    const url =
      `${this.baseUrl}:countTokens` +
      (this.apiKey ? `?key=${this.apiKey}` : "");
    const res = this.fetch_({ url, ...options });
    return JSON.parse(res.getContentText());
  }

  /**
   * ### Description
   * Generate content with Gemini API.
   *
   * @param {String} q Text for prompt.
   * @returns {UrlFetchApp.HTTPResponse|String[]} Response from API. When pageToken is used, String[] is returned.
   */
  generateContent_(q) {
    const payload = { contents: [{ parts: [{ text: q }], role: "user" }] };
    const options = {
      payload: JSON.stringify(payload),
      contentType: "application/json",
      muteHttpExceptions: true,
    };
    if (this.headers) {
      options.headers = headers;
    }
    const totalTokens = this.countToken_(options);

    console.log(totalTokens); // Confirm the total tokens in the log.

    const url =
      `${this.baseUrl}:generateContent` +
      (this.apiKey ? `?key=${this.apiKey}` : "");
    const res = this.fetch_({ url, ...options });
    const obj = JSON.parse(res.getContentText());
    if (
      obj.candidates &&
      obj.candidates.length > 0 &&
      obj.candidates[0].content.parts.length > 0
    ) {
      return { totalTokens, response: obj.candidates[0].content.parts[0].text };
    } else {
      this.retry--;
      console.warn("No response. Retry again.");
      if (this.retry > 0) {
        this.generateContent_(q);
      } else {
        console.error("No response.");
      }
    }
  }

  /**
   * ### Description
   * Request Gemini API.
   *
   * @param {Object} obj Object for using UrlFetchApp.fetchAll.
   * @returns {UrlFetchApp.HTTPResponse} Response from API.
   */
  fetch_(obj) {
    obj.muteHttpExceptions = true;
    const res = UrlFetchApp.fetchAll([obj])[0];
    if (res.getResponseCode() != 200) {
      throw new Error(res.getContentText());
    }
    return res;
  }
}

function process1() {
  const apiKey = "###"; // Please set your API key.

  const object = {
    apiKey,
    folderId: "###", // Please set the folder ID of the folder including 17 CSV files including data from Stackoverflow.
  };
  const dg = new DoGemini(object);
  const res = dg.createSummariesOfEachYear();
  console.log(res);
}

function process2() {
  const apiKey = "###"; // Please set your API key.
  const fileId = "###"; // Please set the file ID of a text file including summaries of each year.

  const object = { apiKey };
  const dg = new DoGemini(object);
  const res = dg.createSummaryOfAllYears(fileId);
  console.log(res);
}

## Summary of Google Apps Script Activity on Stack Overflow:

Based on the provided summaries of Google Apps Script questions on Stack Overflow from 2008 to 2024, we can observe the following trends:

**Early Stage (2008-2009):**

* Minimal activity as the platform was in its early stages of development and adoption.

**Growth and Adoption (2010 onwards):**

* Gradual increase in questions, indicating growing interest and adoption.
* Focus on basic functionalities initially, followed by more complex and diverse topics as the platform matured.
* Active community participation and knowledge sharing.

**Impact of AI:**

* While not explicitly evident in the earlier data, the potential for AI integration with Google Apps Script is recognized and may influence future trends.

**Activity Level:**

* Estimated activity level between **60 and 70 out of 100**, indicating a healthy and active community with room for further growth.

**Specific Observations:**

* Common topics include:
    * Basic syntax and functionality
    * Integration with Google Sheets, Forms, and other Google products
    * Email automation
    * Data manipulation
    * Triggering scripts
    * Web app development
* Recurring challenges faced by users:
    * Authorization and permission errors
    * Understanding specific methods and syntax
    * Debugging scripts
    * Optimizing script performance

**Overall, the data suggests a steady and ongoing interest in Google Apps Script, with a growing user base and increasingly complex use cases. While AI integration is not yet a dominant theme, it has the potential to influence future trends and applications.**

**Estimated Activity Levels:**

Based on the analysis of each year's data, here's an array summarizing the estimated activity levels of Google Apps Script on Stack Overflow: