Filter & Track Rows

How to filter and track rows when sending WhatsApp messages?

This article describes how to filter and track rows of data when you don't want to send WhatsApp 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 Walution in Google Sheets, a new column called Message Status is created automatically.

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

Messages are only 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 WhatsApp 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 the recipients who are female are excluded from the merge as messages are only sent to the rows that have blank cells in the Message Status column.

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