First, your query URL needs to be adjusted slightly:
https://docs.google.com/spreadsheets/d/16HsbYp-W-keFce7CvPBVPPdxSFR_eSoQ5-P4Y791xjk/
gviz/tq. That will return the data in the appropriate format. To get the
data from cell f2, you have to make a second query to this
URL:
Andrew you are a star! I've seen you post solutions for lots of people on
here - thanks so much for your time.
On Friday, 5 September 2014 11:32:17 UTC+10, Andrew Gallant wrote:
First, your query URL needs to be adjusted slightly: