You’ll have to implement some code to fetch data from the API using OAuth2 as the authentication method.
The 2nd sample code in this post is GScript and will let you automatically renew your access_token using the client_credentials flow.
You can modify the same sample to create more functions to fetch AH data, but I’m not sure if GScript can handle the huge payload returned by the AH endpoint (at least not very efficiently), you’ll probably have to write you own back-end server to break down the data before integrating with the spreadsheet.
It is a good idea to describe better what kind of data you have in mind so people can help you more.