top of page
Mercuri Logo

How to Send WhatsApp Messages from Google Sheets Using Mercuri (2026 Guide)

Google Sheets interface displaying names and appointments linked to automated WhatsApp messages using a bot. Text highlights Mercuri integration.

TL;DR


You can integrate Google Sheets with Mercuri to send WhatsApp messages directly from your spreadsheet without opening the Mercuri dashboard.


This setup allows you to:


  • Send bulk WhatsApp messages from Google Sheets


  • Map customer data directly from spreadsheet columns


  • Use approved WhatsApp templates


  • Select specific rows and send messages instantly


The easiest way to send WhatsApp messages from Google Sheets is to connect your spreadsheet with Mercuri using Google Apps Script.


Once connected, you can:


  • Select customer rows directly inside Google Sheets


  • Map spreadsheet data to WhatsApp template variables


  • Send personalized messages without manually copying phone numbers


This removes repetitive manual work and helps businesses manage communication directly from the tools they already use daily.


What is Google Sheets WhatsApp integration?


A Google Sheets WhatsApp integration allows businesses to send WhatsApp messages directly from spreadsheet data.


Instead of manually sending messages one by one, the integration automatically pulls customer information from selected rows and sends personalized WhatsApp templates.


Why use Google Sheets for WhatsApp messaging?


Infographic showing the automation of WhatsApp workflows from Google Sheets. Left: manual process, right: automated with WhatsApp. Green checkmarks and conversation bubbles indicate efficiency.

Many businesses already manage customer information in spreadsheets.


Examples:

  • Lead lists

  • Appointment bookings

  • Event registrations

  • Customer databases

  • Real estate inquiries


Without integration:

  • Teams manually copy phone numbers

  • Messages are sent individually

  • Follow-ups become inconsistent

  • Errors increase as volume grows


Integrating Google Sheets with WhatsApp automation solves this by turning spreadsheet rows into actionable messaging workflows.


How to Send WhatsApp Messages from Google Sheets Using Mercuri


The integration works using:


  • Google Apps Script


  • Mercuri Messaging API


  • WhatsApp Templates


The setup takes only a few steps.


Step 1: Open Google Apps Script


Google Sheets interface showing a table with columns: Name, phone number, country code. Menu open with "Extensions" > "Apps Script" highlighted.

  1. Open your Google Sheet.


  2. Then go to: Extensions → Apps Script


This opens the Apps Script editor where you’ll configure the integration.


Step 2: Create the Required Files


Google Apps Script editor showing code for a WhatsApp sender. The sidebar lists files Code.gs and Sidebar.html highlighted in yellow.

You need two files:

File

Purpose

Sidebar.html

Creates the Mercuri sender UI inside Google Sheets

Code.gs

Handles message sending and API logic


A. Create Sidebar.html


Inside Apps Script:


  1. Click the Plus (+) icon beside Files


  2. Select HTML


  3. Rename it to: Sidebar.html (⚠️ The filename must match exactly.)


  4. Then paste the provided Mercuri HTML code into the file.


B. Create Code.gs


  1. Click the Plus (+) icon again


  2. Select Script


  3. Rename it to: Code.gs


  4. Paste the provided Mercuri Apps Script code into this file.


Step 3: Deploy the Script


Google Apps Script deployment window showing "Web app" selected. "Mercuri Script" typed in description. "Deploy" button highlighted.

After adding the files:


  1. Click Deploy (top-right corner)


  2. Select New Deployment


  3. Choose: Web App


  4. Then: Fill deployment details


  5. Click Deploy


This publishes your Apps Script project so the integration can run properly.


Step 4: Add Your Mercuri API Key


Google Apps Script dashboard with "Script Properties" showing a key-value input area. Settings icon and yellow highlights are visible.

To allow Google Sheets to communicate with Mercuri, you must configure your API key.


In Apps Script:


  1. Open Settings from the left sidebar


  2. Scroll to Script Properties


  3. Add:

Property

Value

MERCURI_MESSAGING_API_KEY

Your Mercuri API Key

This securely connects your spreadsheet with the Mercuri messaging system.


Step 5: Open the Mercuri Sender


A spreadsheet titled "Demo sheet" with columns for Name, phone number, country code, email, and company. A pop-up shows "Open Sender".

  1. Return to your Google Sheet.


  2. From the top menu: Mercuri → Open Sender


  3. This opens the Mercuri WhatsApp Sender side panel directly inside Google Sheets.


Step 6: Map Your Spreadsheet Fields


WhatsApp Sender interface showing fields for recipient, country, phone ID, template ID, and template parameters. "Send Messages" button below.

Now configure how spreadsheet data should be used.


  1. Recipient Column: Map the column containing customer phone numbers.


  1. Template Variables : You can map spreadsheet columns directly to WhatsApp template variables.


  1. Phone Number ID & Template ID : You’ll also need:

    - WhatsApp Phone Number ID

    - WhatsApp Template ID


Step 7: Select Rows and Send Messages


One of the most useful features is selective sending.


You can, A. Select only specific rows and B. Send messages only to those customers


  1. After selecting rows, click Refresh Selected Rows


  2. Click Send Messages


The integration will automatically:

  • Read selected rows

  • Replace template variables

  • Send WhatsApp messages


Why This Setup Is Useful


Using Google Sheets with Mercuri helps businesses:


  • Avoid repetitive manual messaging


  • Send personalized WhatsApp messages at scale


  • Organize communication directly from spreadsheets


  • Reduce operational time


  • Improve consistency in customer communication


Common Mistakes to Avoid


  1. Incorrect file names

Ensure:

  • Sidebar.html

  • Code.gs

match exactly.


  1. Missing API key

Without the API key, the integration cannot send messages.


  1. Wrong column mappings

Double-check:

  • Recipient column

  • Template variable mappings


  1. Using unapproved templates

WhatsApp messages require approved templates before sending.


Key Takeaways


  • Google Sheets can be used as a lightweight WhatsApp messaging system


  • Mercuri allows direct WhatsApp sending from spreadsheet data


  • Template variables make messages personalized automatically


  • Row selection helps control who receives messages


  • This setup works well for reminders, confirmations, and follow-ups

Conclusion


If your business already manages customer data in spreadsheets, integrating Google Sheets with WhatsApp messaging can significantly simplify communication workflows.


By connecting Google Sheets with Mercuri, you can send personalized WhatsApp messages directly from spreadsheet rows without switching tools or manually copying customer information.


Start with a simple workflow:

  • Add customer data to Google Sheets

  • Connect Mercuri

  • Send your first WhatsApp template directly from the sheet


As message volume grows, you can expand this into reminders, follow-ups, and automated communication workflows.

FAQs


Can I send WhatsApp messages directly from Google Sheets?

Yes. Using Google Apps Script and Mercuri, you can send WhatsApp template messages directly from spreadsheet data.


Do I need coding knowledge to set this up?

Basic setup involves copying provided Apps Script files into Google Sheets. No advanced coding knowledge is required.


Can I send personalized WhatsApp messages from spreadsheet rows?

Yes. You can map spreadsheet columns to WhatsApp template variables for personalized messaging.


Can I select specific rows before sending messages?

Yes. The Mercuri sender allows you to select only the required rows before sending.


What types of businesses can use this setup?

This setup works well for:

  • Real estate

  • Clinics

  • Yoga studios

  • Sales teams

  • Appointment-based businesses



bottom of page