Step-by-step guide
How to notify the person named in a Google Sheets column
Most sheets have a column called “Owner”, “Rep” or “Technician”. The idea is simple: when something changes in the row, the person named in that column should know, and only them. In this guide we make each row reach its owner on WhatsApp, without a separate rule for each team member.
Sheet Pulse team ·
One rule instead of twenty
The hard way is a rule per person: “if the rep is Ahmed, send to Ahmed”, then another for Mona, then for Karim, and a new rule for every new hire. The right way is one rule that says “send to the person named in the Rep column”. Sheet Pulse reads the name in each row, knows its owner's number, and sends them their row only.
Each person, their own rows
Ahmed doesn't see Mona's customers, and Mona doesn't see Karim's orders.
A new hire?
Add them in the app and write their name in the sheet. No new rule.
Reassigning?
Change the name in the row, and it reaches its new owner.
The steps
A name column in the sheet
One column, such as “Owner”, holding each row's owner as your team knows them.
Add your team in Sheet Pulse
Each name as written in the sheet, with a phone number, or import everyone from an Excel or CSV file.
Pick the “each person gets their task” card
A ready card in the app: pick the tab, the name column and the condition, such as “Owner is filled in” or “status becomes New”.
Pick the message's columns
What the row's owner needs to act: the customer's name, the address, the amount.
Send a test
Try the message on your phone before turning the rule on for the team.
📌 New lead for you: Sara Mahmoud
Phone: 0551234567
Interested in: yearly plan
Source: website form
Open the sheet
11:40
A full example: the leads sheet
A sheet with the columns Name, Phone, Interest, Source and “Owner”. The team leader assigns leads by writing a rep's name in the Owner column. The rule: “Owner is filled in, send to the person named, with Name, Phone and Interest”. The result: as soon as the leader writes “Youssef” in the row, the lead's details reach Youssef's phone, and nobody else sees them. If the leader reassigns the lead and writes “Mona” instead, the message reaches Mona.
- The team leader sends no message by hand: writing the name is enough.
- The rep knows about the new lead in good time, and calls while the lead is still interested.
- The manager can get a daily digest of every assignment.
When names aren't written the same way
Real teams don't always write names the same way: “Mohamed”, “M. Mohamed”, “مŘمد”. Sometimes two names share one cell. Sheet Pulse is made for this:
Other spellings
Give one person several spellings, and the message reaches them whichever is used.
Several names in a cell
“Ahmed, Mona” in one cell? The alert reaches each of them.
An unknown name
If a name you haven't added appears, the app offers it to you to link to its person in one click.
A group's name
Write “East team” in the cell, and the alert reaches the whole group.
Phone numbers
Numbers without the country code? The app fixes them in one click.
Telegram instead of WhatsApp
Send the team member an invite link; they press Start and get what's theirs on Telegram.
Where this helps
Sales
Every lead reaches the rep named in the row, who calls before a competitor does.
Tasks
Every task reaches its owner as soon as their name is written; several names reach everyone.
Maintenance
Every ticket reaches the technician named in the row, with the address and the fault.
Clinics
Each doctor's bookings reach them alone, not the clinic's whole schedule.
And the manager stays informed: add a second rule that sends them a daily digest, or send only the important cases to the team's WhatsApp or Telegram group. All from your Google Sheets as they are.
Questions about notifying the person named in a column
Do I need a column with phone numbers?
No. The name in the sheet is enough. Numbers are saved once in Sheet Pulse with each person, or imported from an Excel or CSV file.
What if several names are written in one cell?
The alert reaches each of them, and names you haven't added yet are offered to you to link to their people.
Does a team member see their colleagues' rows?
No. Each person gets only their own rows, with the columns you chose for the message.
Can the alert reach the person and the manager together?
Yes. Add the manager to the rule's recipients, or make a second rule that sends them a daily digest.
Does it work with Telegram?
Yes. Pick Telegram as the rule's channel, or send on WhatsApp and Telegram together; the team member joins the bot through an invite link by pressing Start.
Read next
- Notify the assigned personThe whole feature: names, groups, group chats and contact import.
- Team task tracking with Google SheetsEach task to its owner, each approval with one reply.
- How to get a WhatsApp message when a cell changesYour first alert in five steps.
- Google Sheets WhatsApp alertsEverything Sheet Pulse does, on one page.
Let every row reach its owner
Message our sales team on WhatsApp and we will set up the assigned-person rule with you, on your own sheet.