CODEWITHSUNDEEP
google-apps-script
Triven
Triven

Reputation: 351

bound standalone google app script to google sheet

I created a google app script that is bound to google sheet later I moved it as standalone script inside a google drive folder. I thought I will be able to reuse it across multiple sheet. Now I am not able to find any way to run standalone script inside my google sheets. Please suggest.

Upvotes: 0

Views: 678

Answers (1)

michaelsinner
michaelsinner

Reputation: 376

From your standalone script you can access your spreadsheets and work this way with your files.

Use something like this to get a set of spreadsheets (pseudocode)

var ssList = ['...','...']
for each element in ssList do:
SpreadsheetApp.openById(ssList[element]);

Then you can reuse your code and access multiple spreadsheets.

But it is not possible to access multiple apps script files, only one file is bound to your spreadsheet.

Upvotes: 1

Related Questions