---
title: Kirim broadcast pesan whatsapp tiap penerima pesan berbeda file / gambar
description: "Kirim broadcast pesan whatsapp tiap penerima pesan berbeda file / gambar dari google spreadsheet video [Kirim broadcast pesan WA tiap penerima pesan berbeda file / gambar dari google spreadsheet](https://www.youtube.com/embed/YaOor2xwp-Y?feature=oembed) appscript ``` function sendWhatsAppMessages() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var dataRange…"
url: "https://order.whacenter.com/docs/kirim-broadcast-pesan-whatsapp-tiap-penerima-pesan-berbeda-file-gambar/"
updated: "2024-05-14"
category: Integrasi
tags:
  - broadcast, google, sheet, whacenter, whatsapp
  - google
  - script
  - whacenter
---

# Kirim broadcast pesan whatsapp tiap penerima pesan berbeda file / gambar

Kirim broadcast pesan whatsapp tiap penerima pesan berbeda file / gambar dari google spreadsheet

video

[Kirim broadcast pesan WA tiap penerima pesan berbeda file / gambar dari google spreadsheet](https://www.youtube.com/embed/YaOor2xwp-Y?feature=oembed)

appscript

```
function sendWhatsAppMessages() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var dataRange = sheet.getDataRange();
  var data = dataRange.getValues();
   var startrow = sheet.getRange("C8").getValue(); // ganti sesuai letak cell awal bc
  var endrow = sheet.getRange("C9").getValue(); // ganti sesuai letak cell akhir bc

  for (var i = startrow; i <= endrow; i++) {
    var row = data[i];
    var name = row[1];
    var phoneNumber = row[2]; // Kolom nomor telepon
    var message = row[3]; // Kolom pesan
    var file = row[4]; // Kolom link file

    sendWaFile(phoneNumber, message, file); // jika file berupa pdf ada 2 kali fungsi kirim file dan text
    sendWaText(phoneNumber, message); // jika file berupa gambar fungsi ini sebaiknya tidak dipakai
  }
}

function sendWaFile(number, message, file) {
  var idDevice = "xxx"; // Ganti dengan ID perangkat Anda
  // var date = new Date();
  // var schedule = Utilities.formatDate(date, Session.getScriptTimeZone(), "yyyy-MM-dd HH:mm:ss");

  var formdata = {
    "device_id" : "" + idDevice,
    "number" : "" + number,
    "message" : "" + message,
    "file" : "" + file,
    // "schedule" : "" + schedule
  };

  var requestOptions = {
    method: 'POST',
    contentType: 'application/json',
    payload: JSON.stringify(formdata),
    redirect: 'follow'
  };

  var response = UrlFetchApp.fetch("https://app.whacenter.com/api/send", requestOptions);
  Logger.log(response);
}

function sendWaText(number, message) {
  var idDevice = "xxx"; // Ganti dengan ID perangkat Anda
  // var date = new Date();
  // var schedule = Utilities.formatDate(date, Session.getScriptTimeZone(), "yyyy-MM-dd HH:mm:ss");

  var formdata = {
    "device_id" : "" + idDevice,
    "number" : "" + number,
    "message" : "" + message,
    //"file" : "" + file,
    // "schedule" : "" + schedule
  };

  var requestOptions = {
    method: 'POST',
    contentType: 'application/json',
    payload: JSON.stringify(formdata),
    redirect: 'follow'
  };

  var response = UrlFetchApp.fetch("https://app.whacenter.com/api/send", requestOptions);
  Logger.log(response);
}
```