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

From BOARD18 Project WIKI
Jump to navigation Jump to search
(→‎Step 2: initial)
(→‎Step 6: initial)
(4 intermediate revisions by the same user not shown)
Line 28: Line 28:
== Step 3 ==
== Step 3 ==
[[File:Auth03.png|frame]]
[[File:Auth03.png|frame]]
This box is designed to scare you off. Don't let it.<br>Click on '''advanced''' in the lower left corner.
<br clear=all>
<br clear=all>
== Step 4 ==
== Step 4 ==
[[File:Auth04.png|frame]]
[[File:Auth04.png|frame]]
Then click on '''Go to dream (unsafe)''' at the bottom left.
<br clear=all>
<br clear=all>
== Step 5 ==
== Step 5 ==
[[File:Auth05.png|frame]]
[[File:Auth05.png|frame]]
Type the word '''Continue''' in the text box.
<br clear=all>
<br clear=all>
== Step 6 ==
== Step 6 ==
[[File:Auth06.png|frame]]
[[File:Auth06.png|frame]]
Finally, click on '''ALLOW'''.

Revision as of 10:22, 12 October 2017

Google has created a very strict authorization requirement for Google Apps Scripts running on Google sheets. This can be partially circumvented by associating the spreadsheet with a Project ID and requesting that the script be verified by 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 authorization process the first time that you press the New Tab button on a newly copied sheet.

The following is a step by 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 Sign In - Google Accounts box will be displayed next.
Your Google account should appear there.
Click on your account to continue.


Step 3

This box is designed to scare you off. Don't let it.
Click on advanced in the lower left corner.


Step 4

Then click on Go to dream (unsafe) at the bottom left.


Step 5

Type the word Continue in the text box.

Step 6

Finally, click on ALLOW.