WhatsApp Numbers

Manage devices used for sending notifications in rotation.

Session ID	Status	Actions

Message Templates

Map products to specific messages. Use {message} as a placeholder.

Product Name	Template Content	Assigned Sender	Actions

Scheduled Messages

Draft messages to be sent at a specific future date and time.

Send At	Recipient Phone	Message Snippet	Sender Session	Status	Actions

Google Sheets Workflow Logs

History of all webhook triggers from Google Sheets.

Time	Sent From	Sent To	Product/Event	Message Snippet	Status

Google Sheets Integration Guide

Follow these steps to link your Google Sheet with this panel.

Waiting for Google Sheet connection...

Paste the script and test a row to connect.

Step 1: Open Apps Script

Go to your Google Sheet, click on Extensions > Apps Script.

Step 2: Paste the Code

Delete any existing code and paste the script below into the editor.

const WEBHOOK_URL = 'http://YOUR_PUBLIC_IP:3000/webhook/google-sheets';

const PHONE_COLUMN_INDEX = 1; // Column A
const MESSAGE_COLUMN_INDEX = 2; // Column B
const PRODUCT_COLUMN_INDEX = 3; // Column C

function onEditFunction(e) {
  try {
    if (!e || !e.range) return;
    const sheet = e.range.getSheet();
    const row = e.range.getRow();
    
    const phone = sheet.getRange(row, PHONE_COLUMN_INDEX).getValue();
    const message = sheet.getRange(row, MESSAGE_COLUMN_INDEX).getValue();
    const product = sheet.getRange(row, PRODUCT_COLUMN_INDEX).getValue();
    
    if (row > 1 && phone && message && phone !== "" && message !== "") {
      sendToWebhook(phone, message, product);
    }
  } catch (err) {
    Logger.log('Error: ' + err.toString());
  }
}

function sendToWebhook(phoneNumber, message, productName) {
  const payload = {
    phoneNumber: String(phoneNumber).replace(/[^0-9]/g, ''),
    message: String(message),
    productName: String(productName || '')
  };
  
  const options = {
    'method' : 'post',
    'contentType': 'application/json',
    'payload' : JSON.stringify(payload)
  };
  
  UrlFetchApp.fetch(WEBHOOK_URL, options);
}
                    

Step 3: Add a Trigger

Click the clock icon (Triggers) on the left side of Apps Script. Add a new trigger:

Function: onEditFunction
Event Source: From spreadsheet
Event Type: On edit

Step 4: Save & Authorize

Save the trigger, click "Advanced", and grant permissions to your Google Account. You're done!

Settings & Configurations

Configure quiet hours, admin alerts, and security.

Disconnection Alerts

Admin Alert WhatsApp Number (with country code) If any number disconnects, we'll message this admin number using another active device.

Quiet Hours / Do Not Disturb

Start Time

End Time (HH:MM)

Change Admin Password

Leave blank to keep your current password.

Welcome Back