[Gsheets integration help - API script request] read values from a google docs Spreadsheet

Is there any way to read a value from a cell in a public online Google Sheets and parse it anywhere using token-mod or change-char-attribute? I know that on regular web pages it is a straightforward operation in JS but I dont understand how that can relate inside the Roll20 API . We have a very solid spreadsheet for managing the party's equipment and I'd love to have it pass values inside my game to token names, handouts and character attributes; that would enable me to show precise info on the party's Vault page and let the PC act accordingly and interactively during pauses. -- the next logic step would be to find a way for Roll20 itself to write values to the spreadsheet instead of updating it manually but I sense that's out of the realm of possibilities for the API. Any thought or consideration appreciated!

The API is completely sandboxed, it can't access external resources.  If you wanted to be able to pull this sort of information into a game, you'd probably need to create some sort of proxy that could do the requests and provide the responses, then feed them to the API in a live game.  Probably you'd do that with a browser extension.

Thank you for the prompt answer Aaron, I'll take this out of my to-do for the near future. The proxy solution sounds neat but I'm long way from writing an interfaced browser extension at the moment. this topic might be now closed I guess.

You might be surprised at how easy it is to write a Browser Extension.  =D  (Not that I'm volunteering, just saying you probably aren't as far off from it as you think you are.)