{"id":322,"date":"2016-07-11T05:01:00","date_gmt":"2016-07-11T05:01:00","guid":{"rendered":"http:\/\/www.gmass.co\/blog\/?p=322"},"modified":"2025-08-30T00:26:26","modified_gmt":"2025-08-30T00:26:26","slug":"send-mail-merge-to-selected-rows-spreadsheet","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/","title":{"rendered":"Send a mail merge campaign to just selected rows of a spreadsheet"},"content":{"rendered":"<p>When connecting to a <strong>Google Sheets<\/strong> spreadsheet to send a <a href=\"http:\/\/www.gmass.co\/gmail-mail-merge\">mail merge campaign<\/a>, you can now specify <strong>filter criteria<\/strong> to pull only <strong>certain email addresses that match the criteria<\/strong>.<\/p>\n<p>You&#8217;ll notice a new <strong>Filter Rows<\/strong> box when connecting to a spreadsheet.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25214\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering.png\" alt=\"\" width=\"1999\" height=\"1293\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering.png 1999w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering-300x194.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering-1024x662.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering-768x497.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering-1536x994.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering-24x16.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering-48x31.png 48w\" sizes=\"auto, (max-width: 1999px) 100vw, 1999px\" \/><\/a><\/p>\n<p>This post explains how to use the <strong>Filter Rows<\/strong> box and what to type to send email to just\u00a0the rows that match your criteria. Specify one criteria per line, in the format:<\/p>\n<p><span style=\"font-family: 'courier new' , 'courier' , monospace;\">ColumnName=Value<\/span><\/p>\n<p>For example, if you have a spreadsheet column called <strong>Company<\/strong>, and you want to send a mail merge campaign to just everyone who&#8217;s <strong>Company<\/strong> is &#8220;Microsoft&#8221;, you would enter:<\/p>\n<p><span style=\"font-family: 'courier new' , 'courier' , monospace;\">Company=Microsoft<\/span><\/p>\n<p>Instead of the = sign, you can instead use the ~ operator to represent &#8220;contains&#8221;. For example, let&#8217;s say that your email addresses are in a column called <strong>Email<\/strong>. You want to send to only @yahoo.com addresses. You would\u00a0enter:<\/p>\n<p><span style=\"font-family: 'courier new' , 'courier' , monospace;\">Email~yahoo<\/span><\/p>\n<p>meaning all rows where the <strong>Email<\/strong> value contains &#8220;yahoo&#8221;.<\/p>\n<h3>Full List of Operators<\/h3>\n<p>Along with = and ~ you can also use these operators:<\/p>\n<pre>!= for \"not equals\"\r\n\r\n&gt; for \"greater than\"\r\n\r\n&gt;= for \"greater than or equal to\"\r\n\r\n&lt; for \"less than\"\r\n\r\n&lt;= for \"less than or equal to\"\r\n\r\n~ for \"contains\"\r\n\r\n= for \"equals\"<\/pre>\n<h3>Examples<\/h3>\n<p>You can use the operators above to compare strings, numbers, and dates. For example, if you have a spreadsheet column called <strong>Age<\/strong>, and you wanted to <strong>email just the adults<\/strong> in the spreadsheet, you could set:<\/p>\n<pre>Age &gt;= 18<\/pre>\n<p>Or, let&#8217;s say you didn&#8217;t have an <strong>Age<\/strong> column but instead had a <strong>DateOfBirth<\/strong> column. Then you could set:<\/p>\n<pre>DateOfBirth &lt;= 1\/1\/1999<\/pre>\n<p>assuming that anyone born before 1\/1\/1999 is an adult.<\/p>\n<h3>Special Values<\/h3>\n<p>There are two special values you can use to represent date values. These are:<\/p>\n<pre>CurrentDate\r\n\r\nCurrentDateIgnoreYear<\/pre>\n<p>You can use these values to compare the data in your spreadsheet to the current system date (in the GMT time zone). For example, if you have a column in your spreadsheet called <strong>ShipDate<\/strong>, which represents when a customer&#8217;s order will be shipped, you could set:<\/p>\n<pre>ShipDate=CurrentDate<\/pre>\n<p>to pull just the rows where the order&#8217;s shipping date is today to let the customer know that their order has been shipped and will arrive soon.<\/p>\n<p>Using <strong>CurrentDateIgnoreYear<\/strong> matches just the <strong>Month<\/strong> and <strong>Day<\/strong> parts of the date to the current Month and Day. For example, if you have a column called <strong>Birthday<\/strong> and you want to send an email to people only on their birthdays, but birthdays include the year the person was born, then this will be useful. If three of your birthday values are: 1\/1\/72, 4\/5\/80, and 3\/1\/90, then using &#8220;Birthday=<strong>CurrentDate<\/strong>&#8221; would never match the rows because the rows contain the birth year. Using &#8220;Birthday=<strong>CurrentDateIgnoreYear<\/strong>&#8221; however would match rows on a person&#8217;s birthday. Also, see the <a href=\"https:\/\/www.gmass.co\/blog\/gmail-birthday-emails-automatically\/\">detailed guide to sending birthday emails with Gmail and GMass<\/a>.<\/p>\n<h3>Multiple Criteria<\/h3>\n<p>You can also specify <strong>multiple criteria<\/strong>. Let&#8217;s say your spreadsheet has the columns <strong>Company<\/strong> and <strong>Position<\/strong>. Let&#8217;s say you want to send to everyone whose <strong>Company<\/strong>=Microsoft, and <strong>Position<\/strong>=Manager. You would enter:<\/p>\n<p><span style=\"font-family: 'courier new' , 'courier' , monospace;\">Company=Microsoft<\/span><br \/>\n<span style=\"font-family: 'courier new' , 'courier' , monospace;\">Position=Manager<\/span><\/p>\n<p>Or, let&#8217;s say that in your actual spreadsheet, the <strong>Position<\/strong> column had values like &#8220;Product Manager&#8221; and &#8220;Technical Support Manager&#8221;, but you still wanted to email everyone at Microsoft that was some type of manager. In that case you would set the Position criteria to just &#8220;contain&#8221; the word &#8220;manager&#8221;. So:<\/p>\n<p><span style=\"font-family: 'courier new' , 'courier' , monospace;\">Company=Microsoft<\/span><br \/>\n<span style=\"font-family: 'courier new' , 'courier' , monospace;\">Position~Manager<\/span><\/p>\n<p>In these cases, you want rows that match both criteria. So in these cases, the boolean operator should be set to <b>AND<\/b>. You might, however, want to switch to <b>OR<\/b> in certain cases. Let&#8217;s say your spreadsheet has all of your customers but you want to send a campaign to only customers with an email address at a consumer domain, like hotmail.com, yahoo.com, aol.com, and gmail.com. You would enter:<\/p>\n<p><span style=\"font-family: 'courier new' , 'courier' , monospace;\">Email~gmail.com<\/span><br \/>\n<span style=\"font-family: 'courier new' , 'courier' , monospace;\">Email~yahoo.com<\/span><br \/>\n<span style=\"font-family: 'courier new' , 'courier' , monospace;\">Email~hotmail.com<\/span><br \/>\n<span style=\"font-family: 'courier new' , 'courier' , monospace;\">Email~aol.com<\/span><\/p>\n<p>And you would set the boolean dropdown to <b>OR<\/b>. Meaning you want to send to everyone where <strong>Email<\/strong> contains gmail.com <span style=\"color: #3366ff;\"><strong>OR<\/strong><\/span> <strong>Email<\/strong> contains yahoo.com <span style=\"color: #3366ff;\"><strong>OR<\/strong><\/span> <strong>Email<\/strong> contains hotmail.com <span style=\"color: #3366ff;\"><strong>OR<\/strong><\/span> <strong>Email<\/strong> contains aol.com.<\/p>\n<p>As another example, let&#8217;s go back to our spreadsheet containing the <strong>Company<\/strong>\u00a0column. You&#8217;re sending a mail merge campaign to executives at billion-dollar tech companies, so you want to only send to people where <strong>Company<\/strong> is either Microsoft, Apple, or Facebook. You would enter:<\/p>\n<p><span style=\"font-family: 'courier new' , 'courier' , monospace;\">Company=Microsoft<\/span><br \/>\n<span style=\"font-family: 'courier new' , 'courier' , monospace;\">Company=Apple<\/span><br \/>\n<span style=\"font-family: 'courier new' , 'courier' , monospace;\">Company=Facebook<\/span><\/p>\n<p>and set the boolean dropdown to <b>OR<\/b>. If you entered this criteria and set the boolean dropdown to <b>AND<\/b>, you would get an error saying that no rows could be selected, <em>since there isn&#8217;t a single row where the <strong>Company<\/strong> is equal to all three of those values, as that would be impossible<\/em>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When connecting to a Google Sheets spreadsheet to send a mail merge campaign, you can now specify filter criteria to pull only certain email addresses that match the\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[19,4254,4261],"tags":[],"class_list":["post-322","post","type-post","status-publish","format-standard","hentry","category-gmail-mail-merge","category-gmail-tips-and-tricks","category-google-sheets"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Send a mail merge campaign to just selected rows of a spreadsheet<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Send a mail merge campaign to just selected rows of a spreadsheet\" \/>\r\n<meta property=\"og:description\" content=\"When connecting to a Google Sheets spreadsheet to send a mail merge campaign, you can now specify filter criteria to pull only certain email addresses that match the\u2026\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/\" \/>\r\n<meta property=\"og:site_name\" content=\"GMass Blog\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GmailMailMerge\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-07-11T05:01:00+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-08-30T00:26:26+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering.png\" \/>\r\n<meta name=\"author\" content=\"Ajay Goel\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@PartTimeSnob\" \/>\r\n<meta name=\"twitter:site\" content=\"@GMassForGmail\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ajay Goel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/\"},\"author\":{\"name\":\"Ajay Goel\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"headline\":\"Send a mail merge campaign to just selected rows of a spreadsheet\",\"datePublished\":\"2016-07-11T05:01:00+00:00\",\"dateModified\":\"2025-08-30T00:26:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/\"},\"wordCount\":770,\"commentCount\":77,\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/jamout-filtering.png\",\"articleSection\":[\"Gmail Mail Merge\",\"Gmail Tips and Tricks\",\"Google Sheets\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/\",\"name\":\"Send a mail merge campaign to just selected rows of a spreadsheet\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/jamout-filtering.png\",\"datePublished\":\"2016-07-11T05:01:00+00:00\",\"dateModified\":\"2025-08-30T00:26:26+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/jamout-filtering.png\",\"contentUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/jamout-filtering.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/send-mail-merge-to-selected-rows-spreadsheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Send a mail merge campaign to just selected rows of a spreadsheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\",\"name\":\"GMass Blog\",\"description\":\"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\",\"name\":\"Ajay Goel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"caption\":\"Ajay Goel\"},\"description\":\"Ajay is the founder of GMass and has been developing email sending software for 20 years.\",\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/PartTimeSnob\",\"https:\\\/\\\/x.com\\\/PartTimeSnob\"],\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/author\\\/ajay-goel\\\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Send a mail merge campaign to just selected rows of a spreadsheet","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/","og_locale":"en_US","og_type":"article","og_title":"Send a mail merge campaign to just selected rows of a spreadsheet","og_description":"When connecting to a Google Sheets spreadsheet to send a mail merge campaign, you can now specify filter criteria to pull only certain email addresses that match the\u2026","og_url":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/","og_site_name":"GMass Blog","article_publisher":"https:\/\/www.facebook.com\/GmailMailMerge\/","article_published_time":"2016-07-11T05:01:00+00:00","article_modified_time":"2025-08-30T00:26:26+00:00","og_image":[{"url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering.png","type":"","width":"","height":""}],"author":"Ajay Goel","twitter_card":"summary_large_image","twitter_creator":"@PartTimeSnob","twitter_site":"@GMassForGmail","twitter_misc":{"Written by":"Ajay Goel","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/#article","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/"},"author":{"name":"Ajay Goel","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"headline":"Send a mail merge campaign to just selected rows of a spreadsheet","datePublished":"2016-07-11T05:01:00+00:00","dateModified":"2025-08-30T00:26:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/"},"wordCount":770,"commentCount":77,"image":{"@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering.png","articleSection":["Gmail Mail Merge","Gmail Tips and Tricks","Google Sheets"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/","url":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/","name":"Send a mail merge campaign to just selected rows of a spreadsheet","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering.png","datePublished":"2016-07-11T05:01:00+00:00","dateModified":"2025-08-30T00:26:26+00:00","author":{"@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"breadcrumb":{"@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/#primaryimage","url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering.png","contentUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/04\/jamout-filtering.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gmass.co\/blog\/"},{"@type":"ListItem","position":2,"name":"Send a mail merge campaign to just selected rows of a spreadsheet"}]},{"@type":"WebSite","@id":"https:\/\/www.gmass.co\/blog\/#website","url":"https:\/\/www.gmass.co\/blog\/","name":"GMass Blog","description":"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gmass.co\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8","name":"Ajay Goel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","caption":"Ajay Goel"},"description":"Ajay is the founder of GMass and has been developing email sending software for 20 years.","sameAs":["https:\/\/twitter.com\/PartTimeSnob","https:\/\/x.com\/PartTimeSnob"],"url":"https:\/\/www.gmass.co\/blog\/author\/ajay-goel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/comments?post=322"}],"version-history":[{"count":6,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/322\/revisions"}],"predecessor-version":[{"id":25630,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/322\/revisions\/25630"}],"wp:attachment":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media?parent=322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/categories?post=322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/tags?post=322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}