Webhook Guide - Google Sheets Integration

🔧 How It Works

When a WhatsApp message or event triggers your webhook, WMS Personal will send a POST request containing message data to your specified URL. Using Google Apps Script, you can receive this data and store it directly into your Google Sheet — hosted for free by Google.

✅ No server needed — Google hosts it for you
📊 Data is written straight into your chosen Sheet
🔗 Perfect for logs, reporting, or analytics

🪄 Step 1: Create Your Google Sheet

Go to Google Sheets and create a new Sheet (e.g., WhatsApp Logs).
In Row 1, create headers such as:
Phone | Message | Timestamp

⚙️ Step 2: Add Google Apps Script

In your Sheet, go to Extensions → Apps Script and paste this code:

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);

  // Append webhook data to the sheet
  sheet.appendRow([
    data.from || '',
    data.message || '',
    new Date(data.timestamp * 1000)
  ]);

  // Send a reply message
  var reply = "Thank you. Message Received.";

  // Return a JSON response (same format your WhatsApp system expects)
  return ContentService
    .createTextOutput(JSON.stringify({ reply: reply }))
    .setMimeType(ContentService.MimeType.JSON);

  return ContentService.createTextOutput("OK");
}

This script receives incoming webhook data from WMS Personal and writes it as a new row into your Sheet. It then sends a reply back "Thank you. Message Received."

🚀 Step 3: Deploy as Web App

Click Deploy → New deployment
Choose Web app
Under Execute as, select Me
Under Who has access, select Anyone
Click Deploy and copy your Web App URL, e.g.
https://script.google.com/macros/s/AKfycbx123abcXYZ/exec

🔗 Step 4: Connect Your Webhook in WMS Personal

Login to your WMS Personal Dashboard
Go to your Device Settings
Paste your Google Apps Script Web App URL in the Webhook URL field
Save and reconnect your device

Now, every incoming WhatsApp message will automatically be sent to your Google Sheet 🎉

📬 Webhook Payload (POST)

Here’s an example of what WMS Personal will send to your webhook URL:

{
  "user_id": 123,
  "device_id": "abc123",
  "whatsapp_id": "60123456789@s.whatsapp.net",
  "from": "60123456789",
  "message": "Hi, can I get more info?",
  "message_id": "XYZ987654",
  "timestamp": 1722337200
}

💡 Optional Enhancements

🧩 Add columns for user_id or message_id to track more details
📈 Use Google Sheets formulas or charts to analyze conversation data
📤 Connect your Sheet to Google Data Studio or Looker for visual dashboards
🔔 Use Apps Script to trigger email notifications when certain keywords are received

🔒 Security Tips

Don’t publish sensitive customer information publicly
Keep your Google account secure and active
You can add a secret token check if you want to restrict access

Start Logging to Google Sheets Today

It only takes 5 minutes to set up your free Google-hosted webhook — no server required!

Create Your Free Account

Webhook Guide – Google Sheets Integration