Here are some examples of use cases where you might use a Time-based trigger:Īutomatically sending a report to your team every morning. Use Time-driven triggers to run a function in your script periodically OR at a specific date and time in the future. They are: Time-driven triggers and Spreadsheet triggers. There are two types of triggers in Google Sheets. You enter all the birthdays you want to remember into a spreadsheet and then use a trigger to check it every morning at 6AM and send you an email if it is someone's birthday.įrom a technical standpoint what is happening is that the trigger causes a Google Apps Script function to run every morning and this function reads the birthdays from the spreadsheet and sends you an email if that day happens to be someone's birthday. You make a new year resolution to remember birthdays and you decide to use your spreadsheet skills to help you keep your resolution. Suppose you're like me and you tend to forget the birthdays of your friends and relatives.
The best way to understand how triggers work is to look at an example.
#Google sheet print selection how to#
In this article, you'll learn more about triggers, how they work and how to create them.
Triggers are a feature in Google Apps Script and they enable you to automate your tasks and workflows in Google Sheets.įor example, if you want a metrics report emailed to your boss every morning, you can use a Time-driven trigger along with some Apps Script code to automate sending this report.
0 kommentar(er)
