Can't log in to Google Apps Scripts

8.9k Views Asked by At

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?

8

There are 8 best solutions below

0
On BEST ANSWER

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.

1
On

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

For example, script.google.com...?param=value&[email protected]

5
On

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.

0
On

Based on @iansedano's answer, you can share the file with the default chrome user and open the same link in a new tab again to resolve the issue.

0
On

This is a reported bug.

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

0
On

If someone needs a quick fix for this :

At the end of the url change the "authuser=1" by the index of the Google Account you want to log with. (0 is the first one, 1 is the second)

https://i.stack.imgur.com/qJows.png

0
On

google's default account (the first one you sign on with) has to be the owner of the sheet

1
On

You can also open a new incognito window, paste your sheet url there (you'll need to authenticate). Then you can open Tools -> Script Editor