---
title: Integrasi Tally, Google sheet dan Whatsapp
description: "[https://www.youtube.com/@adikiswanto](https://www.youtube.com/@adikiswanto) Integrasi Tally, Google sheet dan Whatsapp (whacenter) Kirim pesan WA setelah isi form di tally tool Tally (form builder) https://tally.so/ google spreadsheet : https://docs.google.com/spreadsheets/ google apps script : https://script.google.com/ whatsapp api gateway : https://whacenter.com/ [Integrasi Tally, Google sheet dan…"
url: "https://order.whacenter.com/docs/integrasi-tally-google-sheet-dan-whatsapp/"
updated: "2023-09-08"
category: Integrasi
tags:
  - google
  - sheet
  - tally
  - whacenter
  - whatsapp
---

# Integrasi Tally, Google sheet dan Whatsapp

[https://www.youtube.com/@adikiswanto](https://www.youtube.com/@adikiswanto)

Integrasi Tally, Google sheet dan Whatsapp (whacenter) Kirim pesan WA setelah isi form di tally

tool

Tally (form builder)
https://tally.so/

google spreadsheet :
https://docs.google.com/spreadsheets/

google apps script :
https://script.google.com/

whatsapp api gateway :
https://whacenter.com/

[Integrasi Tally, Google sheet dan Whatsapp (whacenter) Kirim pesan WA setelah isi form di tally](https://www.youtube.com/embed/NQU_o6JGHWg?feature=oembed)

script

```
function onEditGo(e) {
  
  var range = e.range;
  var spreadSheet = e.source;
  var sheetName = spreadSheet.getActiveSheet().getName();
  var inputValue = e.value;
  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
  var row = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getDataRange().getLastRow();
  var nama = ss.getRange(row,4).getValue();
  var hp =  ss.getRange(row,5).getValue();
  var email =  ss.getRange(row,6).getValue();
  var message = `terima kasih telah mengisi form berikut data anda
Nama : ${nama}
No WA : ${hp}
Email : ${email}`;
  
  if(sheetName == 'Sheet1')
  {  
   
        return sendWaText(hp,message);
    
  } 
}

var idDevice = "xxx"; //ganti dengan device id anda

function sendWaText(number,message){
  
var formdata = {
    "device_id" : ""+idDevice,
    "number" : ""+number,
    "message" : ""+message
  }

  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)


}
```