Mistral AI Magic In Google Sheets with Free Apps Script

var apiKey = 'XRqs0ATTneIjz477JWtMBSgPtylMZdto';
var apiUrl = 'https://api.mistral.ai/v1/chat/completions';

// ------------------------------
// Add menu and create header
// ------------------------------
function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Mistral AI')
    .addItem('Generate Answers', 'generateAnswers')
    .addToUi();
  createHeader();
}

// ------------------------------
// Create header row
// ------------------------------
function createHeader() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var headers = ["Type Mistral prompt", "Mistral Response"];
  var headerRange = sheet.getRange('A1:B1');
  headerRange.setValues([headers]);
  headerRange.setFontWeight("bold").setFontSize(14);
}

// ------------------------------
// Generate answers for active row
// ------------------------------
function generateAnswers() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var activeCell = sheet.getActiveCell();
  var row = activeCell.getRow();
  var column = activeCell.getColumn();

  if (column !== 1) {
    Logger.log('Active cell should be in column A (containing prompts)');
    return;
  }

  var promptText = activeCell.getValue();
  if (!promptText) {
    Logger.log('The selected cell is empty.');
    return;
  }

  var existingResponse = activeCell.offset(0, 1).getValue();
  if (existingResponse) {
    Logger.log('Response already exists for this prompt.');
    return;
  }

  var prompt = `Generate a response for the following question: "${promptText}"`;
  var response = getMistralAIResponse(prompt);

  if (response) {
    activeCell.offset(0, 1).setValue(response.trim());
    Logger.log('Response generated successfully.');
  } else {
    Logger.log('Failed to generate response for prompt: ' + promptText);
  }
}

// ------------------------------
// Call Mistral AI API
// ------------------------------
function getMistralAIResponse(prompt) {
  var payload = {
    model: "mistral-small-latest",
    messages: [{ role: "user", content: prompt }],
    temperature: 0.7,
    top_p: 1,
    max_tokens: 512,
    stream: false,
    safe_prompt: false,
    random_seed: 1337
  };

  var options = {
    method: 'post',
    contentType: 'application/json',
    headers: { 'Authorization': 'Bearer ' + apiKey },
    payload: JSON.stringify(payload),
    muteHttpExceptions: true
  };

  try {
    var response = UrlFetchApp.fetch(apiUrl, options);
    if (response.getResponseCode() === 200) {
      var data = JSON.parse(response.getContentText());
      return data.choices[0].message.content;
    } else {
      Logger.log('API Error: ' + response.getContentText());
      return null;
    }
  } catch (e) {
    Logger.log('Fetch Error: ' + e);
    return null;
  }
}