I built two separate spreadsheets in Google Drive and spreadsheet "A" has a script that when run, will copy the input data into spreadsheet "B". When I test it, it works perfectly. But I have other users that only have access to spreadsheet "A". When they run the script it doesn't work because they don't have permission to spreadsheet "B", but I don't want to give them the historical data that's saved in spreadsheet "B".
The error message is:
Document ID is missing (perhaps it was deleted?)
How do I get through this?
I made a Demo copy that can be accessed: demo copy
Best Answer
According to Authorization for Google Services it's not possible because for Standalone, add-on, or bound to Docs, Sheets, or Forms the script run as the user at keyboard. The alternatives is to convert your script to a web app or to a Installable trigger.