1. Create a new **Google Sheet**.
2. Go to **Extensions** -> **Apps Script**.
3. Delete any existing code and paste the script below.
4. Click **Deploy** (top right) -> **New deployment**.
5. Select type: **Web app**.
6. Configure:
   • Execute as: **Me**
   • Who has access: **Anyone** (Required for browser reads/writes)
7. Click **Deploy**, authorize permissions, and copy the **Web app URL**.
8. Paste the URL into the input field above and click **Save**.

Copy this Apps Script Code:

// Handles Reading logs (GET)
function doGet(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var rows = sheet.getDataRange().getValues();
    if (rows.length <= 1) {
      return ContentService.createTextOutput(JSON.stringify([]))
        .setMimeType(ContentService.MimeType.JSON);
    }
    var logList = [];
    for (var i = 1; i < rows.length; i++) {
      var row = rows[i];
      logList.push({
        date: row[0],
        to: row[1],
        subject: row[2],
        status: row[3],
        id: row[4],
        error: row[5] || "",
        body: row[6] || ""  // Added 7th column read (Email Body)
      });
    }
    logList.reverse(); // Newest first
    return ContentService.createTextOutput(JSON.stringify(logList))
      .setMimeType(ContentService.MimeType.JSON);
  } catch (error) {
    return ContentService.createTextOutput(JSON.stringify({ success: false, error: error.message }))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

// Handles Writing logs (POST)
function doPost(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var data = JSON.parse(e.postData.contents);
    if (sheet.getLastRow() === 0) {
      sheet.appendRow(["Timestamp", "Recipient (To)", "Subject", "Status", "Resend ID", "Error Detail", "Email Body"]);
    }
    sheet.appendRow([
      new Date().toLocaleString(),
      data.to,
      data.subject,
      data.status,
      data.id,
      data.error || "",
      data.body || ""  // Added 7th column write (Email Body)
    ]);
    return ContentService.createTextOutput(JSON.stringify({ success: true }))
      .setMimeType(ContentService.MimeType.JSON);
  } catch (error) {
    return ContentService.createTextOutput(JSON.stringify({ success: false, error: error.message }))
      .setMimeType(ContentService.MimeType.JSON);
  }
}