Spreadsheet.com stores a run log of every automation execution. After setting up your automations you may wish to check how they're running or trace a change made by an automation. Track when automations ran, what actions they performed, if they were successful or not, and trace the exact triggers, conditions, and actions executed.
For any of these tasks or more, you can use the Automation Activity menu (for all automations), Run an Automation History report (for each automation), or check the Automation's Run Log (for each run of the automation). All of which can be accessed by navigation to the automations menu.
You can also see a full history of all automation activity at the workbook and individual worksheet level in the Automation Activity panel, which also shows workspace-level automation quota information.
You can also access all Automation activities for all workbooks in a workspace via the Workspace settings menu on the home page.
You can also access the run history and individual run logs for each automation from the Worksheet Automations panel.
Choosing to run history on any one automation will show you each run of that automation, the number of actions performed, the status, and link you to a run log with more detail on that automation's exact run.
Automation Run logs
From the Run history and Automation Activity menus, you can view the run log for each automation:
The run log lets you dig into what triggered, what conditions were met, which actions ran, and what the action looked like.
Test run logs
Spreadsheet.com allows you to test automations with existing data and creates a Test run log of exactly what happened for you to trace. Access the Test run log either by running a test in the Automation setup menu or opening the Test run log menu in the same menu.
In the animation below, we conduct a test run on our Spreadsheet.com message automation, picking an existing row to run our test off of and seeing the log that shows the action executed.
We can even check our email to see that the test sent the message at the same timestamp as in our animation.