Has anyone tried this WA Gateway integration into autoreplay integration with Gsheet?

@mantapin webhooknya dari gsheet maksudnya?

2 hours ago, pak kacung said:

@mantapin webhooknya dari gsheet maksudnya?

Do you have tutorial how to make webhook from gsheet mas bro?

15 minutes ago, Gusik Prasetyo said:

Do you have tutorial how to make webhook from gsheet mas bro?

@Gusik Prasetyo i can tell you how i did mine

33 minutes ago, The Billionaire said:

@Gusik Prasetyo i can tell you how i did mine

Yes please, share yours here bro. Thanks in advance

18 hours ago, Bloserda BlogSerbaAda said:

@Magd Almuntaser

Omg how old me, i didnt saw that preety blue sky button there, before you told 😄

Thank you bro, autoreply, api (message, media) integration with google apps script work good!

 

Share please 😊

@Gusik Prasetyo 

Example how to Blast / Bulk message (Different message per number)
type blast: Text (yourhost.com/send-message)

1. Create New spreadsheet :
Column : ColA | ColB | ColC
Exp. Col Name : Destination | Message | Status
*Note Destination: 
- use numberphone  send to personal (628xxxxxxxx)
- use JID send to group (blablabla@g.us) (how to get JID? click Fetch From Selected Device on menu mpwa Phonebook)

2. Create send button:
a. Click Insert -> Drawer (textboxt, SEND) -> Save & Close
b. On shape, right click 3 dot on left choose Assign script type: sendAll

3. Create Google Apps Script:
a. Still on your spreadsheet, click menu Extension -> Apps Script
b. Copy paste sript below:

// Start Here
var url = "http://yourhost/send-message";
var apiKey = "your api_key";
var sender = "your number sender";

function blastWa(number, message) {
  var data = {
    'api_key': apiKey,
    'sender': sender,
    'number': number,
    'message': message
  };
  var options = {
    "method": "POST",
    "contentType": "application/json",
    "payload" : JSON.stringify(data),
  };
  UrlFetchApp.fetch(url, options);
}

function sendFromSheets(){
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2;
  var numRows = sheet.getLastRow() - 1;
  var dataRange = sheet.getRange(startRow, 1, numRows, 2);
  var data = dataRange.getValues();
  
  for (var i = 0; i < data.length; i++){
    var row = data[i];
    var status;
    try {
      var response_data = blastWa(row[0], row[1]);
      status = "Success";
      } 
      catch(err) {
        Logger.log(err);
        status = "Error";
        }
    sheet.getRange(startRow + i, 3).setValue(status);
    Utilities.sleep(10000); //example time delay
  }
}

function sendAll(){
  sendFromSheets();
}
                                  
//End Here

c. Save (give all permission needed).
4. Running on spreadsheet click on button SEND you have been create.

 

How if wanna blast/bulk message different media per number? 

yourhost.com/send-media, change method post (API Docs) 

 

          {
            "api_key": "1234567890",
            "sender": "62888xxxx",
            "number": "62888xxxx",
            "media_type": "image",
            "caption": "Hello World",
            "url": "https://example.com/image.jpg"
          }
        

@mantapin jika pakai api, coba cek di youtube kalau tidak salah produk milik whacenter atau kl mau gampang autoreply integrasi dgn gsheet pakai apk whatsauto di playstore (gratis), tinggal masukkan link google sheet di setting apknya selesai (saya pernah pakai stabil),  tapi jika handphone/sinyal mati, bot mati juga 😄

@Gusik Prasetyo

buat menagkap pesan dulu

function doPost(e) {

  // Membaca pesan

  let conten = e.postData.contents;

  let json = JSON.parse(conten);

  let wa = json['from'];

  let senderMessage = json['message'];

  let pesan = senderMessage.toLowerCase();

  let image = json['bufferImage'];

 

if (pesan == 'menu') {

    let msg = "Silahkan pilih menu";

    kirimpesan(wa, msg);

  }

}

 

function kirimpesan(wa, msg) {

  var APIKey = "your api key"

  var url = "https://wa.trioputra.my.id/send-message";

  var payload = {

    'api_key': APIKey,

    'sender': '6281559554xxx',

    "number": wa,

    'message': msg,

   

 

  };

  var response = UrlFetchApp.fetch(url, {

    "method": "post",

    "headers": {

      "apikey": APIKey

    },

    "payload": payload

  });

  Logger.log(response.getContentText());

}

 

deploy lalu copy url web dan paste di webhook

halo semua master disini tolong bantu dong.. saya coba install di vps ubuntu 22.04 dan semua sdh jalan node . juga sdh aman Server run and listening port: 3100 tapi kok masih waiting node server ya apakah ada yang saya masih kurang atau salah langkah ya ? 

