SentinelCam_CloudBridge_AppsScript.js

// ============================================================
//  SentinelCam CloudBridge — Google Apps Script Backend
//  Project : SentinelCam-ESP32
//  Version : 1.1
//
//  Purpose:
//  Receives motion-triggered JPEG images from ESP32-CAM,
//  saves them to Google Drive, and sends Pushover alerts.
//
//  Deploy:
//  Google Apps Script → Deploy as Web App
//  Execute as : Me
//  Access     : Anyone
//
// ============================================================


// ============================================================
//  CONFIGURATION — Replace these values in your PRIVATE copy
// ============================================================

const DRIVE_FOLDER_ID    = "YOUR_GOOGLE_DRIVE_FOLDER_ID";  // Google Drive folder ID
const PUSHOVER_USER_KEY  = "YOUR_PUSHOVER_USER_KEY";       // Pushover user key
const PUSHOVER_APP_TOKEN = "YOUR_PUSHOVER_APP_TOKEN";      // Pushover application token
const DEVICE_SECRET      = "YOUR_CUSTOM_SECRET_KEY";       // Must match Arduino DEVICE_SECRET

// Pushover priority:
// -2 = silent, -1 = low, 0 = normal, 1 = high, 2 = emergency
const PUSHOVER_PRIORITY  = 0;

// Pushover sound examples:
// "pushover", "siren", "spacealarm", "alien", "persistent", "echo", "none"
const PUSHOVER_SOUND     = "pushover";

// Send notification as soon as first image is saved.
// true  = faster alert
// false = alert after all images are uploaded
const NOTIFY_ON_FIRST_IMAGE = true;

// Share saved event folder/files as "Anyone with the link".
// This makes the Drive link easier to open from Pushover.
// If you want stricter privacy, set this to false.
const ENABLE_LINK_SHARING = true;


// ============================================================
//  doGet — Browser health check
//  Open the Web App URL in browser to confirm deployment.
// ============================================================

function doGet(e) {
  return jsonResponse({
    success: true,
    service: "SentinelCam CloudBridge",
    message: "ESP32-CAM Web App is running. Use POST from ESP32-CAM."
  });
}


// ============================================================
//  doPost — Main entry point for ESP32-CAM uploads
// ============================================================

function doPost(e) {
  try {
    // ----- 1. Validate request body -----
    if (!e || !e.postData || !e.postData.contents) {
      return jsonResponse({
        success: false,
        message: "No data received. Send JSON using HTTP POST."
      });
    }

    // ----- 2. Parse JSON -----
    var data;
    try {
      data = JSON.parse(e.postData.contents);
    } catch (parseErr) {
      return jsonResponse({
        success: false,
        message: "JSON parse error: " + parseErr.toString()
      });
    }

    // ----- 3. Verify shared secret -----
    if (!data.secret || data.secret !== DEVICE_SECRET) {
      Logger.log("Unauthorized request blocked.");
      return jsonResponse({
        success: false,
        message: "Unauthorized: secret mismatch."
      });
    }

    // ----- 4. Extract and normalize fields -----
    var eventId     = String(data.eventId || "unknown_event");
    var imageIndex  = parseInt(data.imageIndex, 10) || 1;
    var totalImages = parseInt(data.totalImages, 10) || 1;

    // Supports both field names:
    // - imageData   = current Arduino sketch
    // - imageBase64 = future/alternative clients
    var imageBase64 = data.imageBase64 || data.imageData;

    var deviceName  = String(data.deviceName || "ESP32-CAM");
    var timestamp   = String(
      data.timestamp ||
      Utilities.formatDate(new Date(), "UTC", "yyyy-MM-dd_HH-mm-ss")
    );

    if (!imageBase64 || imageBase64.length === 0) {
      return jsonResponse({
        success: false,
        message: "No image data found in request."
      });
    }

    // Keep event folder names safe.
    eventId = eventId.replace(/[^a-zA-Z0-9_\-]/g, "_");

    Logger.log(
      "Event: " + eventId +
      " | Image: " + imageIndex + "/" + totalImages +
      " | Device: " + deviceName
    );

    // ----- 5. Open parent Drive folder -----
    var parentFolder;
    try {
      parentFolder = DriveApp.getFolderById(DRIVE_FOLDER_ID);
    } catch (folderErr) {
      return jsonResponse({
        success: false,
        message: "Cannot open Drive folder. Check DRIVE_FOLDER_ID. Error: " + folderErr.toString()
      });
    }

    // ----- 6. Create/find event subfolder -----
    var eventFolder = getOrCreateFolder(parentFolder, eventId);

    if (ENABLE_LINK_SHARING) {
      eventFolder.setSharing(
        DriveApp.Access.ANYONE_WITH_LINK,
        DriveApp.Permission.VIEW
      );
    }

    var folderUrl = eventFolder.getUrl();

    // ----- 7. Decode base64 and save JPEG -----
    var safeTimestamp = timestamp.replace(/[^a-zA-Z0-9_\-]/g, "_");
    var filename = "motion_" + safeTimestamp + "_img" + imageIndex + ".jpg";

    var imageBytes;
    try {
      imageBytes = Utilities.base64Decode(imageBase64);
    } catch (decErr) {
      return jsonResponse({
        success: false,
        message: "Base64 decode failed: " + decErr.toString()
      });
    }

    var blob = Utilities.newBlob(imageBytes, "image/jpeg", filename);
    var savedFile = eventFolder.createFile(blob);

    if (ENABLE_LINK_SHARING) {
      savedFile.setSharing(
        DriveApp.Access.ANYONE_WITH_LINK,
        DriveApp.Permission.VIEW
      );
    }

    var fileUrl = savedFile.getUrl();

    Logger.log("Saved file: " + filename + " -> " + fileUrl);

    // ----- 8. Send Pushover notification -----
    var shouldNotify = NOTIFY_ON_FIRST_IMAGE
      ? imageIndex === 1
      : imageIndex === totalImages;

    var pushoverStatus = shouldNotify
      ? sendPushover(deviceName, totalImages, folderUrl, timestamp, eventId)
      : "Skipped for this image.";

    Logger.log("Pushover status: " + pushoverStatus);

    // ----- 9. Return JSON success -----
    return jsonResponse({
      success: true,
      service: "SentinelCam CloudBridge",
      message: "Image " + imageIndex + "/" + totalImages + " saved successfully.",
      eventId: eventId,
      imageIndex: imageIndex,
      totalImages: totalImages,
      fileUrl: fileUrl,
      folderUrl: folderUrl,
      pushover: pushoverStatus
    });

  } catch (err) {
    Logger.log("doPost exception: " + err.toString() + "\n" + err.stack);
    return jsonResponse({
      success: false,
      message: "Server exception: " + err.toString()
    });
  }
}


