I’d like to suggest adding a feature that creates an automatic checkpoint or version snapshot prior to any save operation (manual or automation-triggered). This would significantly enhance data recovery and user control, especially in situations where an automation yields unintended results.
Problem:
Currently, if an automation is accidentally misconfigured—e.g., missing a filter condition—and it runs across the entire sheet rather than a select few rows, the changes are immediately saved and difficult to undo. The only option is for the user to manually revert the changes, which can be extremely time-consuming, especially on large or complex sheets.
Proposed Solution:
Introduce an automatic checkpoint system that:
- Creates a temporary save state immediately before any automation or user-triggered save.
- Allows the user to restore to that checkpoint if undesired changes are detected.
- Optionally, retains the checkpoint for a limited time (e.g., 24 hours) or until the next save is made.