Adding an existing app script to google sheets

Question

Is it possible to add an existing app script to a newly created googlesheet using app script? And automatically assigning it to a trigger?

For example I have a spreadsheet call spreedsheetA. Then my form will create spreedsheetB, is it possible to automatically add my app script to spreedsheetA to spreedsheetB with out copy + pasting it manually. All by using the appscript in my form.

For example, in your situation, how about copying "spreedsheetA" as "spreedsheetB"? About Is it possible to add an existing app script to a newly created googlesheet using app script?, you can achieve this using Google Apps Script API. Ref About And automatically assigning it to a trigger?, for example, how about creating both the Spreadsheet and the container-bound script using a script? — Tanaike
– Tanaike, Commented Feb 3, 2022 at 11:47
I didn't think of that. Let me test that out. That's brilliant! Thank you kind sir! — sirnewbee
– sirnewbee, Commented Feb 3, 2022 at 11:52
Thank you for replying. I think that if copying "spreedsheetA" as "spreedsheetB" is the same goal you expect, that is the simpler solution than using Google Apps Script API. — Tanaike
– Tanaike, Commented Feb 3, 2022 at 11:56

Emel · Accepted Answer · 2022-02-03 12:57:19Z

As a workaround to what @Tanaike proposed you can use the Drive API to make the copy. Because bounded scripts are also copied when you perform a makeCopy() operation.

Steps:

Create a new sheet and add a bounded script via Extensions > Apss Script. Take note of the ID, in the example I will call it SSA_ID
Add your script. As probe of concept I just added this simple one:

function onOpen(e) {
  SpreadsheetApp
  .getUi().alert('Hi from bounded script')
}

Create a new script, and paste this code inside:

function copySpreadSheet() {
  const file = DriveApp.getFileById(SSA_ID)
  const newFile = file.makeCopy(`SpreadSheetCopy_${new Date().toISOString()}`)
  Logger.log(newFile.getUrl())  
}

Run the script, grab the url and copy paste it in your browser. You will see that it contains a copy of the bounded script.

From there you can manipulate the copy and add it to an Installable Trigger, for example:

ScriptApp.newTrigger('copySpreadSheet')
  .timeBased()
  .everyHours(6)
  .create();

Collectives™ on Stack Overflow

Adding an existing app script to google sheets

1 Answer 1

Documentation:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Documentation:

Comments

Your Answer

Sign up or log in

Post as a guest

Related