I’ve created a Google Script APP to help someone export Gmail data to Google SpreadSheet.
It works well when I was testing. But after I publish it as web app, and other users got an error which says
[Error] ScriptError: Document DOCUMENT_ID is missing (perhaps it was deleted?).
And no authorize permission form popups up. I did not get any useful answer in Google.
After several tests I found I made a stupid mistake.
When publishing the Google Script as web app or other types of APP. There are several options need to take carefully.
Execute the app as:
should set as “User accessing the web app“. (The default value is Me(myself email)).
With this option, when user first use your app, the authorize permission form will popup and ask user to allow your app access their Google APP.
And no more Document is missing error.
Also don’t forget to chose Anyone in the Who has access to the app option.
Hank March 5th, 2017
Posted In: Program