Google Apps Script: Get the ID of script bound to a spreadsheet

6
votes

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 spreadsheet object, I have methods like getId to 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?

1
google-apps-script
stackoverflow.com/questions/51120078/… stackoverflow.com/a/31184468/9337071 issuetracker.google.com/issues/117105104 issuetracker.google.com/issues/117105106 github.com/google/clasp/issues/208 stackoverflow.com/questions/29613469/… – tehhowch
And issuetracker.google.com/issues/111149037 – Tanaike

1 Answers

3
votes

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.