Comment by alecgorge

An easy way to take this to the next level (and be truly no-code) is: https://www.tillerhq.com/

I love being able to continue using Google Sheets shortcuts + automation features. It allows me to generate well-formed reports that I can analyze with pivot tables or any of my normal processes that I use for analyzing datasets.