Until recently my company didn't use Google Sheets at all. After we got FlowyTeam from AppSumo we started using them for our KPI's. The data comes from different tools across the web, mainly marketing stuff. However, almost none of this data is in the format that FlowyTeam requires (and FlowyTeam is just an example - I guess that most tools out there have special requirements regarding form). Now the Sheet Automation extension luckily can perform automatic restructuring operations. Many times we need to add automatic dates to the rows, calculated values, or automatic references. All of which the extension does very reliably. Furthermore, they have some pretty nice features like sending emails automatically, Webhooks, Slack integration, conditional actions and some minor features.
Support is very responsive, too!

After all, if you use Google Sheets - foremost if you have integrated it with other tools like Konnectzit, Hexomatic, FlowyTeam, or so - you should consider organizing these Sheets with Sheet Automation. It definitely is most efficient if you already use some other automation tools. I can imagine that it is useful, too, if you input your data manually - it still saves time - however, it is more powerful combined with other tools.

Special hint: try it out for free at the extension store. Their free plan is quite generous.