Yeah, I actually do something similar with some of my projects. I'm able to get good results directly querying sheets: https://www.benlcollins.com/spreadsheets/

Yeah, I actually do something similar with some of my projects. I'm able to get good results directly querying sheets: https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/ https://www.benlcollins.com/spreadsheets/google-sheets-query... Pivot tables have a bit of a learning curve but you can also use them to dynamically pull data out of sheets: https://support.google.com/docs/answer/1272900?hl=en&co=GENIE.Platform%3DDesktop https://support.google.com/docs/answer/1272900?hl=en&co=GENI...