Whatsapp Gateway | Multi Device v8.5.1

[mantapin]

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

[pak kacung]

@mantapin webhooknya dari gsheet maksudnya?

[Gusik Prasetyo]

2 hours ago, pak kacung said:

@mantapin webhooknya dari gsheet maksudnya?

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

[The Billionaire]

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

[Gusik Prasetyo]

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

[Gusik Prasetyo]

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

[bloserda]

@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"
          }
        

[bloserda]

@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

[pak kacung]

@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

[Gerry 施顺杰 Sidharta]

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 ? 

[Magd Almuntaser]

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

[Gerry 施顺杰 Sidharta]

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? 

[babikutech]

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

[Gusik Prasetyo]

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?

[armanalimin]

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

[Gerry 施顺杰 Sidharta]

18 hours ago, armanalimin said:

server type gunakan yang shared hosting

tapi saya installnya di vps ubuntu gpp? 

[Gerry 施顺杰 Sidharta]

2 minutes ago, Gerry 施顺杰 Sidharta said:

tapi saya installnya di vps ubuntu gpp? 

tetap gak bsa 

[armanalimin]

2 hours ago, Gerry 施顺杰 Sidharta said:

tetap gak bsa 

node js jalan gak?

 

[ondela wahyu]

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?

[Gusik Prasetyo]

54 minutes ago, ondela wahyu said:

why is the status Error?

Have you run trigger too?

[Magd Almuntaser]

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

[Gerry 施顺杰 Sidharta]

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

node js jalan gak?

 

jalan  dan sudah listening di port 3100

[Gerry 施顺杰 Sidharta]

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

 

[kecoamumet]

apakah versi 6.50 ini sudah bisa list message?