How to Automate WhatsApp Lead Notifications with Google Sheets & Webhooks

When a prospective client submits an inquiry on your website, your response speed directly decides your closing rate. Studies across sales teams consistently prove that contacting a lead within 5 minutes makes you 21 times more likely to enter a qualified sales conversation compared to waiting 30 minutes.

Yet most small and mid-sized businesses still rely on manual email notifications:

1. Lead fills out a website form.
2. An email sits in an inbox or spam folder.
3. Hours pass before someone notices it.
4. By the time you call, the client has already spoken to your competitor.

In this guide, we'll walk through the exact architecture Vellion Group implements for clients to push instant WhatsApp notifications straight to your sales team the second a row is added to Google Sheets.

The System Architecture

Here is the high-level workflow:

1. User Submission: The customer fills out a form on your website (or an ad campaign).
2. Sheet Recording: Form data is sent via webhook or API directly into a centralized Google Sheet.
3. Trigger Execution: A Google Apps Script onEdit or onChange trigger fires instantly.
4. WhatsApp Dispatch: The script formats a clean notification payload and dispatches it via a WhatsApp Business API provider (like Interakt, Wati, or official Meta Cloud API) directly to your mobile phone.

[Website Form / Ad] 
        ↓ 
  (Webhook POST)
        ↓
  [Google Sheets] 
        ↓ 
 (Google Apps Script)
        ↓ 
[WhatsApp Business API] 
        ↓ 
 [Sales Team Phone] (< 5 seconds)

Step 1: Prepare Your Google Sheet

Create a new Google Sheet named Website Inquiries with the following columns:

Whenever a user submits your website's contact form, write their information to the next empty row.

Step 2: Configure Google Apps Script

Inside your Google Sheet, navigate to Extensions > Apps Script.

Paste the following script into Code.gs. This script triggers on form submission, extracts the lead details, formats the alert, and sends an HTTP POST request to your WhatsApp endpoint:

/**
 * WhatsApp Lead Alert Notification Script
 * Vellion Group Automation Engine
 */

const WHATSAPP_API_URL = "https://api.your-whatsapp-provider.com/v1/send";
const API_TOKEN = "YOUR_BEARER_TOKEN";
const ADMIN_PHONE = "918791962971"; // Country code + 10-digit number

function onNewLeadSubmitted(e) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const lastRow = sheet.getLastRow();
  
  // Extract values from the newest row
  const name = sheet.getRange(lastRow, 2).getValue();
  const phone = sheet.getRange(lastRow, 3).getValue();
  const email = sheet.getRange(lastRow, 4).getValue();
  const service = sheet.getRange(lastRow, 5).getValue();
  const timestamp = new Date().toLocaleString("en-IN", { timeZone: "Asia/Kolkata" });

  // Format WhatsApp message
  const messageBody = 
    `🚨 *NEW LEAD RECEIVED - VELLION GROUP* 🚨\n\n` +
    `👤 *Name:* ${name}\n` +
    `📞 *Phone:* ${phone}\n` +
    `✉️ *Email:* ${email}\n` +
    `🎯 *Service:* ${service}\n` +
    `🕒 *Time:* ${timestamp}\n\n` +
    `👉 *Action:* Reply immediately or tap the phone number to call.`;

  // Payload for WhatsApp Provider API
  const payload = {
    to: ADMIN_PHONE,
    type: "text",
    message: messageBody
  };

  const options = {
    method: "post",
    contentType: "application/json",
    headers: {
      "Authorization": `Bearer ${API_TOKEN}`
    },
    payload: JSON.stringify(payload),
    muteHttpExceptions: true
  };

  try {
    const response = UrlFetchApp.fetch(WHATSAPP_API_URL, options);
    Logger.log("WhatsApp alert sent: " + response.getContentText());
    
    // Mark status as 'Notified' in Column F
    sheet.getRange(lastRow, 6).setValue("Alert Dispatched");
  } catch (error) {
    Logger.log("Error sending notification: " + error.toString());
    sheet.getRange(lastRow, 6).setValue("Notification Failed");
  }
}

Step 3: Setting Up the Trigger

To make this run automatically on every single form submission without manual intervention:

1. Click the Triggers (clock icon) in the left sidebar of Apps Script.
2. Click + Add Trigger in the bottom right corner.
3. Configure:
   • Function to run: onNewLeadSubmitted
   • Deployment: Head
   • Event source: From spreadsheet
   • Event type: On form submit (or On change if inserting rows via API)
4. Save and authorize permissions.

Step 4: Adding Two-Way Quick Actions

While a simple notification is great, high-performing sales setups go one step further:

1. Auto-greeting the customer on WhatsApp: Immediately send an automated WhatsApp message to the customer acknowledging their inquiry:

   "Hi [Name], thank you for contacting Vellion Group! We received your inquiry regarding [Service] and Jay will review your requirements shortly."

2. CRM Sync: Push the lead directly into your CRM (HubSpot, Zoho, Notion, or custom database) and assign follow-up tasks automatically.
3. Escalation alerts: If no team member updates the lead status within 20 minutes, trigger a secondary reminder WhatsApp alert.

Common Pitfalls to Avoid

• Using unofficial WhatsApp scrapers / unofficial libraries: Many cheap tools use web-session automation to send WhatsApp messages. Meta routinely bans phone numbers connected to unofficial tools. Always use official WhatsApp Cloud API or verified Business Solution Providers (BSPs).
• Missing Country Codes: Indian numbers need 91, US numbers need 1. Validate that the phone input field captures or defaults the country code before storing.
• Failure to handle retries: Network timeouts happen. Wrap your API call in a basic retry loop or record errors in a dedicated log column so no lead is lost silently.

What This Unlocks for Your Business

By implementing this single automated workflow:

• Your sales response time drops from 3–4 hours to under 60 seconds.
• Team members don't need to stay glued to a computer or email client.
• Lead drop-off from uncontacted prospects is virtually eliminated.

Building reliable workflows like this is at the core of what we do at Vellion Group. If you want this or other custom automation built for your business operations, check out our Business Process & AI Automation Services or reach out directly.

Written by Jay Agarwal

Founder & Lead Developer at Vellion Group. Jay engineers high-reliability AI automations, custom Shopify stores, and scalable apps for businesses in India and worldwide.

Founder Website GitHub LinkedIn