WhatsApp Smarts AI Tools - WhatsApp Group Enquiry Management & Google Sheets Sync

WABT

whatsapp automation business tools

Back to Hub Open Google Sheet

Total Enquiries

0

New Leads

0

Contacted

0

Closed Deals

0 Recent Incoming Enquiries

Time	Group Name	Sender	Message	Status	Action

Active WA Groups

Showing 0 enquiries

Timestamp	Group	Customer Name	Phone Number	Enquiry Message	Sheet Sync	Status	Actions

1. WhatsApp Connection

Scan this QR code from your phone's WhatsApp app (Linked Devices) ONCE during setup.

Initializing WhatsApp Engine...

DISCONNECTED

Please scan the QR code using WhatsApp on your phone.

2. Enquiry Detection Keywords

The system uses these keywords to identify genuine business enquiries from regular group chatter.

3. Select WhatsApp Groups to Monitor

Toggle monitoring ON/OFF for each WhatsApp group. Only enabled groups will save enquiries to Google Sheet.

4. Google Sheets Integration Settings

Google Sheet ID Copy the ID from your Google Sheet URL: https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit

Sync Mode

Direct Google Sheets API (v4) Google Apps Script Webhook URL

Google Apps Script Webhook URL (Required for Webhook Mode)

Webhook Script Setup

If you choose Webhook mode, copy the code below, go to your Google Sheet > Extensions > Apps Script, paste it, and deploy as a Web App to get your Webhook URL.

function doPost(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var data = JSON.parse(e.postData.contents);
    var action = data.action || 'create';
    var id = data.id || '';
    if (action === 'create') {
      sheet.appendRow([data.timestamp, data.groupName, data.senderName, data.phoneNumber, data.message, data.status, data.category, id]);
      return ContentService.createTextOutput(JSON.stringify({"result": "success", "action": "created"})).setMimeType(ContentService.MimeType.JSON);
    } else if (action === 'update' || action === 'delete') {
      var dataRange = sheet.getDataRange();
      var values = dataRange.getValues();
      var rowIndex = -1;
      for (var i = 1; i < values.length; i++) {
        if (values[i][7] === id) { rowIndex = i + 1; break; }
      }
      if (rowIndex !== -1) {
        if (action === 'delete') { sheet.deleteRow(rowIndex); return ContentService.createTextOutput(JSON.stringify({"result": "success", "action": "deleted"})).setMimeType(ContentService.MimeType.JSON); }
        else {
          var rowRange = sheet.getRange(rowIndex, 1, 1, 8);
          var existingRow = values[rowIndex - 1];
          rowRange.setValues([[data.timestamp || existingRow[0], data.groupName || existingRow[1], data.senderName || existingRow[2], data.phoneNumber || existingRow[3], data.message || existingRow[4], data.status || existingRow[5], data.category || existingRow[6], id]]);
          return ContentService.createTextOutput(JSON.stringify({"result": "success", "action": "updated"})).setMimeType(ContentService.MimeType.JSON);
        }
      }
    }
  } catch(err) { return ContentService.createTextOutput(JSON.stringify({"result": "error", "error": err.message})).setMimeType(ContentService.MimeType.JSON); }
}
function doOptions(e) { return ContentService.createTextOutput("OK").setMimeType(ContentService.MimeType.TEXT); }

0

0

0

0