Exporting data to google sheets?

I've seen a few forum posts talking about the other way around, however I wanted to know if there was a way of grabbing roll20 data using google sheet. I need more than 3 resource bars for my character, and I want to make a sheets template that shows all the bars. While I can update them separately, it would be really nice if I could have the numbers reference the values on the character sheet, and change when I change them on the character sheet in game. This is where my issue is at the moment. I managed to get some success by popping out the sheet into it's own page and using that URL, but it only returns empty without errors. I've also tried using the character vault URL and I managed to get some information, just not from the sheet itself. (it was the menus and drop down lists specifically). Is there a way of doing this without having to manually change the information in two different places?

Hi Rules! I think this level of connectivity, (if even possible), would require a custom browser extension. It's beyond what can be done with URL references or even the Mod system. It's certainly beyond my skills. More to the point of your question, though, what exactly are you looking to do? "Sheets template" implies that you are creating a character sheet, yet bars are the province of tokens. If you can explain a bit more about what you are trying to do on the basic level, it might help folks come up with creative solutions (such as using multiple tokens). Also of help would be knowing what sheet you are using.

I think "sheet template" was a bit of poor wording on my part. It's just a google sheet that has multiple bars (for the DnD5e sheet by roll20), like the ones tied to the radial bubbles. I wanted to pull information from the additional resources of the sheet, like @{other_resource} and the other ones as well as Hit Points and Spell Slots. So the bars on the spreadsheet read the numbers from the sheet, and just display the results. I attached an "output" example below. All I'd want is just the raw numbers. I like the bars, and some of the builds I'd have (in theory) could do with as many as 5-12 of them with items and hopefully put the whole party's stuff on a single page. If I could pull numbers from roll20 as I've described, or something similar, then I could probably use it for a few more things, this is just the first one I was working on.