function checkBinanceEmails() {
  var supabaseUrl = "URL_DE_TU_SUPABASE/rest/v1/pagos";
  var supabaseKey = "TU_API_KEY";

  // Lista de remitentes autorizados de Binance
  var ALLOWED_SENDERS = [
    "[email protected]",
    "[email protected]",
    "[email protected]",
    "[email protected]",
    "[email protected]",
    "[email protected]",
    "[email protected]",
    "[email protected]"
  ];

  for (var loop = 0; loop < 6; loop++) {
    var threads = GmailApp.search(
      'subject:"[Binance] Payment Receive Successful" is:unread newer_than:1d'
    );

    for (var i = 0; i < threads.length; i++) {
      var messages = threads[i].getMessages();
      for (var j = 0; j < messages.length; j++) {
        var msg = messages[j];
        if (!msg.isUnread()) continue;

        var senderRaw = msg.getFrom();
        var emailMatch = senderRaw.match(/<([^>]+)>/);
        var senderEmail = emailMatch ? emailMatch[1].toLowerCase() : senderRaw.toLowerCase().trim();

        var isBinanceOfficial = ALLOWED_SENDERS.indexOf(senderEmail) !== -1 ||
                                /^do-?not-?reply@([a-z0-9-]+\.)*binance\.com$/i.test(senderEmail);

        if (!isBinanceOfficial) {
          msg.markRead();
          continue;
        }

        var body = msg.getPlainBody();
        if (
          body.indexOf("You received an incoming transfer") === -1 ||
          body.indexOf("This is an automated message") === -1
        ) {
          msg.markRead();
          continue;
        }

        var amountMatch = body.match(/Amount:\s*\n?\s*([0-9.,]+)\s*USDT/i);
        var monto = amountMatch ? parseFloat(amountMatch[1].replace(/,/g, "")) : 0;

        var fromMatch = body.match(/From:\s*\n?\s*(.+)/i);
        var remitente = fromMatch ? fromMatch[1].replace(/[\r\n*_]/g, "").trim() : "BIN-" + msg.getId().substring(0, 8).toUpperCase();

        var timeMatch = body.match(/Time:\s*\n?\s*(\d{4}-\d{2}-\d{2}\s+\d{2}:\d{2}:\d{2})/i);
        var binanceTime = timeMatch ? timeMatch[1].replace(/[\s:-]/g, "") : String(Math.floor(msg.getDate().getTime() / 1000));

        var referencia = binanceTime + "_" + remitente;
        if (monto <= 0) { msg.markRead(); continue; }

        var payload = {
          cliente_id: "TU_USUARIO",
          referencia: referencia,
          monto: monto,
          moneda: "USDT",
          estado: "pending"
        };

        try {
          var response = UrlFetchApp.fetch(supabaseUrl, {
            method: "post",
            headers: {
              apikey: supabaseKey,
              Authorization: "Bearer " + supabaseKey,
              "Content-Type": "application/json",
              Prefer: "resolution=ignore-duplicates"
            },
            payload: JSON.stringify(payload),
            muteHttpExceptions: true
          });
          var code = response.getResponseCode();
          if (code >= 200 && code < 300) { msg.markRead(); }
          else if (code === 409) { msg.markRead(); }
        } catch (e) {}
      }
    }
    if (loop < 5) Utilities.sleep(10000);
  }
}

function checkZinliEmails() {
  var supabaseUrl = "URL_DE_TU_SUPABASE/rest/v1/pagos";
  var supabaseKey = "TU_API_KEY";
  var ZINLI_SENDER = "[email protected]";

  for (var loop = 0; loop < 6; loop++) {
    var threads = GmailApp.search(
      'subject:"Recibiste un Zinli" is:unread newer_than:1d'
    );

    for (var i = 0; i < threads.length; i++) {
      var messages = threads[i].getMessages();
      for (var j = 0; j < messages.length; j++) {
        var msg = messages[j];
        if (!msg.isUnread()) continue;

        var senderRaw = msg.getFrom();
        var emailMatch = senderRaw.match(/<([^>]+)>/);
        var senderEmail = emailMatch ? emailMatch[1].toLowerCase() : senderRaw.toLowerCase().trim();
        if (senderEmail !== ZINLI_SENDER) {
          msg.markRead();
          continue;
        }

        var body = msg.getPlainBody();
        if (
          body.indexOf("Recibiste un Zinli") === -1 ||
          body.indexOf("Referencia") === -1
        ) {
          msg.markRead();
          continue;
        }

        var amountMatch = body.match(/Monto[\s\S]*?\$([0-9]+(?:[.,][0-9]+)?)/i);
        var monto = amountMatch ? parseFloat(amountMatch[1].replace(/,/g, "")) : 0;

        var refMatch = body.match(/Referencia[\s\S]*?([0-9]{6,})/i);
        var referencia = refMatch ? refMatch[1].trim() : "ZIN-" + msg.getId().substring(0, 12).toUpperCase();

        if (monto <= 0) { msg.markRead(); continue; }

        var payload = {
          cliente_id: "TU_USUARIO",
          referencia: referencia,
          monto: monto,
          moneda: "USD",
          estado: "pending"
        };

        try {
          var response = UrlFetchApp.fetch(supabaseUrl, {
            method: "post",
            headers: {
              apikey: supabaseKey,
              Authorization: "Bearer " + supabaseKey,
              "Content-Type": "application/json",
              Prefer: "resolution=ignore-duplicates"
            },
            payload: JSON.stringify(payload),
            muteHttpExceptions: true
          });
          var code = response.getResponseCode();
          if (code >= 200 && code < 300) { msg.markRead(); }
          else if (code === 409) { msg.markRead(); }
        } catch (e) {}
      }
    }
    if (loop < 5) Utilities.sleep(10000);
  }
}

