So I was able to work through the Google Sheet NPM and got everything working on my site, where I can edit and access a given Google Sheet that has information I need for my site. I wanted to simply pass this data into an array that I can call on for my page, however am having trouble with the JSON formatting of the cell values. At best I have been able to use stringify() to show me
{
“values:” […
}
followed by all the information I am actually interested in. So in simplest terms, is there an easy way, using JSON parse or stringify to just return the exact string in a given cell without any of the formatting?
I’m using Google Sheets as I;ve already programmed a sheet that receives automated information from another source, so it seemed like the simplest way to pass that on. I’ve considered using pastebin, or another 3rd party site where I could store the text privately, that could just be fetched but just ended up back at Google Sheets due to captchas. Any suggestions would be super helpful. Thanks!