Team RamTech 59 has recently posted a code library which will let you pull data from The Blue Alliance API v3 into Google Sheets. Below is the link to get there:
This library includes all data calls that The Blue Alliance offers, along with some custom functions that our team came up with.
We hope you all enjoy the code library and feel free to contribute.