AUTOMATIC WHATSUP IN GOOGLE SHEET WITH COADING

HI DOSTO  

   WITH THIS CODE WE CAN AUTOMATIC SEND MSG ON WHATSUP 

FIRSTLY GO TO GOOGLE SHEET AND PUT IN SCRIPT COADING THEN USE IT ONLY ONE CLICK THOUSEND MSG ON WHATSUP

 /* Copyright © TNS Institute of Information Technology Pvt. Ltd.

This software is specially developed by TNS for use by its clients

Unauthorized use & copying of this software will attract penalties. 

For support contact helpdesk@ceoitbox.in

Updated 20 August 2020

*/

function onOpen() {

  var mySpsheet = SpreadsheetApp.getActiveSpreadsheet();

  var mySheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Contacts");

  var ui = SpreadsheetApp.getUi();

  ui.createMenu("CEOITBOX")

  .addSubMenu(ui.createMenu("Send")

              .addItem("Send WA Manually", "sendManualWA")

              .addItem("Setup Schedule Manually", "setupMinTrigger")

              .addItem("Test WA", "sendTESTWA"))

    .addSubMenu(ui.createMenu("Trigger")

      .addItem("Create", "setupTrigger").addItem( "Delete", "deleteTrigger"))

    .addSubMenu(ui.createMenu("Admin")

                .addItem("Check License", "licenseStatus")

                .addItem("Clear Status", "clearstatus"))

  .addItem("Help", "showHelp").addToUi();

  Browser.msgBox("Send only relevant messages to people who know you. Sending bulk messages to unknown users will lead to banning of your whatsapp account if they block you. For guidelines see http://www.ceoitbox.com/waguide");

  var mRow = mySheet.getLastRow();

  if (mRow>20000){  Browser.msgBox("It is recommended to create separate sheets for more than 20000 contacts")}

}

function sendManualWA(){WN4.sendManualWA()}

function sendTESTWA(){ WN4.sendTESTWA()}

function setupTrigger(){  WN4.setupTrigger()}

function deleteTrigger(){  WN4.deleteTrigger()}

function licenseStatus(){  WN4.licenseStatus()}

function clearstatus(){  WN4.clearstatus()}

function showHelp(){  WN4.showHelp()}

function setupMinTrigger(){ WN4.setupMinTrigger()}

function delMinTrigger(){  WN4.delMinTrigger()}

function sendWA(){WN4.sendWA()}

function setupSchedule(){WN4.setupSchedule()}