FRC API Google Sheets

How would I start using the FRC API in google sheets?

You would have to write ur code is google app scripts. Here is their docs for sheets

Rather than using FIRST’s API, you can use The Blue Alliance’s (easier) API that provides basically the same data. And someone already wrote a Google Sheets library for that so you don’t have to.

1 Like

This is probably the easiest way to get started with TBA data in Sheets. You have to login on TBA and generate an API key. Then go to add-ons in Sheets and get TBA Requests. Then when the add-on is active you should be able to start typing =TBA… to get various functions. Before you get any data, you have to run =TBASetKey(“your key”). There are built-in functions but you can write some custom ones too with TBACustom function with the API string and comma-separated JSON parsing arguments.

1 Like

Alternatively, you can add the IMPORTJSON function to Apps Script and access the TBA API that way.

The reason the TBA API is easier to access through sheets than FIRST API is because TBA supports authentication as a URL parameter (thebluealliance.com/API/v3/some-endpoint?X-TBA-Auth-Key=some-key) whereas FIRST requires username/password authentication which is harder to make work.

If you need help, querying the TBA API from Google Sheets is kind of my entire brand…so share any further questions!