Also looked in the API stats at Google and there are quite a few 429 errors. The way the data was laid out I had to use a shortcode for every single cell that I needed.
What I am doing as a work around right now is created another sheet where I am bringing the data together so that I can make 8 calls instead of 50. The super WIN is that I was able to style rows even though there was one call and therefore only one class speced in the shortcode with one weird trick! Since the sheet I created to gather the data in chunks was mostly just cell references, I used the CONCATENATE function to add a formula like this:
=CONCATENATE("<div class='menu-disc-left'>",'Food Right'!A24,"</div>")
To my amazement the HTML pulled in from the Google sheet was rendered not just printed as plain text.
PERFECT! This creates some really powerful options!