function checkBanplusEmails() {
  var supabaseUrl = "URL_DE_TU_SUPABASE/rest/v1/pagos";
  var supabaseKey = "TU_API_KEY";

  var ALLOWED_SENDERS = [
    "[email protected]",
    "[email protected]"
  ];

  for (var loop = 0; loop < 6; loop++) {
    var threads = GmailApp.search(
      'subject:"Pago Movil Interbancario" is:unread newer_than:1d'
    );

    for (var i = 0; i < threads.length; i++) {
      var messages = threads[i].getMessages();
      for (var j = 0; j < messages.length; j++) {
        var msg = messages[j];
        if (!msg.isUnread()) continue;

        var senderRaw = msg.getFrom();
        var emailMatch = senderRaw.match(/<([^>]+)>/);
        var senderEmail = emailMatch ? emailMatch[1].toLowerCase() : senderRaw.toLowerCase().trim();

        var isBanplusOfficial = ALLOWED_SENDERS.indexOf(senderEmail) !== -1 ||
                                /^[a-z0-9._-]+@([a-z0-9-]+\.)*banplus\.com$/i.test(senderEmail);

        if (!isBanplusOfficial) {
          msg.markRead();
          continue;
        }

        var body = msg.getPlainBody();
        var hasBanplusMark = body.indexOf("Banplus") !== -1 || body.indexOf("banplus.com") !== -1;
        var isAprobado = body.toUpperCase().indexOf("APROBADA") !== -1 ||
                         body.toUpperCase().indexOf("TRANSACCION APROBADA") !== -1;

        if (!hasBanplusMark || !isAprobado) {
          msg.markRead();
          continue;
        }

        var refMatch = body.match(/(?:N[úu\?]?mero\s+de\s+Operaci[óo\?]?n|Operaci[óo\?]?n)\s*[:\r\n\s]*([0-9]{6,})/i);
        var referencia = refMatch ? refMatch[1].trim() : "BP-" + msg.getId().substring(0, 10).toUpperCase();

        var amountMatch = body.match(/Monto\s*[:\r\n\s]*(?:Bs\.?|VES)?\s*([0-9.,]+)/i);
        var monto = 0;
        if (amountMatch) {
          var montoStr = amountMatch[1].trim();
          var lastDot = montoStr.lastIndexOf('.');
          var lastComma = montoStr.lastIndexOf(',');
          if (lastComma > lastDot) {
            monto = parseFloat(montoStr.replace(/\./g, '').replace(',', '.'));
          } else if (lastDot > lastComma) {
            monto = parseFloat(montoStr.replace(/,/g, ''));
          } else if (lastComma !== -1) {
            monto = parseFloat(montoStr.replace(',', '.'));
          } else {
            monto = parseFloat(montoStr);
          }
        }

        if (monto <= 0) { msg.markRead(); continue; }

        var payload = {
          cliente_id: "TU_USUARIO",
          referencia: referencia,
          monto: monto,
          moneda: "Bs",
          estado: "pending"
        };

        try {
          var response = UrlFetchApp.fetch(supabaseUrl, {
            method: "post",
            headers: {
              apikey: supabaseKey,
              Authorization: "Bearer " + supabaseKey,
              "Content-Type": "application/json",
              Prefer: "resolution=ignore-duplicates"
            },
            payload: JSON.stringify(payload),
            muteHttpExceptions: true
          });
          var code = response.getResponseCode();
          if (code >= 200 && code < 300) {
            msg.markRead();
          } else if (code === 409) {
            msg.markRead();
          }
        } catch (e) {}
      }
    }
    if (loop < 5) Utilities.sleep(10000);
  }
}