Like many of you are likely doing, I was clicking through each of the events to try and get an idea of where scores were landing. And this was tedious. So instead of spending 5 minutes doing that, I spent significantly more time making this spreadsheet.
It does not run automatically. Too many events for me to want to do the busy work to hook that up. Instead, it’s run by an app-script that creates a sheet for each event, and then copies their values into the main sheet.
You are welcome to make a copy of the sheet for yourself, just know that I have deleted my API key from the script. You can get your own here. Just open up the scripts for this google sheet, and paste in in the top. Then run the “RunMe” function. Might take a while to run. I hacked this together for myself so it’s not the prettiest.