Difference between revisions of "18xx Dream Spreadsheet Authorization Issue"

From BOARD18 Project WIKI
Jump to navigation Jump to search
(→‎Step 3: initial)
(Revision for scripts that include @OnlyCurrentDoc in a comment at the start of the script.)
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
__NOTOC__
__NOTOC__
Google has created a very strict authorization requirement for Google Apps Scripts
Google has created a strict authorization requirement for Google Apps Scripts
running on Google sheets. This can be partially circumvented by associating the
running on Google sheets. The script author can partially circumvent this by  
spreadsheet with a Project ID and requesting that the script be verified by  
including '''@OnlyCurrentDoc''' in a comment at the start of the script.
'''Google Cloud Platform/API Trust & Safety'''. I tried to do this but then I found out that
each copy of a Google sheet gets a new Project ID when copied, so the Google
verification of the scripts on the original sheet does not apply to the copies! Grrr...


So the Dream Spreadsheets contain '''unverified apps''' and you must navigate a extensive
Because of this, these Dream Spreadsheets are considered by Google to
contain '''unverified apps''' and you must navigate an
authorization process '''the first time''' that you press the '''New Tab''' button
authorization process '''the first time''' that you press the '''New Tab''' button
on a newly copied sheet.
on a newly copied sheet.


The following is a step by step guide to this process:
The following is a three step guide to this process:


== Step 1 ==
== Step 1 ==
Line 21: Line 19:
== Step 2 ==
== Step 2 ==
[[File:Auth02.png|frame]]
[[File:Auth02.png|frame]]
The '''Sign In - Google Accounts''' box will be displayed next. <br>Your Google account should appear there. <br>
The '''Choose an Account''' box will be displayed next. <br>Your Google account should appear there. <br>
Click on your account to continue.
Click on your account to continue.
<br clear=all>
<br clear=all>


== Step 3 ==
== Step 3 ==
[[File:Auth03.png|frame]]
[[File:Auth03a.png|frame]]
This box is designed to scare you off. Don't let it.<br>Click on '''advanced''' in the lower left corner.
This box is Google's last attempt to scare you off. Don't let it.<br>Just click on '''Allow''' in the lower right corner.
 
<br clear=all>
<br clear=all>


== Step 4 ==
That's it. You now have access to the '''New Tab''' script and you will not have to
[[File:Auth04.png|frame]]
bother with this process again on this spreadsheet.
<br clear=all>
== Step 5 ==
[[File:Auth05.png|frame]]
<br clear=all>
== Step 6 ==
[[File:Auth06.png|frame]]

Latest revision as of 09:47, 14 November 2018

Google has created a strict authorization requirement for Google Apps Scripts running on Google sheets. The script author can partially circumvent this by including @OnlyCurrentDoc in a comment at the start of the script.

Because of this, these Dream Spreadsheets are considered by Google to contain unverified apps and you must navigate an authorization process the first time that you press the New Tab button on a newly copied sheet.

The following is a three step guide to this process:

Step 1

Auth01.png

The first time that the New Tab button is pressed the pop up box shown to the right will be displayed.
Simply press the continue button to proceed.

Step 2

Auth02.png

The Choose an Account box will be displayed next.
Your Google account should appear there.
Click on your account to continue.

Step 3

Auth03a.png

This box is Google's last attempt to scare you off. Don't let it.
Just click on Allow in the lower right corner.

That's it. You now have access to the New Tab script and you will not have to bother with this process again on this spreadsheet.