With Spreadsheet.com's native automations, you can quickly and easily automate repetitive work and integrate with other popular work tools.
For example, you can create automations to:
- Notify task owners 2 days before each task’s start date
- Send a Slack notification to the entire team when a deal is closed
- Move a row to a different worksheet when a ticket is archived
Automations can be created by anyone. You don’t need to know how to write code or create complicated scripts.
Only Managers and Editors in a workbook can see or add automations. Automations are not private to one user but can be seen and edited by every manager or editor in a workbook.
How to Create a New Automation
To create an automation click the robot icon in the upper right corner of the workbook.
This will open the Automations dialog, where you can browse through a library of automation recipes. Recipes are ready-to-use automation templates to help kickstart your workflow.
To begin making an automation from scratch, click the blue + Create from scratch button in the left-hand panel.
Visit our Automations Library to learn more about connecting Spreadsheet.com with other apps and services.
Configuring Your Automations
Triggers, Actions, and Conditions
Selecting an automation recipe or opting to make one from scratch will open Spreadsheet.com's visual workflow editor where you can configure and customize your new automation. Each automation always has one Trigger block and one or more Action blocks. The trigger block determines when the automation will run, and the action blocks define the actions that will be performed.
In the example below, changing the "Status" of a column to "Delayed" will trigger the action,specified as sending a notification email to the task owner.
You can add complexity to your automations with conditional logic by adding a condition block. To do so, click the gray circle between the trigger and action blocks and select "Condition" from the Choose a Block menu.
In the example below, we've modified our first automation to only trigger a notification when the "Priority" of the column is marked with a flag icon.
Each action block can have multiple actions and you can reorder them to determine the execution sequence. If you need to create a single action block with multiple instances of the same action (like sending an email notification to multiple people), click the Duplicate button to the right of the action name.
In the example below, we've further modified our original action to not only notify the task owner but another user too, as well as change the "% Complete" column to 100%.
Custom notification messages and emails can include row data by inserting column placeholders in the subject and message body. To insert row data in notifications, click the square plus icon on the right side of the relevant field, or type the column name in brackets.
Rows in Automations
When creating, moving, copying, or updating rows in an automation, a row mapper dialog provides an easy way to map data from the source row to the target – even when mapping data across worksheets in different workbooks:
Validation and Testing
When you save your automation, Spreadsheet.com will automatically run a validation test to make sure that your automation will function properly. Alternatively, you can opt to manually test your automation at any time. Both can be accessed from the upper right corner of the automation configuration dialog.
If the validation fails, Spreadsheet.com will highlight the block where the automation failed. You can see exactly what conditions the automation failed on by mousing over the red triangle icon in the top right corner of the automation block.
When you test an automation, you can see the results of the test by opening the Test run log from the right hand side of the automations dialog.
Read on to learn more about trigger types, as well as standard action types and integration action types that work with third-party apps and services.