Filter & Track Rows

How do I filter and track rows when sending messages?

This article describes how to filter and track rows of data when you don't want to send messages for all rows at once or you only want to send messages for new rows added since you last sent messages.

When you start WhatsApp Sender in Google Sheets, a new column called Message Status will be created automatically.

Type x (or any other text ) in the cells of the rows you wish to exclude from merging.

Messages will only be sent to the rows that have blank cells in the Message Status column.

NOTE: When your messages are sent, the empty cells in the Message Status column are populated with the date/time the messages were sent. To send messages for these rows again, you will need to clear/delete the date/time values.

Advanced Feature: Conditional Logic Formula to Exclude Rows when Sending Messages

Instead of simply typing x in the Message Status column to exclude rows, you can create a conditional logic formula in Google Sheets to determine which rows should be excluded.

In the example below, rows for message recipients who are female are excluded from the merge as messages will only be sent to the rows that have blank cells in the Message Status column.

Conditional formatting can also be used to create conditional personalized fields.