Rule is a mini workflow that automatically runs to perform your repetitive tasks when certain event happens.
When data is updated in the sheet
If the value matches one or more conditions
Move the updated row to another sheet
Highlight the row by filling background color
Send email notification to the owner
Provide personalized response based on the answer condition. Send email to predefined recipients or email addresses pulled from sheet.
Dispatch sales lead or marketing inquiry to sales rep. Automate job shift/rotation. Notify colleagues via templated email or slack when status is updated.
Monitor data like inventory level or KPI metrics anywhere in the sheet. Perform arbitrary actions when the value is below or above threshhold.
Track sheet changes by highlighting the updated row or copying it to another sheet with additional logging information.
Assign tasks to team members. React to status update and approaching deadline. Archive completed tasks automatically.
Scan and process every row of the sheet periodically. Filter rows with one or more conditions. Move data between sheets.
Automate daily repetitive tasks without writing script.
The data never leaves your google account as the rule runs on your sheet directly.
Got a problem or a question? We are ready to help.