Error Message: Expection: Service Spreadsheet failed while accessing document ID: xxxxx

[ABC Company]

Hello,

One of the projects which migrates data from a Google Doc to Google Sheet was working great on Monday, and now I am receiving error messages and unable to view the AppScript Code. I run the Script 1 time per day, and it creates a new 'sheet' with the Google Spreadsheet with {todays date}.

Now I am receiving an error message - Error Message: Expection: Service Spreadsheet failed while accessing document ID: xxxxx. When I click on the App Script Icon within the sheet, I receive another error message:

Sorry, unable to open the file at this time.

Please check the address and try again.

Get stuff done with Google Drive

Apps in Google Drive make it easy to create, store and share online documents, spreadsheets, presentations and more.

Learn more at drive.google.com/start/apps.

When I ask the Google App Script developer to share the code or fix the issue, he tells me "It looks like there is actually something wrong with the script. Google Drive services might have an outage. It's working fine for me." 

• Can I store the App Script Code within my Gsuite Account and provide edit access to the developer? 
• Can I view a history of the changes made to the AppScript, so I can undo changes which cause the Script to not work?
• Can I view the App Script somewhere else, besides the Spreadsheet App Script tab?

Any advice would be greatly appreciated. 

[cbmserv...@gmail.com]

Hi,

 

Here are some answers to your questions:

 

• Can I store the App Script Code within my Gsuite Account and provide edit access to the developer? 

Yes, you can store it in your drive and give him edit access. However, authorizations given to the code is user specific. So if he adds a new scope, you will have to authorize it as well to make it run or it will fail for you.

• Can I view a history of the changes made to the AppScript, so I can undo changes which cause the Script to not work?

You can with the old script editor. So switch to old editor, then under File menu, choose “See version history” to see the revisions. You can choose to backout any changes here as well.

• Can I view the App Script somewhere else, besides the Spreadsheet App Script tab?

It depends on where the script container is. If the script is a standalone file, then you can view it from your drive. If it is attached to a spreadsheet, then you need to open the spreadsheet to view it.

If you want to run the script on other tabs in the spreadsheet, you can. As long as the script is modified to be able to do that.

 

Hope this helps.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/34e0dbae-b896-4655-bff5-cf6628b801b8n%40googlegroups.com.