Reputation: 3226
Google Apps Script: Get the ID of script bound to a spreadsheet
I want to write a Google Apps Script to generate a list of the IDs of the scripts bound to certain spreadsheets.
I cannot find a way to programmatically, via GAS, get the ID of a bound script.
If I have a
spreadsheetobject, I have methods likegetIdto get the ID of the spreadsheet, but not the bounded script.Using the DriveApp, I can find standalone scripts using
DriveApp.getFilesByType('application/vnd.google-apps.script')but not bound ones!
Any suggestions?
Upvotes: 6
Views: 1501
Answers (1)
Reputation: 7367
Unfortunately (by my own research) this is not currently possible. I have been wanting to programatically identify and access bound scripts for several years, I look into it periodically, I've always come up empty handed.
Haven't found any Google documentation explicitly on the topic, still hoping this hole gets filled eventually.
Upvotes: 4
Related Questions
- Get the spreadsheet ID from which a web app script was opened
- How to fetch a spreadsheet Id without opening the spreadsheet?
- Google Apps Script, Google Sheets - Getting Spreadsheet ID and Sheet ID programmatically
- How to get Google Apps Script project ID linked/bound to a Google Spreadsheet
- How to fetch the ID of a Google Spread Sheet via Google Apps Script?
- How can I find the ID of a google sheet that I've just created with code?
- Get the ID of a spreadsheet
- accessing spreadsheet by ID
- Programmatically find your Script ID
- Find the ID of the attached spreadsheet from doGet function