Hey guys, thought I'd share a medium post that I just wrote around the topic. This would be useful for anyone who has to do regular reporting via google sheets and is looking for a way to speed up their workflow.
It utilises a two of free add-ons, called G-connector and Sheetspread with step by step tutorials on how to get set up.
Take a look and let me know what you think!