Trigger Frequent, Change-Based Automations in Batches

In the Run workflow dropdown of the trigger block in your automated workflow, you can adjust whether a change-based workflow should run immediately, or batch up changes and deliver alerts and/or requests hourly, daily, or weekly based on the changes that took place in the given timeframe.

run workflow dropdown

Keep the following in mind as you set the run behavior for your workflow:

  • Workflows set to run daily will evaluate changes to the sheet and execute between 12:00 AM and 11:59 PM in the sheet Owner’s timezone and messages will be delivered between 12:00 AM and 4:00 AM the next day. 
  • Weekly workflows will run between the first Friday at 12:00 AM and 11:59 PM the following Thursday, and messages will be delivered between 12:00 AM and 4:00 AM on the second Friday.
  • If multiple rows are changed when the sheet is saved within the timeframe of the selected frequency, then the workflow will run for every row that meets the trigger criteria. Recipients of this automation will receive a single notification with up to 100 rows in grid format.
  • If placeholders are used in the custom messages of your automation, separate alerts will be generated for each unique custom message. See Dynamically Add Cell Data in the Subject and Body of Request Messages for more information about message placeholders.