Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can't log in to Google Apps Scripts

I'm using multiple Google accounts. In one of them (not default) I created Google Spreadsheet file and I want to create Script connected to it. Nothing complicated. But the problem is that after clicking Tools > Script Editor I'm being redirected to default user or I see this screen:

Sorry, unable to open the file at present

The same problem I have when trying to use: script.google.com

What can I do to enable Script editor?

like image 910
emendelski Avatar asked Dec 08 '17 11:12

emendelski


4 Answers

I know you asked this 9 months ago, but here is my solution;

  • Sign out of all google accounts except the owner of the spreadsheet
  • You can now access the scripts and macros pages (go there)
  • Create a bookmark of them (this saves which profile is logged in)
  • Now sign back into all your profiles
  • Voila!

You will be able to access the scripts or macros via the bookmarks without getting the error page.

like image 56
Julien Boudreau Avatar answered Oct 19 '22 21:10

Julien Boudreau


This is a reported bug

https://issuetracker.google.com/69270374

Go give it a ☆ if you want to let Google know that this affects you.

like image 45
iansedano Avatar answered Oct 19 '22 22:10

iansedano


You can consider appending authuser=email to the URL to open the script with a specific Google account.

For e.g. script.google.com...?param=value&[email protected]

like image 25
Amit Agarwal Avatar answered Oct 19 '22 21:10

Amit Agarwal


I was not able to reproduce the problem. Perhaps it's a glitch or there is something wrong that requires some troubleshooting techniques that are off-topic on this site.

As a workaround, for the account having problems, use another Google Chrome profile, Incognito mode, or another browser.

By the other hand, it's possible that there isn't any wrong and it's just something related to your specific scenario.

From Sign in to multiple accounts at once

Sometimes settings might carry over

If you're signed in to multiple accounts at the same time, sometimes we can't tell which account you're using. For example, if you're signed in to two accounts and you open a new browser window, we aren't sure which account you want to use. In cases like these, Google might apply settings from your default account, like its Web & App Activity and Ads Personalization settings.

like image 34
Rubén Avatar answered Oct 19 '22 20:10

Rubén