-1

I've created a Google Apps Script file which sort of acts like a Master Code which I would like to use for multiple spreadsheets. Is there a way to 'import' the Google Apps Script or in a sense link it to the spreadsheets so I don't need to keep copy pasting all the code from the Master to the spreadsheets script editor?

Rubén
  • 34,714
  • 9
  • 70
  • 166
CHEWWWWWWWWWW
  • 169
  • 3
  • 20

2 Answers2

1

You have 2 options.

  1. Publish your script as an Add-on. Read more here
  2. Create a script that can work with any spreadsheet (code would get by ID or use the Drive API to browse where it works) from a centralised UI. You can create a simple WEB UI to control it.
Vytautas
  • 2,238
  • 1
  • 9
  • 20
0

Put a minimal script in the sheet and then include and call your "master code" as a library.

Andrew Roberts
  • 2,720
  • 1
  • 14
  • 26