The last two years 4944 has been using Google Sheets to run our scouting system. We’ve had our scouters using google forms for both pit scouting, and match scouting, which provides live updating data to our strategy team for match prep. We’ve also developed a system for including The Blue Alliance API data inside of our “Scouting App”. I figure I’d share our code in the hopes that it’ll help other teams who are using Google Sheets.
What we’ve developed is simply a google script file you can add on to any Google Sheets which will allow you to use new functions in any cell. Here are the functions currently supported:
tbaTeamsOnAlliance(eventcode, matchcode, alliance)
returns A1, A2, A3
As a small note, I’m not sure how this will work in an ongoing event just yet.
There’s obviously way more information available in the TBA API than this currently supports, but these are the ones that provide information useful to 4944’s scouting program at least. If you have any requests, just reply here and I’d be happy to add it on if it’s feasible and I have time.
Setup is very easy! All you have to do is copy/paste code into the script editor on your sheet, generate an API key and paste it at the top of the script. Instructions and code are located here on GitHub.
Example: 4944’s applications of this in our Google Sheet Scouting App for the 2019 Utah Regional
Team Lookup - enter team number and see all match data (notes hidden since it sometimes mentioned other teams)
Match Prep - enter match number & match type and see data on all 6 teams
We also have a Match Prep Manual sheet (enter in 6 teams manually, good for comparing teams during a picklist meeting for example), as well as some picklist tools.