Excel Office Scripts with Meridian

async function main(workbook: ExcelScript.Workbook) {
  const sheet = workbook.getActiveWorksheet();
  const range = sheet.getUsedRange();
  const rows = range.getValues();

  const prompt = rows
    .map((row) => row.join("\t"))
    .join("\n");

  const response = await fetch(
    "https://api.meridian.sh/v1/chat/completions",
    {
      method: "POST",
      headers: {
        "Content-Type": "application/json",
        "Authorization": "Bearer YOUR_API_KEY",
      },
      body: JSON.stringify({
        model: "meridian-4",
        messages: [
          {
            role: "system",
            content: "You are a data analyst. Return clean CSV.",
          },
          {
            role: "user",
            content: `Analyze this spreadsheet data:\n\n${prompt}`,
          },
        ],
        temperature: 0.3,
      }),
    }
  );

  const json = await response.json();
  const result = json.choices[0].message.content;

  const outputSheet = workbook.addWorksheet();
  outputSheet.getRange("A1").setValue(result);
}