CODEWITHSUNDEEP
google-apps-script
WRG
WRG

Reputation: 1

Google Sheet scripts - Authorization process broken - Error 401: disabled-client

I have a script that I have used for many years which is attached to a Responses Sheet for a Google Form. Every time a submission is made to the Form the script will email out the entry from the Responses Sheet. Recently, Google deleted my authorization data forcing me to re-authorize the script. I went into my Responses Sheet and ran the script causing the Authorization prompt to display. I pressed Review Permissions. Normally, this would take me to the sign in for my account but instead I am getting an Authorization Error: Error 401: disabled_client

I have tried to search for a result to this problem and have not found one. Any help is greatly appreciated.

Google Chrome is up to date: Version 88.0.4324.150 (Official Build) (64-bit)

Upvotes: 0

Views: 408

Answers (1)

iansedano
iansedano

Reputation: 6481

Posting this for reference in case of future users:

It appears that your linked GCP project is being deleted

As you have mentioned, your Apps Script project has been scheduled to be deleted and this is interfering with your authorization process.

You can read more about Apps Script and GCP projects here:

https://developers.google.com/apps-script/guides/cloud-platform-projects

Usually Apps Script projects are attached to a "deafault GCP project" that is not visible via console.developers.google.com - however as may be your case, for older projects (previous to 2018/19) this project may be visible.

Cancel deletion of your GCP Project

This video has step by step instructions on how to do this:

https://youtube.com/watch?v=bwtw6fSARek

Which essentially takes you to the list of active projects, where at the bottom you can see the projects pending to be deleted. In the list of projects to be deleted, you can find the option to "restore" them.

Alternatively, just create a new project

If you don't want to manage GCP projects and take advantage of the new "default" project that is attached to new scripts, then you will have to start a new Apps Script project and move everything over, as there is no way to go back to the default GCP project, once the Apps Script is linked to it. That is, once a GCP project is visibly linked to the Apps Script project, you can't go back to the default.

Upvotes: 1

Related Questions