Check if appsscript project trigger exists with google sheets formula

Question

I'm creating apps script triggers that send automated scheduled emails from a google sheets document (document A). I have another document Z where I would like to validate if the trigger was created in the document A apps script environment. Is there a formula or script which helps me with this? I know the name of the apps script project, that contains the trigger.

I have around 200 documents where triggers are created and need a central document to validate if everything went well.

Thanks for your help!

ziganotschka · Accepted Answer · 2020-04-03 08:59:13Z

2

Unfortunately there is no direct way to do it

There is the method ScriptApp.getProjectTriggers(); but it only allows you to retrieve the triggers of a certain project, not all triggers on your drive.

But you can implement a workaround.

E.g., when you create a trigger (I assume you do it programmatically wiht a triggerBuilder, retrieve the trigger Id and paste it into a speradsheet. If you do it for all triggers you create, you will have a spreadsheet that lists all triggers you created.

answered Apr 3, 2020 at 8:59

ziganotschka

26.9k2 gold badges18 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Check if appsscript project trigger exists with google sheets formula

1 Answer 1

But you can implement a workaround.

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

But you can implement a workaround.

Comments

Your Answer

Sign up or log in

Post as a guest

Related