{"id":25737,"date":"2025-09-29T06:46:24","date_gmt":"2025-09-29T06:46:24","guid":{"rendered":"https:\/\/www.gmass.co\/blog\/?p=25737"},"modified":"2025-11-18T08:51:49","modified_gmt":"2025-11-18T08:51:49","slug":"connect-google-sheet","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/","title":{"rendered":"How to Connect a Google Sheet to GMass (Full Guide)"},"content":{"rendered":"<p>Odds are, you\u2019re using GMass to run a <a href=\"https:\/\/www.gmass.co\/blog\/google-sheets-mail-merge\/\">Google Sheets mail merge<\/a>\u00a0\u2014 where you connect your Google Sheet of contacts to a campaign and build your campaign from there.<\/p>\n<p>So let\u2019s <strong>make sure we connect everything perfectly<\/strong>.<\/p>\n<p>In this guide, I\u2019ll walk you through the <strong>entire process of connecting a Google Sheet to a GMass campaign<\/strong>.<\/p>\n<h2 id=\"connect-a-google-she-gbmu\">Connect a Google Sheet to GMass: Table of Contents<\/h2>\n<ul>\n<li><a href=\"#step-1-format-your-s-bnaw\">Step 1: Format Your Spreadsheet<\/a><\/li>\n<li><a href=\"#step-2-click-to-conn-vuay\">Step 2: Click to Connect<\/a><\/li>\n<li><a href=\"#step-3-choose-your-g-czzc\">Step 3: Choose Your Google Sheet<\/a><\/li>\n<li><a href=\"#step-4-choose-your-w-buox\">Step 4: Choose Your Worksheet (Optional)<\/a><\/li>\n<li id=\"step-1-format-your-s-bnaw\"><a href=\"#step-5-optional-sett-yofw\">Step 5: Optional Settings<\/a><\/li>\n<li><a href=\"#step-6-connecting-to-atjc\">Step 6: Connecting to the Spreadsheet<\/a><\/li>\n<li><a href=\"#now-you-re-set-to-cr-kvww\">Now You\u2019re Set to Create Your Campaign<\/a><\/li>\n<\/ul>\n<h2>Step 1: Format Your Spreadsheet<\/h2>\n<p>First, you\u2019ll need to create a Google Sheet with everyone on your mailing list.<\/p>\n<p>\u26a0\ufe0f <strong>Important: This needs to be a Google Sheets file, not an XLS or CSV file you&#8217;re viewing inside Google Sheets.<\/strong><\/p>\n<p>You can check out our in-depth guide on best practices for <a href=\"https:\/\/www.gmass.co\/blog\/format-google-sheet\/\">formatting a Google Sheet for mail merge<\/a>\u00a0campaigns, but for now, here are some of the key basics to remember.<\/p>\n<ul>\n<li>The<strong>\u00a0first row<\/strong>\u00a0should contain <strong>column header names<\/strong>, like <em>FirstName<\/em>, <em>LastName<\/em>, <em>EmailAddress<\/em>, <em>Company<\/em>, etc. For best results, the headers <strong>shouldn\u2019t contain spaces or special characters<\/strong>;\u00a0stick with numbers and letters for your column headings.<\/li>\n<li>The <strong>actual data<\/strong>\u00a0should start on the <strong>second row<\/strong>.<\/li>\n<li>At least<strong>\u00a0one column must contain email addresses<\/strong>.\u00a0GMass will auto-detect this column and use it as the recipient address column.<\/li>\n<\/ul>\n<p>For example, here\u2019s the Google Sheet I\u2019ll be using as my data file:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18430\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2.png\" alt=\"Google sheet\" width=\"1026\" height=\"385\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2.png 1026w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-300x113.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1024x384.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-768x288.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-24x9.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-36x14.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-48x18.png 48w\" sizes=\"auto, (max-width: 1026px) 100vw, 1026px\" \/><\/a><\/p>\n<p><em><strong>Note: <\/strong><\/em><em>If your sheet has multiple columns with addresses, keep the column containing the recipient email addresses to the left of the other columns. Here are instructions if you want columns for<\/em> <em><a href=\"https:\/\/www.gmass.co\/blog\/set-cc-and-bcc-fields-in-a-mail-merge-from-a-spreadsheet-column\/\">CCing or BCCing extra recipients on your mail merge emails<\/a><\/em><em id=\"step-2-click-to-conn-vuay\">\u00a0\u2014 that will ensure the right emails wind up in the right inbox.<\/em><\/p>\n<h2>Step 2: Click to Connect<\/h2>\n<p>Head over to Gmail.<\/p>\n<p>If you\u2019ve already signed up for GMass, it\u2019s time to load the mail merge data from your Google Sheet. (If you haven\u2019t, it takes less than a minute. <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/gmass-powerful-mail-merge\/ehomdgjhgmbidokdgicgmdiedadncbgf\">Install the Chrome extension<\/a>\u00a0to get rolling.)<\/p>\n<p>You can load recipient data in <strong>two<\/strong>\u00a0ways:<\/p>\n<p>1. Click the <em>Sheets<\/em>\u00a0button near the search bar to open a dialog window showing a list of Google Sheet files.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23101\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified.png\" alt=\"Connect to Google Sheets icon\" width=\"2004\" height=\"728\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified.png 2004w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified-300x109.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified-1024x372.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified-768x279.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified-1536x558.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified-24x9.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified-36x13.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-connecticon-tinified-48x17.png 48w\" sizes=\"auto, (max-width: 2004px) 100vw, 2004px\" \/><\/a><\/p>\n<p>Or&#8230;<\/p>\n<p>2. Open a new compose window in Gmail, then <a href=\"https:\/\/www.gmass.co\/blog\/new-button-better-workflow\/\">click the new GMass button<\/a>\u00a0in the upper-right corner. (You can connect the Sheet before or after you write your email template draft.)<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23102\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified.png\" alt=\"GMass icon in the compose window\" width=\"1868\" height=\"1100\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified.png 1868w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified-300x177.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified-1024x603.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified-768x452.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified-1536x904.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified-24x14.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified-36x21.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-composeicon-tinified-48x28.png 48w\" sizes=\"auto, (max-width: 1868px) 100vw, 1868px\" \/><\/a><\/p>\n<p>That will bring up a window giving you three different options for the type of list you\u2019d like to connect to your GMass campaign. Choose <strong id=\"step-3-choose-your-g-czzc\">From a Google Sheet<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23103\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified.png\" alt=\"\" width=\"2004\" height=\"1114\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified.png 2004w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified-300x167.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified-1024x569.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified-768x427.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified-1536x854.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified-24x13.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified-36x20.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-fromagooglesheet-tinified-48x27.png 48w\" sizes=\"auto, (max-width: 2004px) 100vw, 2004px\" \/><\/a><\/p>\n<p>Regardless of whether you went with option 1 or option 2, both paths will lead to the same place: A pop-up window where you\u2019ll select your Google Sheet.<\/p>\n<h2>Step 3: Choose Your Google Sheet<\/h2>\n<p>Next up you\u2019ll select the Google Sheet that contains your mailing list.<\/p>\n<p>You have a few options here which are all in place to make sure you can find your Google Sheet no matter where it might be living in Google Drive (and no matter what security restrictions your organization might have in place).<\/p>\n<h3 id=\"the-dropdown-menu-mxao\">The dropdown menu<\/h3>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified.png\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23109\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified.png\" alt=\"The dropdown menu\" width=\"1998\" height=\"1258\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified.png 1998w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified-300x189.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified-1024x645.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified-768x484.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified-1536x967.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-dropdown-tinified-48x30.png 48w\" sizes=\"auto, (max-width: 1998px) 100vw, 1998px\" \/><\/a><\/p>\n<p>We\u2019ll start with the dropdown menu, which is a fast way to choose your Sheet if everything in your account is nice and tidy.<\/p>\n<p>For instance: You\u2019re accessing your own Google Sheet or a Sheet that someone directly shared with you, you don\u2019t put your Google Sheets into folders in your Google Drive, and you don\u2019t have any security restrictions on your account.<\/p>\n<p><strong>In most cases and for most GMass users, your Google Sheet should be here in the dropdown menu<\/strong>. And if it\u2019s the most recent sheet you edited, it should be at the top of the dropdown menu.<\/p>\n<p>The dropdown menu also has a built-in search function, which you can use to search through your Google Sheets as well.<\/p>\n<p><em><strong>Note:<\/strong><\/em><em>\u00a0The drop-down menu won\u2019t show any Excel files that are in your Google Drive. GMass doesn\u2019t connect to an Excel file directly, but you can easily convert your Excel spreadsheet<\/em>\u00a0<em>(or an existing CSV file) to a Google Sheet<\/em>.<\/p>\n<h3 id=\"the-spreadsheet-pick-iiha\">The spreadsheet picker<\/h3>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified.png\" data-rel=\"lightbox-image-5\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23107\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified.png\" alt=\"\" width=\"1998\" height=\"1258\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified.png 1998w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified-300x189.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified-1024x645.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified-768x484.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified-1536x967.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-ssheetpicker-tinified-48x30.png 48w\" sizes=\"auto, (max-width: 1998px) 100vw, 1998px\" \/><\/a><\/p>\n<p>The spreadsheet picker launches Google\u2019s native Drive interface.<\/p>\n<p>This is particularly useful <strong>if you organize your Google Sheets into folders<\/strong>, or if you\u2019re looking for Sheets in <strong>shared folders on your organization\u2019s Google Drive<\/strong>.<\/p>\n<p>You can also use Google\u2019s search function here for an even deeper search into your Google Drive than the search in the GMass dropdown.<\/p>\n<h3 id=\"manual-entry-tdxa\">Manual entry<\/h3>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified.png\" data-rel=\"lightbox-image-6\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23105\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified.png\" alt=\"\" width=\"1998\" height=\"1258\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified.png 1998w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified-300x189.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified-1024x645.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified-768x484.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified-1536x967.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-manualentry-tinified-48x30.png 48w\" sizes=\"auto, (max-width: 1998px) 100vw, 1998px\" \/><\/a><\/p>\n<p>The third way of choosing a Google Sheet is via manual entry.<\/p>\n<p>Here, you\u2019ll <strong>paste in the ID number of a Google Sheet<\/strong>\u00a0(which you can grab from its URL).<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified.png\" data-rel=\"lightbox-image-7\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23110\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified.png\" alt=\"\" width=\"1818\" height=\"242\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified.png 1818w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified-300x40.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified-1024x136.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified-768x102.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified-1536x204.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified-24x3.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified-36x5.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2015\/10\/conngs-spreadsheetid-tinified-48x6.png 48w\" sizes=\"auto, (max-width: 1818px) 100vw, 1818px\" \/><\/a><\/p>\n<p>This allows you to <strong>connect to a Sheet that\u2019s public but hasn\u2019t been shared directly with your account<\/strong>.<\/p>\n<p>(\u201cPublic\u201d is a loose term here as well. Let\u2019s say you have 100 GMass accounts and you want all 100 to be able to use the same Sheet, but don\u2019t want to take the time to share that Sheet with all the accounts. You could make it \u201cpublic\u201d but, of course, only you would know the URL. Then you could paste it in as you connect to campaigns.)<\/p>\n<h3 id=\"interface-for-securi-nppe\">Interface for security-restricted accounts<\/h3>\n<p>While most users will see all three options detailed above, if you\u2019re at a larger organization or one with extremely tight security restrictions, your Google Workspace admins may lock down access to your Google Sheets.<\/p>\n<p>Which means: GMass won\u2019t be able to directly access those Sheets and use them to populate the dropdown menu.<\/p>\n<p>In that case, <strong id=\"step-4-choose-your-w-buox\">you\u2019ll see a different interface<\/strong> where your only option is to enter a Google Sheet ID manually.<\/p>\n<p>You can read more about the security settings that cause this scenario (and how your admins can turn them off) <a href=\"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/\">here<\/a>.<\/p>\n<h2>Step 4: Choose Your Worksheet (Optional)<\/h2>\n<p>If your Google Sheet has multiple worksheets, a <em id=\"step-5-optional-sett-yofw\">worksheets drop-down menu<\/em>\u00a0will appear, which allows you to<strong>\u00a0select the specific worksheet<\/strong>\u00a0you need.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-a-worksheet.png\" data-rel=\"lightbox-image-8\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18434\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-a-worksheet.png\" alt=\"Choose a worksheet\" width=\"703\" height=\"376\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-a-worksheet.png 703w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-a-worksheet-300x160.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-a-worksheet-24x13.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-a-worksheet-36x19.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-a-worksheet-48x26.png 48w\" sizes=\"auto, (max-width: 703px) 100vw, 703px\" \/><\/a><\/p>\n<h2>Step 5: Optional Settings<\/h2>\n<p>Now that you\u2019ve selected your Google Sheet (and worksheet, if applicable), we can look at the other options here in the connection box.<\/p>\n<h3 id=\"filter-rows-jnal\">Filter rows<\/h3>\n<p>Sometimes, you may want to <strong>send emails<\/strong>\u00a0<strong>only to particular recipients<\/strong>\u00a0in your Google Sheet.<\/p>\n<p>In such scenarios, you can <a href=\"https:\/\/www.gmass.co\/blog\/send-mail-merge-to-selected-rows-spreadsheet\/\">filter the rows<\/a>\u00a0that are a part of the campaign by adding <strong>filter criteria<\/strong>\u00a0(name\/value pairs) in the <em>Filter Rows<\/em>\u00a0box under <em>Optional Settings<\/em>. That link has the full details on the notation to use for filters.<\/p>\n<p>In the example below, my Google Sheet has a column called Industry. And I&#8217;ve decided to send emails only to customers who have \u201cTechnology\u201d in that column.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Filter-rows.png\" data-rel=\"lightbox-image-9\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18441\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Filter-rows.png\" alt=\"Filter rows\" width=\"739\" height=\"607\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Filter-rows.png 739w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Filter-rows-300x246.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Filter-rows-24x20.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Filter-rows-36x30.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Filter-rows-48x39.png 48w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/a><\/p>\n<p><em>Don&#8217;t worry about filtering out addresses who have unsubscribed, bounced, or thrown up an address block on past campaigns. GMass automatically suppresses your messages to them.<\/em><\/p>\n<h3 id=\"keep-duplicates-axui\">Keep duplicates<\/h3>\n<p>Your spreadsheet might have some rows with duplicate email addresses. And when you&#8217;re sending your mail merge campaign, you may want those <strong>duplicate email addresses to be filtered out<\/strong>. (We assume you will, so that\u2019s the default setting.)<\/p>\n<p>However, sometimes you <strong>may want to send duplicate emails<\/strong>.<\/p>\n<p>For example, say you\u2019re in charge of the after-school activities program, and you\u2019ve got to email the parents of children who registered for this program.<\/p>\n<p><em>Now, what if one of the parents has registered multiple children?<\/em><\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Duplicates.png\" data-rel=\"lightbox-image-10\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18435\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Duplicates.png\" alt=\"Duplicates\" width=\"768\" height=\"477\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Duplicates.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Duplicates-300x186.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Duplicates-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Duplicates-36x22.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Duplicates-48x30.png 48w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a><\/p>\n<p>In the spreadsheet above, <em>Joan Smith<\/em>\u00a0has three children registered for three different classes. Here, you\u2019ll want <em>Joan Smith<\/em>\u00a0to receive three different personalized emails, one with each child\u2019s class registration information.<\/p>\n<p>To send duplicate emails, tick the <strong>Keep duplicate emails<\/strong>\u00a0checkbox.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Downward-arrow-2.png\" data-rel=\"lightbox-image-11\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18440\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Downward-arrow-2.png\" alt=\"Downward arrow\" width=\"700\" height=\"579\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Downward-arrow-2.png 700w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Downward-arrow-2-300x248.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Downward-arrow-2-24x20.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Downward-arrow-2-36x30.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Downward-arrow-2-48x40.png 48w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<h3 id=\"update-sheet-with-re-iwmw\">Update Sheet with reporting data<\/h3>\n<p>GMass has great <a href=\"https:\/\/www.gmass.co\/features\/reporting\">reporting options<\/a>\u00a0\u2014 ones that are far easier to use and access than Google Analytics.<\/p>\n<p>One of the <strong>most convenient ways<\/strong>\u00a0to see how your campaign is doing? GMass can automatically update your Google Sheet after you\u2019ve sent the campaign and your email recipients <strong>open<\/strong>, <strong>click<\/strong>, <strong>reply<\/strong>, or take other engagement actions on your email.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1.png\" data-rel=\"lightbox-image-12\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18442\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1.png\" alt=\"Google sheet 2\" width=\"1030\" height=\"367\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1.png 1030w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1-300x107.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1-1024x365.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1-768x274.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1-24x9.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1-36x13.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-2-1-48x17.png 48w\" sizes=\"auto, (max-width: 1030px) 100vw, 1030px\" \/><\/a><\/p>\n<p>To have GMass create a few additional columns in your Sheet to add the email tracking data, tick the <strong>Update Sheet with reporting data<\/strong>\u00a0checkbox.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Update-sheet-checkbox.png\" data-rel=\"lightbox-image-13\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18443\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Update-sheet-checkbox.png\" alt=\"Update sheet checkbox\" width=\"718\" height=\"612\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Update-sheet-checkbox.png 718w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Update-sheet-checkbox-300x256.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Update-sheet-checkbox-24x20.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Update-sheet-checkbox-36x31.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Update-sheet-checkbox-48x41.png 48w\" sizes=\"auto, (max-width: 718px) 100vw, 718px\" \/><\/a><\/p>\n<p><em><strong>Note: <\/strong><\/em><em>If you haven\u2019t already given permission to write to your Sheets, a pop-up dialog box will appear asking you to grant that permission. Check out<\/em> <em id=\"step-6-connecting-to-atjc\"><a href=\"https:\/\/www.gmass.co\/blog\/update-google-sheet-campaign-data\/\">our guide to updating your Google Sheet with campaign data<\/a><\/em><em>\u00a0for more details.<\/em><\/p>\n<h2>Step 6: Connecting to the Spreadsheet<\/h2>\n<p>After clicking the <strong>CONNECT TO SPREADSHEET<\/strong>\u00a0button, GMass will read the email addresses and other data from your spreadsheet. It\u2019ll then load the list of recipients into the <em>To<\/em>\u00a0field.<\/p>\n<p><em><strong>Note: <\/strong><\/em><em id=\"now-you-re-set-to-cr-kvww\">In GMass, each email sent is delivered as an individual email \u2014 this means that you don\u2019t have to add email addresses in the BCC field to preserve recipients\u2019 privacy.<\/em><\/p>\n<p>Now that you&#8217;ve connected one Google Sheet, you could <a href=\"https:\/\/www.gmass.co\/blog\/multiple-lists-multi-merge\/\">also connect multiple lists in other Google Sheets<\/a>\u00a0for your campaign.<\/p>\n<h2>Now You\u2019re Set to Create Your Campaign<\/h2>\n<p>Well done! <strong>You\u2019ve now connected your Google Sheet to your campaign<\/strong>\u00a0and <strong>successfully set up any optional settings<\/strong>\u00a0like filtering, handling duplicate addresses, and updating the sheet with reporting data.<\/p>\n<p>Now <strong>you\u2019re ready to get to work on your campaign<\/strong>.<\/p>\n<p>One thing you might want to check out next: <a href=\"https:\/\/www.gmass.co\/blog\/dynamic-lists\/\">Dynamic lists<\/a>. This will enable you to <strong>use your Google Sheet as the \u201csource of truth\u201d for your campaign<\/strong>\u00a0where any addresses you add or remove from the sheet are added or removed from the campaign.<\/p>\n<p>And if you haven\u2019t signed up for GMass yet\u2026 give it a try!<\/p>\n<p>You can <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/gmass-powerful-mail-merge\/ehomdgjhgmbidokdgicgmdiedadncbgf\">get started for free<\/a>\u00a0\u2014 <strong>no credit card required!<\/strong>\u00a0\u2014 and start connecting your Google Sheets and <strong>sending campaigns in a matter of minutes<\/strong>.<\/p>\n<p>Join the nearly <strong>400,000 people<\/strong>\u00a0who rely on GMass for everything from cold outreach to newsletters and see why they give GMass an average of <strong>4.8 out of 5 stars<\/strong>\u00a0across tens of thousands of reviews.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Odds are, you\u2019re using GMass to run a Google Sheets mail merge\u00a0\u2014 where you connect your Google Sheet of contacts to a campaign and build your campaign from\u2026<\/p>\n","protected":false},"author":29,"featured_media":25741,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[19,26,4261],"tags":[],"class_list":["post-25737","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gmail-mail-merge","category-gmass","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>How to Connect a Google Sheet to GMass (Full Guide)<\/title>\r\n<meta name=\"description\" content=\"A complete guide to the Google Sheet connection box in GMass, including how to use the spreadsheet picker and optional settings.\" \/>\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\/connect-google-sheet\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to Connect a Google Sheet to GMass (Full Guide)\" \/>\r\n<meta property=\"og:description\" content=\"A complete guide to the Google Sheet connection box in GMass, including how to use the spreadsheet picker and optional settings.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/\" \/>\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=\"2025-09-29T06:46:24+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-11-18T08:51:49+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/09\/connectsheet-feat-tinified.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"2002\" \/>\r\n\t<meta property=\"og:image:height\" content=\"934\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"Sam Greenspan\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@GMassForGmail\" \/>\r\n<meta name=\"twitter:site\" content=\"@GMassForGmail\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sam Greenspan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 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\\\/connect-google-sheet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/\"},\"author\":{\"name\":\"Sam Greenspan\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/de82c1ac2f78713b569bb57bfb313c98\"},\"headline\":\"How to Connect a Google Sheet to GMass (Full Guide)\",\"datePublished\":\"2025-09-29T06:46:24+00:00\",\"dateModified\":\"2025-11-18T08:51:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/\"},\"wordCount\":1684,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/connectsheet-feat-tinified.png\",\"articleSection\":[\"Gmail Mail Merge\",\"GMass\",\"Google Sheets\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/\",\"name\":\"How to Connect a Google Sheet to GMass (Full Guide)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/connectsheet-feat-tinified.png\",\"datePublished\":\"2025-09-29T06:46:24+00:00\",\"dateModified\":\"2025-11-18T08:51:49+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/de82c1ac2f78713b569bb57bfb313c98\"},\"description\":\"A complete guide to the Google Sheet connection box in GMass, including how to use the spreadsheet picker and optional settings.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/connectsheet-feat-tinified.png\",\"contentUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/connectsheet-feat-tinified.png\",\"width\":2002,\"height\":934},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/connect-google-sheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Connect a Google Sheet to GMass (Full Guide)\"}]},{\"@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\\\/de82c1ac2f78713b569bb57bfb313c98\",\"name\":\"Sam Greenspan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g\",\"caption\":\"Sam Greenspan\"},\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/author\\\/sam_greenspan\\\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Connect a Google Sheet to GMass (Full Guide)","description":"A complete guide to the Google Sheet connection box in GMass, including how to use the spreadsheet picker and optional settings.","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\/connect-google-sheet\/","og_locale":"en_US","og_type":"article","og_title":"How to Connect a Google Sheet to GMass (Full Guide)","og_description":"A complete guide to the Google Sheet connection box in GMass, including how to use the spreadsheet picker and optional settings.","og_url":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/","og_site_name":"GMass Blog","article_publisher":"https:\/\/www.facebook.com\/GmailMailMerge\/","article_published_time":"2025-09-29T06:46:24+00:00","article_modified_time":"2025-11-18T08:51:49+00:00","og_image":[{"width":2002,"height":934,"url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/09\/connectsheet-feat-tinified.png","type":"image\/png"}],"author":"Sam Greenspan","twitter_card":"summary_large_image","twitter_creator":"@GMassForGmail","twitter_site":"@GMassForGmail","twitter_misc":{"Written by":"Sam Greenspan","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/#article","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/"},"author":{"name":"Sam Greenspan","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/de82c1ac2f78713b569bb57bfb313c98"},"headline":"How to Connect a Google Sheet to GMass (Full Guide)","datePublished":"2025-09-29T06:46:24+00:00","dateModified":"2025-11-18T08:51:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/"},"wordCount":1684,"commentCount":0,"image":{"@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/09\/connectsheet-feat-tinified.png","articleSection":["Gmail Mail Merge","GMass","Google Sheets"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gmass.co\/blog\/connect-google-sheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/","url":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/","name":"How to Connect a Google Sheet to GMass (Full Guide)","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/#primaryimage"},"image":{"@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/09\/connectsheet-feat-tinified.png","datePublished":"2025-09-29T06:46:24+00:00","dateModified":"2025-11-18T08:51:49+00:00","author":{"@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/de82c1ac2f78713b569bb57bfb313c98"},"description":"A complete guide to the Google Sheet connection box in GMass, including how to use the spreadsheet picker and optional settings.","breadcrumb":{"@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gmass.co\/blog\/connect-google-sheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/#primaryimage","url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/09\/connectsheet-feat-tinified.png","contentUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/09\/connectsheet-feat-tinified.png","width":2002,"height":934},{"@type":"BreadcrumbList","@id":"https:\/\/www.gmass.co\/blog\/connect-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gmass.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Connect a Google Sheet to GMass (Full Guide)"}]},{"@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\/de82c1ac2f78713b569bb57bfb313c98","name":"Sam Greenspan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g","caption":"Sam Greenspan"},"url":"https:\/\/www.gmass.co\/blog\/author\/sam_greenspan\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/25737","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\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/comments?post=25737"}],"version-history":[{"count":4,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/25737\/revisions"}],"predecessor-version":[{"id":25798,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/25737\/revisions\/25798"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media\/25741"}],"wp:attachment":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media?parent=25737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/categories?post=25737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/tags?post=25737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}