28 minutes ago, Gerry 施顺杰 Sidharta said:

halo semua master disini tolong bantu dong.. saya coba install di vps ubuntu 22.04 dan semua sdh jalan node . juga sdh aman Server run and listening port: 3100 tapi kok masih waiting node server ya apakah ada yang saya masih kurang atau salah langkah ya ? 

Anda harus menggunakan tautan situs http, bukan https

========

You should use http in link, not https

On 6/4/2024 at 12:51 PM, Magd Almuntaser said:

Anda harus menggunakan tautan situs http, bukan https

========

You should use http in link, not https

Sudah pake http tapi tetap waiting for node server.. kenapa ya? 

index (4).html database (5).sql

1 hour ago, babikutech said:

index (4).html 44.44 kB · 0 downloads database (5).sql 208.04 kB · 0 downloads

What are these files for?

On 6/6/2024 at 12:02 PM, Gerry 施顺杰 Sidharta said:

Sudah pake http tapi tetap waiting for node server.. kenapa ya? 

server type gunakan yang shared hosting

18 hours ago, armanalimin said:

server type gunakan yang shared hosting

tapi saya installnya di vps ubuntu gpp? 

2 minutes ago, Gerry 施顺杰 Sidharta said:

tapi saya installnya di vps ubuntu gpp? 

tetap gak bsa 

2 hours ago, Gerry 施顺杰 Sidharta said:

tetap gak bsa 

node js jalan gak?

 

On 6/2/2024 at 6:38 PM, bloserda said:

@Gusik Prasetyo 

Example how to Blast / Bulk message (Different message per number)
type blast: Text (yourhost.com/send-message)

1. Create New spreadsheet :
Column : ColA | ColB | ColC
Exp. Col Name : Destination | Message | Status
*Note Destination: 
- use numberphone  send to personal (628xxxxxxxx)
- use JID send to group (blablabla@g.us) (how to get JID? click Fetch From Selected Device on menu mpwa Phonebook)

2. Create send button:
a. Click Insert -> Drawer (textboxt, SEND) -> Save & Close
b. On shape, right click 3 dot on left choose Assign script type: sendAll

3. Create Google Apps Script:
a. Still on your spreadsheet, click menu Extension -> Apps Script
b. Copy paste sript below:

// Start Here
var url = "http://yourhost/send-message";
var apiKey = "your api_key";
var sender = "your number sender";

function blastWa(number, message) {
  var data = {
    'api_key': apiKey,
    'sender': sender,
    'number': number,
    'message': message
  };
  var options = {
    "method": "POST",
    "contentType": "application/json",
    "payload" : JSON.stringify(data),
  };
  UrlFetchApp.fetch(url, options);
}

function sendFromSheets(){
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2;
  var numRows = sheet.getLastRow() - 1;
  var dataRange = sheet.getRange(startRow, 1, numRows, 2);
  var data = dataRange.getValues();
  
  for (var i = 0; i < data.length; i++){
    var row = data[i];
    var status;
    try {
      var response_data = blastWa(row[0], row[1]);
      status = "Success";
      } 
      catch(err) {
        Logger.log(err);
        status = "Error";
        }
    sheet.getRange(startRow + i, 3).setValue(status);
    Utilities.sleep(10000); //example time delay
  }
}

function sendAll(){
  sendFromSheets();
}
                                  
//End Here

c. Save (give all permission needed).
4. Running on spreadsheet click on button SEND you have been create.

 

How if wanna blast/bulk message different media per number? 

yourhost.com/send-media, change method post (API Docs) 

 

          {
            "api_key": "1234567890",
            "sender": "62888xxxx",
            "number": "62888xxxx",
            "media_type": "image",
            "caption": "Hello World",
            "url": "https://example.com/image.jpg"
          }
        

why is the status Error?

54 minutes ago, ondela wahyu said:

why is the status Error?

Have you run trigger too?

On 6/6/2024 at 11:02 AM, Gerry 施顺杰 Sidharta said:

Sudah pake http tapi tetap waiting for node server.. kenapa ya? 

Dont use https in your website not in nodejs

On 6/8/2024 at 2:25 PM, armanalimin said:

node js jalan gak?

 

jalan  dan sudah listening di port 3100

On 6/8/2024 at 8:54 PM, Magd Almuntaser said:

Dont use https in your website not in nodejs

Ow udah coba kemarin tapi tetap gak bsa , masalahnya ane pake cloud panel , dia selalu minta untuk di arahkan ke https, mungkin mau di edit di vhost nya ya?

thanks...ill try it

 

apakah versi 6.50 ini sudah bisa list message?