1. Home
  2. Google Sheets
  3. Contacts

Filter recipients

Wondering how to send emails only to certain rows and skip others? How to send emails only to the new people added to the list? Mailmeteor lets you filter your spreadsheet to segment your contact list in just a few clicks.

How to segment your contact list

You can easily create filters and divide your list into smaller segments.

  1. Open your spreadsheet in Google Sheets.
  2. On the left of your screen, click on the number 1. This will select your entire first row.
Select first row in Google Sheets
  1. In the Google Sheets toolbar, click the filter icon. Alternatively, you can go to Data > Create a filter.
Create a filter in Google Sheets
  1. To configure your filter, go to the top of the range and click Filter Filter .
Configure a filter in Google Sheets

Your emails will be only to visible rows. Play with the settings of your filter to target a specific audience and send emails only to certain recipients.

To turn off your filter, go to Data > Turn off filter.

Tip #1: How to send emails to only some recipients

Here is a step-by-step guide if you have a contact list and want to send a campaign only to some of them. For example, you’d like to send emails only to people living in a specific country:

  1. Filtre your spreadsheet as shown above.
  2. Select the “country” column and untick all values except USA. This will hide all rows except for the recipients with “USA” in the “country” column.
  3. Open Mailmeteor in Google Sheets and send a new email campaign. Your messages will be sent only to visible rows.

Here’s a spreadsheet demo that gives you an idea on how it will look like after a few campaigns sent using filters:

List segment example

Sending campaigns to all countries, then USA only, then outside USA.

Here’s how you can use the Google Sheets filters to engage with recipients who have not taken action yet with your first email:

  1. Filter your spreadsheet as shown above.
  2. Select the “Merge status” column and untick all values except “Emails opens”.
  3. Open Mailmeteor and send a new campaign. Mailmeteor will send emails only to the people who have opened your email but didn’t click any links.

Tip #3: Resume sending emails from the last email sent, to avoid re-sending emails to all your contact list

Want to email only the people who were added recently to your list? Or to resume sending emails after your last campaign? Try using this filter.

  1. Filter your spreadsheet as shown above.
  2. Select the “Merge status” column and make sure only “Blank” cells are visible.
  3. Open Mailmeteor and send a new campaign. Mailmeteor will send emails only to the people you haven’t been contacted yet.

Video tutorial

If you prefer to watch a video, here’s a tutorial on how to use filters to segment your email list with Mailmeteor: