I’ve put together a test type automator in google sheets. Although it’s set to viewer mode I think you should be able to populate the cells and test it out.
Please let me know if it gives anything inaccurate or fails at being intuitive. I think something like this could be a valuable community tool as long as it looks right and works correctly.