18xx Dream Spreadsheet Authorization Issue

From BOARD18 Project WIKI
Revision as of 09:49, 12 October 2017 by Rich (talk | contribs) (initial contents)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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


Step 2

Auth02.png


Step 3

File:Auth03.png


Step 4

File:Auth04.png


Step 5

File:Auth05.png


Step 6

File:Auth06.png
Retrieved from "https://wiki.board18.org/index.php?title=18xx_Dream_Spreadsheet_Authorization_Issue&oldid=2395"