In 2025, automation and innovation are hitting the peak where business is not possible without the assistance of auto-performing solutions. Therefore, today, we’re gouging to enlighten you with an auto-performing solution that will give you ease on handling bulk conversation. 


It’s doubtless that communication is becoming laborious to manage these days especially when it comes to at business level or bulk stage. Right? Yeah!


Now, imagine you can automate the crafting of personalized WhatsApp messages and generate clickable links from Google Sheets directly even without opening your WhatsApp.


Sounds impractical? But Actually, it is! That's possible with Google Apps Script seamlessly. This blog explains how to create a tool in Google Sheets to generate personalized WhatsApp messages with clickable hyperlinks.


What All You Need to Drive this Automation 


  1. A Google account.

  2. A basic understanding of Google Sheets.

  3. Google Apps Script enabled on your spreadsheet.

Your Goal


We'll create a custom menu in Google Sheets that:


  • Accepts a list of names, phone numbers, and purposes.

  • Generates personalized messages.

  • Creates clickable WhatsApp links for sending messages.

Download Apps Script

A Stepwise Configuration Guide


Step 1: Prepare Your Google Sheet


  1. Open a new Google Sheet.

  2. Add your data starting from Row 2 in the following columns:

    • Column A: Name

    • Column B: Phone Number

    • Column C: Purpose Leave columns D (Final Message) and E (WhatsApp Link) empty—they will be auto-filled by the script.

Step 2: Add the Apps Script


  1. In Google Sheets, click on Extensions > Apps Script.

  2. Delete the default code and paste the following script:

function onOpen() {
    var ui = SpreadsheetApp.getUi();
    ui.createMenu('Bulk Message')
        .addItem('Generate Bulk Message', 'createWhatsAppHyperlink')
        .addToUi();
}

function createWhatsAppHyperlink() {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var headersRange = sheet.getRange(1, 1, 1, 5);
    headersRange.clearContent();
    var headers = ["Name", "Phone Number", "Purpose", "Final Message", "WhatsApp Link"];
    sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
    var lastRow = sheet.getLastRow();
    if (lastRow < 2) {
        Logger.log("No data to process.");
        return;
    }
    var dataRange = sheet.getRange(2, 1, lastRow - 1, 3);
    var data = dataRange.getValues();
    var finalMessageData = [];
    for (var i = 0; i < data.length; i++) {
        var name = data[i][0];
        var phoneNumber = data[i][1];
        var purpose = data[i][2];
        var finalMessage = "Hi " + name + ", " + purpose;
        finalMessageData.push([finalMessage]);
    }
    var columnD = sheet.getRange(2, 4, finalMessageData.length, 1);
    columnD.setValues(finalMessageData);
    var whatsappLinks = [];
    for (var i = 0; i < data.length; i++) {
        var phoneNumber = data[i][1];
        var finalMessage = finalMessageData[i][0];
        var whatsappLink = "https://api.whatsapp.com/send?phone=" + phoneNumber + "&text=" + encodeURIComponent(finalMessage);
        var displayText = "click to send";
        var hyperLinkFormula = '=HYPERLINK("' + whatsappLink + '", "' + displayText + '")';
        whatsappLinks.push([hyperLinkFormula]);
    }
    var columnE = sheet.getRange(2, 5, whatsappLinks.length, 1);
    columnE.setFormulas(whatsappLinks);
    Logger.log("Final Messages filled and WhatsApp hyperlinks created successfully!");
}

Step 3: Run the Script


  1. Refresh your Google Sheet.

  2. A new menu titled Bulk Message will appear.

  3. Click on Bulk Message > Generate Bulk Message.

Step 4: View the Results


  • Column D (Final Message): Displays personalized messages.

  • Column E (WhatsApp Link): Contains clickable links to send messages directly via WhatsApp.

Key Features


  1. Personalized Messaging: Automatically includes the recipient's name and purpose in the message.

  2. WhatsApp Links: Generates links that open directly in WhatsApp, saving you time.

  3. Custom Menu: User-friendly interface integrated into Google Sheets.

Use Cases


  • Marketing campaigns.

  • Event invitations.

  • Bulk communication with clients or teams.

Conclusion


Utilizing the potential of Apps Script with Google Sheets, you can manage bulk WhatsApp messaging automatically and a very ease. Here most of the communication processes will get done automatically that were performed manually before.  Through this process, you'd actually be creating a powerful tool that can automatically create a personalized message and clickable WhatsApp link. To do this, you can simply save your precious time and effort along the way.