Data di Google Spreadsheet → Google Apps Script → WhatsApp API → Pesan terkirim ke HP

// =============================================
// KONFIGURASI — sesuaikan bagian ini
// =============================================
const API_URL   = "https://api.layanan-wa-kamu.com/send"; // Endpoint API WA yang kamu pakai
const API_TOKEN = "isi-token-atau-api-key-kamu-di-sini";  // Token dari dashboard layanan

// Nama kolom di spreadsheet (harus sama persis dengan header)
const COL_NAMA      = "Nama";
const COL_NOMOR_WA  = "WhatsApp";
const COL_PESAN     = "Pesan";
const COL_STATUS    = "Status"; // Kolom untuk mencatat hasil pengiriman

// =============================================
// FUNGSI UTAMA
// =============================================
function kirimPesanWA() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const data  = sheet.getDataRange().getValues();
  const header = data[0]; // Baris pertama = header

  // Ambil index kolom berdasarkan nama header
  const idxNama   = header.indexOf(COL_NAMA);
  const idxNomor  = header.indexOf(COL_NOMOR_WA);
  const idxPesan  = header.indexOf(COL_PESAN);
  const idxStatus = header.indexOf(COL_STATUS);

  // Loop dari baris ke-2 (index 1) karena baris 0 adalah header
  for (let i = 1; i < data.length; i++) {
    const row    = data[i];
    const nama   = row[idxNama];
    const nomor  = row[idxNomor].toString().trim();
    const pesan  = row[idxPesan];
    const status = row[idxStatus];

    // Skip baris yang sudah terkirim atau kosong
    if (!nomor || status === "Terkirim") continue;

    // Kirim pesan via API
    const hasil = kirimKeAPI(nomor, pesan);

    // Catat status di spreadsheet
    const statusCell = sheet.getRange(i + 1, idxStatus + 1);
    if (hasil) {
      statusCell.setValue("Terkirim");
    } else {
      statusCell.setValue("Gagal");
    }

    // Jeda kecil agar tidak kena rate limit
    Utilities.sleep(500);
  }
}

// =============================================
// FUNGSI KIRIM KE API
// =============================================
function kirimKeAPI(nomor, pesan) {
  const options = {
    method: "post",
    headers: {
      "Authorization": API_TOKEN,
      "Content-Type": "application/x-www-form-urlencoded"
    },
    payload: {
      target: nomor,
      message: pesan
    },
    muteHttpExceptions: true
  };

  try {
    const response = UrlFetchApp.fetch(API_URL, options);
    const result   = JSON.parse(response.getContentText());
    Logger.log("Response untuk " + nomor + ": " + JSON.stringify(result));

    // Cek apakah berhasil (sesuaikan dengan format response API yang kamu pakai)
    return result.status === true || result.status === "success" || response.getResponseCode() === 200;
  } catch (e) {
    Logger.log("Error untuk " + nomor + ": " + e.toString());
    return false;
  }
}

const API_URL   = "https://api.fonnte.com/send";
const API_TOKEN = "token-dari-dashboard-fonnte";

// Payload sudah sesuai, tidak perlu ubah

const API_URL   = "https://api.twilio.com/2010-04-01/Accounts/ACCOUNT_SID/Messages.json";
const API_TOKEN = "Basic " + Utilities.base64Encode("ACCOUNT_SID:AUTH_TOKEN");

// Ubah fungsi kirimKeAPI - Twilio pakai format berbeda
function kirimKeAPI(nomor, pesan) {
  const options = {
    method: "post",
    headers: { "Authorization": API_TOKEN },
    payload: {
      To: "whatsapp:+" + nomor,
      From: "whatsapp:+14155238886", // Nomor sandbox Twilio
      Body: pesan
    },
    muteHttpExceptions: true
  };
  const response = UrlFetchApp.fetch(API_URL, options);
  return response.getResponseCode() === 201;
}

const PHONE_NUMBER_ID = "id-nomor-bisnis-kamu";
const API_URL   = `https://graph.facebook.com/v18.0/${PHONE_NUMBER_ID}/messages`;
const API_TOKEN = "Bearer token-akses-meta-kamu";

function kirimKeAPI(nomor, pesan) {
  const payload = {
    messaging_product: "whatsapp",
    to: nomor,
    type: "text",
    text: { body: pesan }
  };
  const options = {
    method: "post",
    headers: {
      "Authorization": API_TOKEN,
      "Content-Type": "application/json"
    },
    payload: JSON.stringify(payload),
    muteHttpExceptions: true
  };
  const response = UrlFetchApp.fetch(API_URL, options);
  const result   = JSON.parse(response.getContentText());
  return result.messages && result.messages[0].id;
}

const pesan = "Halo " + nama + ",\nTagihan kamu sudah jatuh tempo.\nSegera lakukan pembayaran.";

target: "6281234567890,6287654321098"

Utilities.sleep(1000); // Jeda 1 detik antar pesan