---
title: Kirim broadcast pesan WA dari google spreadsheet
description: "[Kirim broadcast pesan WA dari google spreadsheet](https://www.youtube.com/embed/QrotTuKrpp4?feature=oembed) Kirim broadcast pesan WA dari google spreadsheet tool google spreadsheet : [https://docs.google.com/spreadsheets/](https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqbWdYN1BtbHdXQXIxM2E2OXYzTi1lVlYtbHJEQXxBQ3Jtc0tuYUxmT0lXblFGRGFsckZHTWt2TGpsWVhpdkEtNzdsZF9oSUhqX1RmZ3lWNlFnbUtwRElCTjQ2VzA2WnVJdE5STHVzeHpqdW54Y3hUQjNBSkFSX09GQi1SWGxoME9WRXpfZmtVaC1sQ1IxTWlXWXFvVQ&q=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2F&v=QrotTuKrpp4) google apps script : [https://script.google.com/](https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqbUR6cnFnRkNIU2xDZG5JQ05na3VZMmNVcURud3xBQ3Jtc0tucEo3SzVtVTMxUlRsUFBOUVVTTFVVdWJiUmc4ZjdGZW9TX2xXejhreUdYX3dwYkFzQ2tsMHZoV1Bmd3haMFJwWHhZa1BnMWZrWHpvOUE3RDl0eTNiMG1EVjE1YmNUNHZHbE5Ib05GOWVpUjRNUzNfZw&q=https%3A%2F%2Fscript.google.com%2F&v=QrotTuKrpp4) whatsapp api gateway : [https://whacenter.com/](https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqbl94eWZBN0p6N2hlY0F3dk5MbV9zNmpyVGZSZ3xBQ3Jtc0tuZm93b0Y0Mk5JTmVpZXdJYWFYUEVvWDdlQUY5V2p3RE1SdGxwdzE4Q0RtcmxLRkZsSE1MTzJVNGoyWHlmaHlQUkltTGoxZnJISktqRmVVejFvT1JxTzNQOWpCbFRKcjFDd2ZnaEVha1ItS0hiLWhsUQ&q=https%3A%2F%2Fwhacenter.com%2F&v=QrotTuKrpp4) Script : ``` function sendWhatsAppMessages() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var…"
url: "https://order.whacenter.com/docs/kirim-broadcast-pesan-wa-dari-google-spreadsheet/"
updated: "2023-09-22"
category: Integrasi
tags:
  - google
  - script
  - sheet
  - whacenter
  - whatsapp
---

# Kirim broadcast pesan WA dari google spreadsheet

[Kirim broadcast pesan WA dari google spreadsheet](https://www.youtube.com/embed/QrotTuKrpp4?feature=oembed)

Kirim broadcast pesan WA dari google spreadsheet

tool

google spreadsheet : [https://docs.google.com/spreadsheets/](https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqbWdYN1BtbHdXQXIxM2E2OXYzTi1lVlYtbHJEQXxBQ3Jtc0tuYUxmT0lXblFGRGFsckZHTWt2TGpsWVhpdkEtNzdsZF9oSUhqX1RmZ3lWNlFnbUtwRElCTjQ2VzA2WnVJdE5STHVzeHpqdW54Y3hUQjNBSkFSX09GQi1SWGxoME9WRXpfZmtVaC1sQ1IxTWlXWXFvVQ&q=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2F&v=QrotTuKrpp4)

google apps script : [https://script.google.com/](https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqbUR6cnFnRkNIU2xDZG5JQ05na3VZMmNVcURud3xBQ3Jtc0tucEo3SzVtVTMxUlRsUFBOUVVTTFVVdWJiUmc4ZjdGZW9TX2xXejhreUdYX3dwYkFzQ2tsMHZoV1Bmd3haMFJwWHhZa1BnMWZrWHpvOUE3RDl0eTNiMG1EVjE1YmNUNHZHbE5Ib05GOWVpUjRNUzNfZw&q=https%3A%2F%2Fscript.google.com%2F&v=QrotTuKrpp4)

whatsapp api gateway : [https://whacenter.com/](https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqbl94eWZBN0p6N2hlY0F3dk5MbV9zNmpyVGZSZ3xBQ3Jtc0tuZm93b0Y0Mk5JTmVpZXdJYWFYUEVvWDdlQUY5V2p3RE1SdGxwdzE4Q0RtcmxLRkZsSE1MTzJVNGoyWHlmaHlQUkltTGoxZnJISktqRmVVejFvT1JxTzNQOWpCbFRKcjFDd2ZnaEVha1ItS0hiLWhsUQ&q=https%3A%2F%2Fwhacenter.com%2F&v=QrotTuKrpp4)

Script :

```
function sendWhatsAppMessages() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var dataRange = sheet.getDataRange();
  var data = dataRange.getValues();
  var date = new Date();
  var schedule = Utilities.formatDate(date, Session.getScriptTimeZone(), "yyyy-MM-dd HH:mm:ss");
  var startrow = sheet.getRange("G2").getValue();
  var endrow = sheet.getRange("G3").getValue();
  
  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
    
    sendWaText(phoneNumber, message);
  }
}

function sendWaText(number, message) {
  var idDevice = "xxx"; // Ganti Device ID Anda
  
  var formdata = {
    "device_id" : "" + idDevice,
    "number" : "" + number,
    "message" : "" + message,
    //"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);
}
```