Curated Digital Intelligence Feeder

Paste into Google Sheets > Extensions > Apps Script. Handles row updates, email dispatches, and sheet syncing for $0 without consuming Zapier task quotas.

// Google Apps Script Zero-Cost Dispatcher
function onFormSubmitOrSale(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var rowData = e ? e.values : [];
  
  // 1. Process feedback & publish 5-star testimonials
  if (rowData[2] === "5") {
    var wallSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Wall of Love");
    if (wallSheet) {
      wallSheet.appendRow([new Date(), rowData[0], rowData[1], "Verified Buyer"]);
    }
  }
  
  // 2. Trigger Referral License Delivery
  var referralCount = parseInt(rowData[4] || "0", 10);
  if (referralCount >= 3 && !rowData[5]) {
    MailApp.sendEmail({
      to: rowData[1],
      subject: "Unlocked: License Upgrade Granted!",
      body: "Thanks for referring 3 creators! Your upgrade license key is: PRO-TIER-" + Math.random().toString(36).substring(2, 8).toUpperCase()
    });
    // Mark as delivered
    sheet.getRange(e.range.getRow(), 6).setValue("UPGRADE_DELIVERED");
  }
}

// 3. Weekly Telegram Heartbeat Dispatch
function sendWeeklyDigestTelegram() {
  var botToken = "YOUR_TELEGRAM_BOT_TOKEN";
  var chatId = "YOUR_CHAT_ID";
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var totalRows = sheet.getLastRow();
  
  var payload = {
    chat_id: chatId,
    text: "📊 Weekly Feeder Summary: " + totalRows + " total records processed at $0.00 cost!"
  };
  
  UrlFetchApp.fetch("https://api.telegram.org/bot" + botToken + "/sendMessage", {
    method: "post",
    contentType: "application/json",
    payload: JSON.stringify(payload)
  });
}