Google Apps Script Triggers Explained 👈🏽

In this video we'll cover Google Apps Script triggers: the types of triggers you can use, the restrictions and so on.

0:00 What are triggers?
0:56 Simple triggers explained
6:49 Installable triggers explained
9:42 How to add installable triggers
11:33 Google Workspace application triggers
12:37 Programmatic managing of triggers
13:18 Trigger errors

#GoogleAppsScriptTriggers #GoogleAppsScript #AppsScript #GoogleWorkspace #GoogleSheets #saperis #ChanelGreco
-----

saperis - Helping you become a Google Workspace Pro!

[fionawylie]

I'm learning how to app script from you, I'm a total beginner and your videos are essential watching for me. Thanks so much.

[TheDervMan]

Oh wow, I was completely unaware there are so many types of triggers! Thanks Chanel

[lesptitsoiseaux]

Chanel, you scare me a little. But your videos are top of the line! Love them 😍

[juancanete]

Loved your hair. And yes, I did learn plenty of useful things I didn't know before. Thank you!

[jameskosterman]

Thanks - that was very helpful. I've written code for data analysis for several years, but I'm just starting to use scripts and macro's in Google, and getting my triggers to work as expected has been a problem. This answers some of my questions

[dakshbhatnagar]

Great video, I want to set up a trigger to be run every 72 hours. Let’s say I create the trigger, now what should I do when setting up the trigger using that window??

[doslayouts]

Hello! How do I stop sending the file again from previous people whenever I send the file to new people?

[ThangTran-feoz]

I create trigger with newTrigger method. How to setup failure notifications without choose UI? Thanks

[atzgoblastbotzo]

interesting but the low pulsating hum that sounds like a ventilator is really distracting. I recommend you apply a low-pass filter on your sound file.

[OrkedZaquan]

HI, I have a question, I create a code linking form, spreadsheet, and calendar using onFormSubmit() which it will map the leave request date on the calendar once the form is submitted. The code works just fine. But when I add some IF ELSE function for the drop-down in the form, it doesn't work. Which trigger I should use for this?

[thatchermines]

Nice video--Just FYI that the link you mention for learning more deeply about GoogleSheet automation doesn't seem to be working, and the link from your comments shows a course "Productivity for Creatives with Google Workspace" (same on domestika), but not one for automation.

[giovannimattioli]

hi sorry but when i go to the clock it didn't give me the botton ADD trigger, it give me file.json and file.gs, what i have to do????

[sajidshahzad]

i want protect or hide my script code of google sheet from another person. How it possiable?

[bukaIapak]

Let's say I build a google sheet add-on, can I use installable trigger to run in users who install my add-on?

[shrutigoyal]

Hi Saperis
Can you guide how can you stop trigger execution after 5 times?

[Thilina_madushan]

I like your excellent explanation.👍❤
i have a question
I want to send emails on a specific date.
I want to send an email This should work after 3 days from the date of customer registration and continuously.
For example " 2022.07.13 after registration then message should be sent on 16.07.2022. Date may change because customers can register anytime")
How to send email with conditions.🤔
Please tell me how to do it
Thank you very much 😊

[yllazora.]

Hi! I have several onEdit triggers but when I duplicate the sheet, all of it are gone on Triggers and have to manually add all of it again on the duplicate sheet. Is there a way that those onEdit triggers won't be removed once I create a copy of the original sheet? Thank you.

[ronaldvida]

Love your explanations! I am trying to use the openById method (in a bound script) to open one of my other spreadsheets, but keep getting a permission error. Discussion boards say that the way around the problem is to use a "trigger". What does this mean? (Note: I'm brand new to Google Apps Script -- this is my 2nd day!)

[krishnajannu]

Can we triggered google app script to send emails when new row added to spreadsheet.

[bridgemeldformulieren]

Interesting Video! I have a time trigger (weekly fires) that activate a function that contains an installable trigger. In some google sheets the weekly trigger does not fire, in some it does. What could be the reason that it not fires?