{"id":19383,"date":"2022-02-05T10:51:15","date_gmt":"2022-02-05T10:51:15","guid":{"rendered":"https:\/\/www.gmass.co\/blog\/?p=19383"},"modified":"2022-02-05T17:53:12","modified_gmt":"2022-02-05T17:53:12","slug":"enter-your-google-sheet-id-manually","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/","title":{"rendered":"Why you have to enter your Google Sheet ID manually"},"content":{"rendered":"<p>If you go to connect to your Google Sheet only to find a strange dialog box that looks like this&#8230;<\/p>\n<figure id=\"attachment_19401\" aria-describedby=\"caption-attachment-19401\" style=\"width: 912px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/launch-picker-web.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19401 size-full\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/launch-picker-web.png\" alt=\"\" width=\"912\" height=\"797\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/launch-picker-web.png 912w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/launch-picker-web-300x262.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/launch-picker-web-768x671.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/launch-picker-web-24x21.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/launch-picker-web-36x31.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/launch-picker-web-48x42.png 48w\" sizes=\"auto, (max-width: 912px) 100vw, 912px\" \/><\/a><figcaption id=\"caption-attachment-19401\" class=\"wp-caption-text\">The alternate interface you&#8217;ll be presented with if GMass can&#8217;t list your Sheets because of an administrative block<\/figcaption><\/figure>\n<p>&#8230;it&#8217;s because your <strong>Google Workspace Admin has blocked third-party apps<\/strong> like GMass from accessing your Google Drive. Therefore, we can&#8217;t display the normal interface where you can choose your Google Sheets from a pretty drop-down menu \u2014 but we do generate this alternate interface so that you can still connect to your Sheet without losing any functionality.<\/p>\n<p><strong>But, you can still connect to your Sheet!<\/strong> There&#8217;s just a little bit of extra work involved.<\/p>\n<h2>The steps are:<\/h2>\n<ol>\n<li>Pull up your Sheet in a separate browser tab.<\/li>\n<li>Find the Sheet&#8217;s ID in the URL and copy it to your clipboard.<\/li>\n<li>Paste it into the GMass field.<\/li>\n<\/ol>\n<h2>Pull up your Sheet in a separate browser tab.<\/h2>\n<p>Navigate to your Sheet just like you would anytime you want to see or edit your Sheet. Start at sheets.google.com if you&#8217;re not sure how to get to your Sheet. Once you&#8217;re looking at your Sheet, your browser will look like this:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/find-sheet-id-web.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-19402\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/find-sheet-id-web-1024x831.png\" alt=\"\" width=\"640\" height=\"519\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/find-sheet-id-web-1024x831.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/find-sheet-id-web-300x243.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/find-sheet-id-web-768x623.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/find-sheet-id-web-24x19.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/find-sheet-id-web-36x29.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/find-sheet-id-web-48x39.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/find-sheet-id-web.png 1112w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>We&#8217;re interested in the URL for the Sheet, and specifically the part of the URL that represents your Sheet&#8217;s ID. If the URL is:<\/p>\n<pre><span style=\"font-family: 'courier new', courier, monospace;\">https:\/\/docs.google.com\/spreadsheets\/d\/1adSMhi3qqfWWk8f0jpnydSp75gCYgQdwu0fGqZOIUSw\/edit#gid=0<\/span><\/pre>\n<p>then the Sheet&#8217;s ID is:<\/p>\n<pre><span style=\"font-family: 'courier new', courier, monospace;\">1adSMhi3qqfWWk8f0jpnydSp75gCYgQdwu0fGqZOIUSw<\/span><\/pre>\n<h2>Copy it to your clipboard<\/h2>\n<p>Copy that to your computer&#8217;s clipboard using CTRL+C (Windows) or CMD+C (Mac).<\/p>\n<h2>Paste it into GMass<\/h2>\n<p>Now all you need to do is paste it into the GMass field in Gmail, and GMass will load the specific worksheets in that Sheet and ask you to choose \u2014 just like in the regular interface.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/paste-sheet-id-web.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19403 size-full\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/paste-sheet-id-web.png\" alt=\"\" width=\"882\" height=\"889\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/paste-sheet-id-web.png 882w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/paste-sheet-id-web-298x300.png 298w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/paste-sheet-id-web-150x150.png 150w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/paste-sheet-id-web-768x774.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/paste-sheet-id-web-24x24.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/paste-sheet-id-web-36x36.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/paste-sheet-id-web-48x48.png 48w\" sizes=\"auto, (max-width: 882px) 100vw, 882px\" \/><\/a><\/p>\n<p><em>That&#8217;s it, and now you&#8217;re on your way!<\/em><\/p>\n<p>Read on if you&#8217;re interested in the technical details behind this alternate workflow.<\/p>\n<h2>Why isn&#8217;t the Google Picker working?<\/h2>\n<p>You might notice that if you click the &#8220;Choose Sheet&#8221; link, you&#8217;ll get a screen that looks like this:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/picker-error-web.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-19404\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/picker-error-web-1024x651.png\" alt=\"\" width=\"640\" height=\"407\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/picker-error-web-1024x651.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/picker-error-web-300x191.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/picker-error-web-768x488.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/picker-error-web-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/picker-error-web-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/picker-error-web-48x31.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/picker-error-web.png 1364w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>GMass uses the Google Picker (to work around Google Drive access restrictions that your Google Workspace Admin has imposed) to let you pick a file, and when you are able to pick a file, you don&#8217;t have to hunt down your Sheet&#8217;s ID manually and copy\/paste it. Recently, though, it seems that the Google Picker has stopped working, and until we see an update from Google about it, there&#8217;s not much we can do.<\/p>\n<h2>What should my Google Workspace Admin change?<\/h2>\n<p>If you want to see the normal interface where you can choose your Sheet from the standard dropdown menu, your Google Workspace Admin needs to lift the restrictions in place on your Google Drive account. There are two places inside the Google Admin Console where restrictions on Drive may be in place.<\/p>\n<h3>Under &#8220;Drive and Docs&#8221; settings<\/h3>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web.png\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19387 size-large\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web-1001x1024.png\" alt=\"\" width=\"640\" height=\"655\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web-1001x1024.png 1001w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web-293x300.png 293w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web-768x785.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web-1502x1536.png 1502w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web-24x24.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web-36x36.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web-48x48.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-web.png 1899w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Change OFF to ON<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-allow-web-1.png\" data-rel=\"lightbox-image-5\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19397 size-large\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-allow-web-1-1024x230.png\" alt=\"\" width=\"640\" height=\"144\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-allow-web-1-1024x230.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-allow-web-1-300x67.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-allow-web-1-768x173.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-allow-web-1-24x5.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-allow-web-1-36x8.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-allow-web-1-48x11.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/drive-and-docs-allow-web-1.png 1129w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Hit SAVE.<\/p>\n<h3>Under &#8220;API controls&#8221; settings<\/h3>\n<p>Go to third party access.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web.png\" data-rel=\"lightbox-image-6\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-19388\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web-1024x748.png\" alt=\"\" width=\"640\" height=\"468\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web-1024x748.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web-300x219.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web-768x561.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web-1536x1122.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web-24x18.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web-36x26.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web-48x35.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/manage-third-party-app-access-web.png 1898w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Under Google services, go to &#8220;View list&#8221;<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web.png\" data-rel=\"lightbox-image-7\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-19389\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web-1024x492.png\" alt=\"\" width=\"640\" height=\"308\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web-1024x492.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web-300x144.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web-768x369.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web-1536x738.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web-24x12.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web-36x17.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web-48x23.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/google-services-view-list-web.png 1898w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Select Drive and change it to Unrestricted if it&#8217;s currently Restricted.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/change-drive-access-web.png\" data-rel=\"lightbox-image-8\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19390 size-large\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/change-drive-access-web-1024x919.png\" alt=\"\" width=\"640\" height=\"574\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/change-drive-access-web-1024x919.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/change-drive-access-web-300x269.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/change-drive-access-web-768x689.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/change-drive-access-web-24x22.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/change-drive-access-web-36x32.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/change-drive-access-web-48x43.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/change-drive-access-web.png 1467w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<h3>Lastly, you can take one final step and whitelist GMass<\/h3>\n<p>For good measure, you can &#8220;whitelist&#8221; GMass by forcing it to be a trusted app. However, even making GMass &#8220;trusted&#8221; doesn&#8217;t avoid all the blocks that your administrator has in place. Trusting GMass will not override the &#8220;Drive and Docs&#8221; setting above that allows access to the Drive SDK. As long as the Drive SDK API is disabled, the alternate Sheets interface will show in GMass, even if GMass is trusted. However, whitelisting GMass will solve an issue is if Google Drive is marked &#8220;Restricted&#8221; under &#8220;API Controls.&#8221; If Google Drive is &#8220;restricted&#8221; here, then the only way to use GMass with Sheets is to put in an exception for GMass by &#8220;trusting&#8221; it specifically.<\/p>\n<p>To trust GMass:<\/p>\n<p>1. Choose to &#8220;View list&#8221; under Configured apps.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web.png\" data-rel=\"lightbox-image-9\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-19391\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web-1024x463.png\" alt=\"\" width=\"640\" height=\"289\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web-1024x463.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web-300x136.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web-768x348.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web-1536x695.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web-24x11.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web-36x16.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web-48x22.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/view-third-party-apps-web.png 1898w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>2. Then go to Add app and search by OAuth App Name.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1.png\" data-rel=\"lightbox-image-10\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19398 size-large\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1-1024x464.png\" alt=\"\" width=\"640\" height=\"290\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1-1024x464.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1-300x136.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1-768x348.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1-1536x696.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1-24x11.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1-36x16.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1-48x22.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/add-third-party-app-web-1.png 1898w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>3. Then just search for &#8220;gmass,&#8221; and choose the first &#8220;GMass&#8221; app that comes up.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1.png\" data-rel=\"lightbox-image-11\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19399 size-large\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1-1024x579.png\" alt=\"\" width=\"640\" height=\"362\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1-1024x579.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1-300x170.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1-768x434.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1-1536x868.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1-24x14.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1-36x20.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1-48x27.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/search-for-gmass-web-1.png 1645w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>4. Choose the only OAuth Client ID that shows up.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web.png\" data-rel=\"lightbox-image-12\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-19395\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web-1024x621.png\" alt=\"\" width=\"640\" height=\"388\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web-1024x621.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web-300x182.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web-768x466.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web-1536x932.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web-36x22.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web-48x29.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/choose-client-id-web.png 1643w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>5. Set &#8220;GMass&#8221; to &#8220;Trusted.&#8221;<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web.png\" data-rel=\"lightbox-image-13\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-19394\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web-1024x409.png\" alt=\"\" width=\"640\" height=\"256\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web-1024x409.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web-300x120.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web-768x306.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web-1536x613.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web-24x10.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web-36x14.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web-48x19.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/trust-gmass-web.png 1639w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you go to connect to your Google Sheet only to find a strange dialog box that looks like this&#8230; &#8230;it&#8217;s because your Google Workspace Admin has blocked\u2026<\/p>\n","protected":false},"author":2,"featured_media":19412,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[4261,8435],"tags":[],"class_list":["post-19383","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets","category-support"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Why you have to enter your Google Sheet ID manually<\/title>\r\n<meta name=\"description\" content=\"If your Google Workspace Admin blocks third party access to your Google Drive, you&#039;ll be presented with an alternate interface to connect to a Sheet.\" \/>\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\/enter-your-google-sheet-id-manually\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Why you have to enter your Google Sheet ID manually\" \/>\r\n<meta property=\"og:description\" content=\"If your Google Workspace Admin blocks third party access to your Google Drive, you&#039;ll be presented with an alternate interface to connect to a Sheet.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/\" \/>\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=\"2022-02-05T10:51:15+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2022-02-05T17:53:12+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1001\" \/>\r\n\t<meta property=\"og:image:height\" content=\"467\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/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\\\/enter-your-google-sheet-id-manually\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/\"},\"author\":{\"name\":\"Ajay Goel\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"headline\":\"Why you have to enter your Google Sheet ID manually\",\"datePublished\":\"2022-02-05T10:51:15+00:00\",\"dateModified\":\"2022-02-05T17:53:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/\"},\"wordCount\":714,\"commentCount\":4,\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png\",\"articleSection\":[\"Google Sheets\",\"Support\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/\",\"name\":\"Why you have to enter your Google Sheet ID manually\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png\",\"datePublished\":\"2022-02-05T10:51:15+00:00\",\"dateModified\":\"2022-02-05T17:53:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"description\":\"If your Google Workspace Admin blocks third party access to your Google Drive, you'll be presented with an alternate interface to connect to a Sheet.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png\",\"contentUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png\",\"width\":1001,\"height\":467,\"caption\":\"enter Google Sheet ID manually\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/enter-your-google-sheet-id-manually\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why you have to enter your Google Sheet ID manually\"}]},{\"@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":"Why you have to enter your Google Sheet ID manually","description":"If your Google Workspace Admin blocks third party access to your Google Drive, you'll be presented with an alternate interface to connect to a Sheet.","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\/enter-your-google-sheet-id-manually\/","og_locale":"en_US","og_type":"article","og_title":"Why you have to enter your Google Sheet ID manually","og_description":"If your Google Workspace Admin blocks third party access to your Google Drive, you'll be presented with an alternate interface to connect to a Sheet.","og_url":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/","og_site_name":"GMass Blog","article_publisher":"https:\/\/www.facebook.com\/GmailMailMerge\/","article_published_time":"2022-02-05T10:51:15+00:00","article_modified_time":"2022-02-05T17:53:12+00:00","og_image":[{"width":1001,"height":467,"url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png","type":"image\/png"}],"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\/enter-your-google-sheet-id-manually\/#article","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/"},"author":{"name":"Ajay Goel","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"headline":"Why you have to enter your Google Sheet ID manually","datePublished":"2022-02-05T10:51:15+00:00","dateModified":"2022-02-05T17:53:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/"},"wordCount":714,"commentCount":4,"image":{"@id":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png","articleSection":["Google Sheets","Support"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/","url":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/","name":"Why you have to enter your Google Sheet ID manually","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/#primaryimage"},"image":{"@id":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png","datePublished":"2022-02-05T10:51:15+00:00","dateModified":"2022-02-05T17:53:12+00:00","author":{"@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"description":"If your Google Workspace Admin blocks third party access to your Google Drive, you'll be presented with an alternate interface to connect to a Sheet.","breadcrumb":{"@id":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/#primaryimage","url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png","contentUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2022\/02\/Featured-image-enter-Google-Sheet-ID-manually-48kb.png","width":1001,"height":467,"caption":"enter Google Sheet ID manually"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gmass.co\/blog\/enter-your-google-sheet-id-manually\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gmass.co\/blog\/"},{"@type":"ListItem","position":2,"name":"Why you have to enter your Google Sheet ID manually"}]},{"@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\/19383","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=19383"}],"version-history":[{"count":11,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/19383\/revisions"}],"predecessor-version":[{"id":19414,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/19383\/revisions\/19414"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media\/19412"}],"wp:attachment":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media?parent=19383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/categories?post=19383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/tags?post=19383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}