CODEWITHSUNDEEP
javascriptgoogle-apps-scriptgoogle-sheets
Sai Krishna
Sai Krishna

Reputation: 135

Call App Script from Different Spreadsheet

I have Four spreadsheets one is Admin spreadsheet where all the code is written and other three are employee sheets.

So I want to call script in Admin sheet from Employee sheet using button. Whenever user clicks on button it copies data to Admin sheet.

I do not want code to be in each employee spreadsheet . I want all the code to be in Admin spreadsheet and give link to call the script from the employee spreadsheets.

I did not get solution after searching in google. Tried to use webapps but I think it is used only for HTML pages.

Upvotes: 0

Views: 138

Answers (1)

Wicket
Wicket

Reputation: 38131

I think that your best bet is to create an add-on.

If you are using G Suite then the add-on could be published only to be used by users from the same domain.

An add-on it's better than a library or as publishing the script as an API because these alternatives require a script to call them.

Reference

Upvotes: 1

Related Questions