// ============================================================
//  getOrCreateFolder — Reuse event folder or create new one
// ============================================================

function getOrCreateFolder(parent, name) {
  var iter = parent.getFoldersByName(name);

  if (iter.hasNext()) {
    return iter.next();
  }

  Logger.log("Creating new event folder: " + name);
  return parent.createFolder(name);
}


// ============================================================
//  sendPushover — Send mobile security alert
// ============================================================

function sendPushover(deviceName, imageCount, folderUrl, timestamp, eventId) {
  try {
    var readableTime = timestamp
      .replace(/_/g, " ")
      .replace(/-/g, ":");

    var msg =
      "Motion detected by " + deviceName + "\n" +
      "Time    : " + readableTime + "\n" +
      "Images  : " + imageCount + " captured\n" +
      "Event ID: " + eventId + "\n\n" +
      "Open Google Drive to review captured evidence.";

    var payload = {
      "token"     : PUSHOVER_APP_TOKEN,
      "user"      : PUSHOVER_USER_KEY,
      "title"     : "🛡️ SentinelCam Motion Alert",
      "message"   : msg,

      // Pushover accepts form fields as strings.
      // Using String() avoids priority-related HTTP 400 issues.
      "priority"  : String(PUSHOVER_PRIORITY),

      "sound"     : PUSHOVER_SOUND,
      "url"       : folderUrl,
      "url_title" : "Open Captured Images"
    };

    // Emergency priority requires retry + expire.
    if (PUSHOVER_PRIORITY === 2) {
      payload["retry"]  = "60";   // Retry every 60 seconds
      payload["expire"] = "600";  // Stop after 10 minutes
    }

    var options = {
      method: "post",
      contentType: "application/x-www-form-urlencoded",
      payload: payload,
      muteHttpExceptions: true
    };

    var resp = UrlFetchApp.fetch(
      "https://api.pushover.net/1/messages.json",
      options
    );

    var code = resp.getResponseCode();
    var body = resp.getContentText();

    Logger.log("Pushover HTTP " + code + ": " + body);

    if (code === 200) {
      return "Notification sent successfully.";
    }

    return "Notification failed. HTTP " + code + ": " + body;

  } catch (err) {
    return "Pushover exception: " + err.toString();
  }
}


// ============================================================
//  jsonResponse — Return JSON output to ESP32/browser
// ============================================================

function jsonResponse(data) {
  return ContentService
    .createTextOutput(JSON.stringify(data))
    .setMimeType(ContentService.MimeType.JSON);
}


// ============================================================
//  TEST: Pushover notification
//  Run manually inside Apps Script editor before deployment.
// ============================================================

function testPushover() {
  var result = sendPushover(
    "SentinelCam-TestDevice",
    3,
    "https://drive.google.com/drive/folders/YOUR_FOLDER_ID",
    "2026-07-01_14-30-00",
    "test_event_001"
  );

  Logger.log("Test Pushover result: " + result);
}


// ============================================================
//  TEST: Google Drive folder access
//  Run manually inside Apps Script editor before deployment.
// ============================================================

function testDriveAccess() {
  try {
    var folder = DriveApp.getFolderById(DRIVE_FOLDER_ID);
    Logger.log("Drive folder OK: " + folder.getName() + " | URL: " + folder.getUrl());
  } catch (err) {
    Logger.log("Drive folder ERROR: " + err.toString());
  }
}