evolvingweb
Permissions error with multiple accounts
Here's a document: https://docs.google.com/a/evolvingweb.ca/spreadsheets/d/176n_UlxM_jmdp6ILDActVsrW9IaGuzVSx9_pmMsUy6U/edit#gid=0
If I share it with my work email (@evolvingweb.ca) and not my personal (@gmail.com) then the following URL (that the plugin generates) results in a 403:
https://docs.google.com/spreadsheet/tq?gid=0&key=176n_UlxM_jmdp6ILDActVsrW9IaGuzVSx9_pmMsUy6U
This error manifests as a "Loading spreadsheet..." stuck message, and 403s in Chrome inspector. Visiting the URL manually actually has Google prompt me "Which account do you want to use?" but this doesn't help the embedded scenario.
Interestingly, if my personal account was given access to the doc, then it wouldn't just grant me access to that URL, but would actually redirect to the following:
https://docs.google.com/a/evolvingweb.ca/spreadsheets/d/176n_UlxM_jmdp6ILDActVsrW9IaGuzVSx9_pmMsUy6U/gviz/tq?gid=0
Testing that URL without granting access to the doc shows that it works. Perhaps as a work-around, the macro could take a domain argument? Then it would generate links accordingly.
Trying to access this document as a test: https://docs.google.com/document/d/1lo0jNfVVfQzbs4724El7wZ6A_fyQ1LRrqGpaY-LQJA0/edit?usp=sharing
Copy the key into the Macro as 1lo0jNfVVfQzbs4724El7wZ6A_fyQ1LRrqGpaY-LQJA0 and get this in return:
Error executing the google macro (It is not Google Apps document...)
