Why you have to enter your Google Sheet ID manually
Posted: Mon Dec 09, 2024 4:49 am
The alternate interface you’ll be presented with if GMass can’t list your Sheets because of an administrative block
…it’s because your Google Workspace Admin has blocked third-party apps like GMass from accessing your Google Drive. Therefore, we can’t display the normal interface where you can choose your Google Sheets from a pretty drop-down menu — but we do generate this alternate interface so that you can still connect to your Sheet without losing any functionality.
But, you can still connect to your Sheet! There’s just a little bit of extra work involved.
The steps are:
Pull up your Sheet in a separate browser tab.
Find the Sheet’s ID in the URL and copy it to your clipboard.
Paste it into the GMass field.
Pull up your Sheet in a separate browser tab.
Navigate to your Sheet just like you would anytime you want to estonia phone number library see or edit your Sheet. Start at sheets.google.com if you’re not sure how to get to your Sheet. Once you’re looking at your Sheet, your browser will look like this:
We’re interested in the URL for the Sheet, and specifically the part of the URL that represents your Sheet’s ID. If the URL is:
then the Sheet’s ID is:
1adSMhi3qqfWWk8f0jpnydSp75gCYgQdwu0fGqZOIUSw
Copy it to your clipboard
Copy that to your computer’s clipboard using CTRL+C (Windows) or CMD+C (Mac).
Paste it into GMass
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 — just like in the regular interface.
That’s it, and now you’re on your way!
Read on if you’re interested in the technical details behind this alternate workflow.
Why isn’t the Google Picker working?
You might notice that if you click the “Choose Sheet” link, you’ll get a screen that looks like this:
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’t have to hunt down your Sheet’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’s not much we can do.
What should my Google Workspace Admin change?
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.
Under “Drive and Docs” settings
…it’s because your Google Workspace Admin has blocked third-party apps like GMass from accessing your Google Drive. Therefore, we can’t display the normal interface where you can choose your Google Sheets from a pretty drop-down menu — but we do generate this alternate interface so that you can still connect to your Sheet without losing any functionality.
But, you can still connect to your Sheet! There’s just a little bit of extra work involved.
The steps are:
Pull up your Sheet in a separate browser tab.
Find the Sheet’s ID in the URL and copy it to your clipboard.
Paste it into the GMass field.
Pull up your Sheet in a separate browser tab.
Navigate to your Sheet just like you would anytime you want to estonia phone number library see or edit your Sheet. Start at sheets.google.com if you’re not sure how to get to your Sheet. Once you’re looking at your Sheet, your browser will look like this:
We’re interested in the URL for the Sheet, and specifically the part of the URL that represents your Sheet’s ID. If the URL is:
then the Sheet’s ID is:
1adSMhi3qqfWWk8f0jpnydSp75gCYgQdwu0fGqZOIUSw
Copy it to your clipboard
Copy that to your computer’s clipboard using CTRL+C (Windows) or CMD+C (Mac).
Paste it into GMass
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 — just like in the regular interface.
That’s it, and now you’re on your way!
Read on if you’re interested in the technical details behind this alternate workflow.
Why isn’t the Google Picker working?
You might notice that if you click the “Choose Sheet” link, you’ll get a screen that looks like this:
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’t have to hunt down your Sheet’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’s not much we can do.
What should my Google Workspace Admin change?
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.
Under “Drive and Docs” settings