Plugin Author
Meitar
(@meitar)
Are you sure you have successfully:
- Shared your spreadsheet publicly? (See the first screenshot from this plugin’s documentation for guidance.)
- Copy and pasted the correct URL into your shortcode’s
key attribute?
My hunch is that you’re using a shortcode more like this:
[gdoc key="1vA-V18Bx9BrCfzlaXKkiFns3hbltuA_mV7DPPA75GuI"]
when you should be using a shortcode more like this:
[gdoc key="http://docs.google.com/spreadsheets/d/1vA-V18Bx9BrCfzlaXKkiFns3hbltuA_mV7DPPA75GuI/edit"]
It’d also help if you actually posted the shortcode you’re using.
Hi there,
Thanks for the reply – yep, so the s/s is shared publicly, I’m using different tabs for different pages. This is the first time this has happened…
Here’s the shortcode:
For the top version
[gdoc key=”https://docs.google.com/spreadsheets/d/1vA-V18Bx9BrCfzlaXKkiFns3hbltuA_mV7DPPA75GuI/edit#gid=173881320″ use_cache=”no” title=”Top-rated horses” datatables_paging=”false” datatables_scroll_x=”true” style=”width: 100%” style=”font-size: 10px”]
For the broken version:
[gdoc key=”https://docs.google.com/spreadsheets/d/1vA-V18Bx9BrCfzlaXKkiFns3hbltuA_mV7DPPA75GuI/edit#gid=173881320″ use_cache=”no” title=”Top-rated horses” query=”select A, B” datatables_paging=”false” datatables_scroll_x=”true” style=”width: 100%” style=”font-size: 10px”]
Plugin Author
Meitar
(@meitar)
Doesn’t seem to be a problem with the plugin; the URL being requested is https://docs.google.com/spreadsheets/d/1vA-V18Bx9BrCfzlaXKkiFns3hbltuA_mV7DPPA75GuI/gviz/tq?tqx=out:csv&tq=select%20A%2C%20B&gid=173881320, which is exactly the data being displayed. You can see this for yourself by hitting the HTML version of the same query result from Google. In other words, the data being displayed by the plugin is the data being returned by Google. You might want to consider asking your question on the Google Sheets product support forums.
