Feature Request Contact us
Get Started
Create Your Campaign
CRMs Integration
Email Delivery
Track Your Campaign
Your Dashboard
Advanced Options
Troubleshooting
Data Security & Policy

Segment your list and only send emails to specific people / rows

Avatar
YAMM Team
Updated
Follow

Target and segment your contact list with our three methods: With filters from Google Sheets, by hiding rows, and/or by adding a zero (0) under the 'Merge status' column from your spreadsheet.

Method 1: Send your email only to filtered rows

info Use Google Sheets filters for big mailing list and target a specific group of people!

First, add filters in your spreadsheet. Click cell A1, then the 'Filter' button from your Google Sheets toolbar:

Add filters to your spreadsheet

Once done, you should see the filters (little arrows) on your headers:

filters_set_up.PNG

The following example shows that we want to send an email only to people who have replied in the past:

filtered_1initial.pngfiltered_2on_yes.PNG

After filtering on 'Yes', YAMM will notify you and make sure that only the filtered rows will be processed:

filtered_3notification.PNG

When you go back to your spreadsheet and remove the filters, you will see the mention 'EMAIL_SENT' only on previously filtered rows (3, 5 & 6), which indicates that YAMM has correctly skipped the other recipients:

Filtered rows results

not_interested This option doesn't work with filtered views. Many people can create different filtered views and we're not able to detect which one is active. So make sure to use real Google Sheets filters.
filtered-views-not.png

Method 2: Hide some rows to skip these recipients

info Very convenient to use, hiding rows is suitable for smaller mailing lists.

If you want to send your emails to specific rows, you can hide some rows from your spreadsheet, and YAMM will automatically skip them and will send your campaign only to visible rows:

Hidden rows skipped

Not sent to hidden rows

Method 3: Add '0' to skip the rows and send your email to the other recipients

info This method is useful for big mailing lists, without filtering on a specific criteria.

If it doesn’t exist yet, add a column named 'Merge status' in your Sheet and add a '0' (zero) for all the rows that should be skipped. This option is useful if you don't want to send your mail merge to your whole mailing list.

In the picture above, an email will be sent to rows 2, 4 & 5 (where the cells are empty under 'Merge status'), but not to rows 3, 6 & 7. Also note that the rows with the tags 'EMAIL_SENT', 'EMAIL_OPENED', 'EMAIL_CLICKED' or 'UNSUBSCRIBED' already applied will be skipped as well. Learn more about this feature in this article.

Like for the Google Sheets filters, you'll see a notification if we find rows that should be skipped.

filtered_3notification.PNG

info This method can also be used to send your campaign to the remaining recipients from your spreadsheet without sending duplicates to those who already received your email. In that case, simply delete the '0' under the 'Merge status' column, and start your mail merge as usual. But don't delete the other mentions (EMAIL_SENT, EMAIL_OPENED etc.)!

Comments

3 comments

Sort by Date Votes

Please sign in to leave a comment.

Articles in this section

Help us improve this documentation! Was this article helpful?
60 out of 74 found this helpful