The API is up and running, moreover, it’s self documenting. The only thing here is that you need to push a request from your Google sheets.
To my understanding, Google sheets mainly uses python for scripting and recently @isotherm has contributed a python project for Manager API.
I think this should be a good place to start