Personalise bulk WhatsApp messages with names from a sheet

To personalise a bulk WhatsApp message, keep one recipient per row in a sheet, give each column a plain header such as first_name or due_date, and write the message with matching placeholders. The tool then builds one message per row, swapping each placeholder for that row's value. Fix blank cells and odd names before anything is sent.

Tools call these placeholders merge fields, variables or tags, and mark them differently: Gmail's mail merge uses @firstname, and many messaging tools use double braces, such as {{first_name}}. The idea is the same everywhere. This guide covers why it's worth doing, how columns map to placeholders, examples for Indian businesses, and the mistakes that turn "Hi Priya" into "Hi ,".

Why personalise bulk WhatsApp messages?

Because WhatsApp is built around messages people expect, and it listens to the people who didn't. Its Business Messaging Policy says users should expect the messages they receive, and that unsolicited ones lead people to block a business. It also says WhatsApp may limit how many messages a business can send, based on blocks and reports. People can tap Not interested on business offers, and when they block a business they can say why, for example that they never signed up.

A message that uses the name someone gave you, and the thing they asked about, reads as the next step in a conversation they started. The same words blasted to a whole list are easier to ignore, mute or report. Personalisation isn't permission, though: it only helps with people who agreed to hear from you.

How does a sheet column become a placeholder?

Mail merge works the same way in most tools. The first row of the sheet holds the column headers, and every row below is one recipient. Each placeholder in the message names a header, and for each row the tool swaps the placeholder for the value in that column. Gmail's help centre describes its own mail merge exactly so: the merge tags come from your spreadsheet's column headers.

phone,first_name,course,batch_start,first_instalment
+919876543210,Ananya,JEE 2027 weekend batch,12 October,"₹18,000"
+919876543211,Rohan,NEET 2027 evening batch,19 October,"₹21,500"

Hi {{first_name}}, your seat in the {{course}} is confirmed. Classes start on {{batch_start}}, and the first instalment of {{first_instalment}} is due a week before. Reply here with any questions.

Hi Ananya, your seat in the JEE 2027 weekend batch is confirmed. Classes start on 12 October, and the first instalment of ₹18,000 is due a week before. Reply here with any questions.

• Headers are names, not sentences. Keep them short, unique and plain, such as first_name or due_date, without spaces or punctuation your tool might reject. Check what your tool accepts: Gmail, for one, gives a named tag only to headers made of letters and numbers and refers to any other column, first_name included, by its position.
• One row, one person. Don't merge cells or squeeze two people into a row; every placeholder must find exactly one value.
• A placeholder copies the cell exactly, capitals, spaces and all, so fix the data rather than the message.

What can you personalise besides the name?

Leave out anything sensitive. WhatsApp's business policy says not to share, or ask people to share, full payment card numbers, financial account numbers or ID card numbers, so an Aadhaar or account number never belongs in a placeholder.

Examples of personalised WhatsApp messages

Hi {{first_name}}, this is {{agent}} from Sunrise Realty. Your visit to the {{project}} sample flat is on {{visit_date}} at {{visit_time}}. The site office is beside the main gate; call me on this number if you're running late.

Hello {{first_name}}, thank you for your IndiaMART enquiry about {{product}}. For {{quantity}}, the price is {{price}} plus GST, delivered to {{city}}. Shall I send a formal quotation?

Hi {{first_name}}, a gentle reminder that invoice {{invoice_no}} for {{amount}} was due on {{due_date}}. If it's already paid, thank you, and please ignore this. If not, the UPI and bank details are on the invoice.

Each names something only that person would recognise. Read a few filled-in messages aloud: if one sounds odd spoken, it will read oddly too. For the follow-up side of these, see real estate follow-up messages and IndiaMART leads on WhatsApp; the WhatsApp text formatter previews bold and lists before you paste.

Common mistakes, and how to catch them

Excel is the usual culprit with numbers: Microsoft notes that it drops leading zeros and shows long numbers, phone numbers included, in scientific notation unless the cells are formatted as text. Then run the same checks before every send:

1. 1Count blanks in every column the message uses, not just the name column. A blank due date is as visible as a blank name.
2. 2Check the phone column: every number with its country code, 91 for India, and none turned into scientific notation.
3. 3Preview five real rows, including the longest name, the shortest and the oddest, and read each filled-in message as the customer would.
4. 4Send a test to your own phone, and look at it on a small screen.
5. 5Note the date of the data. If the sheet is more than a day old for anything with a due date or a price, refresh it first.

How do you send personalised WhatsApp messages at scale?

A WavesFlo campaign sends one personalised message to each person on a contact list imported from a CSV, filled in from that person's row. It can run once, on a schedule or on a recurring schedule, with quiet hours, an optional approval step and the opt-out register checked at the moment of sending. Results come back per message from delivery receipts. Keep names and phone numbers in that import, not in a Google Sheet shared by link: Google Sheets to WhatsApp explains why a sheet should hold offers instead.

Two limits apply whichever tool you use. A group post is one message that every member sees, so personal details belong in one-to-one messages, not group posts. And a placeholder can't make an unexpected message welcome: send only to people who gave you their number and agreed to hear from you.

If you want evidence for your own customers rather than anyone's averages, split a list in two, send each half a version, and compare replies over the following days. Compare replies rather than reads: recipients can switch read receipts off, so a read rate is a floor, as campaign metrics explains.