In Spreadsheet.com, Automations consist of two necessary parts (Triggers and Actions), and may also include Conditions. Triggers tell your automations when to be activated, while actions determine what Spreadsheet.com does. Spreadsheet.com can both take a standard action on an existing worksheet or an integration action with applications outside of Spreadsheet.com.
Standard action types are a great way to add or update data when other users make a change. For instance, create a row in a worksheet of your tasks when your project manager adds new tasks in the team's project plan that are assigned to you, or update rows in your team's customer service ticket tracker when customers submit new tickets.
When setting up the Create row action, first specify the desired worksheet. You can add new rows to the end of your triggering worksheet or another worksheet.
After selecting the desired worksheet, you can customize the row that will be created. You can fill in either fixed data or populate your row with data from the existing worksheet.
For instance, in the animation below, Harry is a CS rep who has a worksheet for tickets assigned to him, so he wants to automatically add new submitted tickets when new tickets are assigned to him. So he sets up a condition and create row action, then tests it with existing data.
The update row action type can only be applied to the worksheet that triggers it, and allows you to change the value of one column's entry in the row that triggered the action.
For instance, in the animation below, we automate assigning our Customer Service tickets, sending Technical issues to Harry and Billing issues to Lisa. We start with conditions already in place, then we update rows to assign new tickets to Harry or Lisa and set the ticket status as "Assigned".
Similar to the Create row action type, the copy a row action type allows you to copy the triggering row to any worksheet.
Like the create and copy row actions, the move row action allows you to paste the details of one row to another row in any worksheet. However, the move row removes the row from its previous location.