Error loading Google Spreadsheet data

That’s an old style Google Sheet so your key should just be 0AkssTOsw2NNddGZTVXR4VWxpNGpyNW1nYVc1Um5DOGc.

Thanks for getting back to me, but this doesn’t seem to have fixed it. Now my code looks like this:

[gdoc key=”0AkssTOsw2NNddGZTVXR4VWxpNGpyNW1nYVc1Um5DOGc”]

And I get the same error message:

[Error loading Google Spreadsheet data. Make sure your Google Spreadsheet is shared using either the “Public on the web” or “Anyone with the link” options.]

Here’s the page: https://www.escapadecon.net/?p=454

My wordpress version is 4.0.1, if that makes any difference.

You have not yet published your Spreadsheet to the Web. Choose File -> Publish to the Web, like the FAQ and countless other support threads here mention you need to do.

OK, I’m really confused. I did read your documentation and followed the instructions to share my spreadsheet to the web. I checked this by pasting the google docs link in my first message in several browsers where I am not logged in to google, and was able to view the spreadsheet just fine.

I have embedded screen caps showing the sharing status of my spreadsheet in the page with the non-working link:

https://www.escapadecon.net/schedule/

OTOH, I pasted the key from a previously shared document, and it did embed, so your diagnosis seems accurate. I just don’t know what else I need to do, once google tells me that the document is shared publicly.

I am not familiar with the old/new google spreadsheet format. Do you think it would make a difference if I upgraded my spreadsheet to the newer format?

“Publish to the Web” is not the same as “share with the public.” For an old Google Sheet (yours) you must “Publish to the Web.” “Sharing” isn’t relevant. Go to the File menu and select “Publish to the Web.”

Sorry this is terse, I am on my phone.

Thank you! I need to work on my reading comprehension. I’m sorry to have wasted your time.

I did all you said but it din’t work (my google drive is in portuguese but it obviouly shouldn’t affect the result), see screenshots below:

What screenshots, Daniel? Double (and maybe triple) check that you’ve made your spreadsheet available correctly. That’s almost certainly the issue, as mentioned above.

https://www.congressomv.org/wp-content/uploads/2015/01/publish.png
https://www.congressomv.org/wp-content/uploads/2015/01/frontend.png
https://www.congressomv.org/wp-content/uploads/2015/01/backend.png

I have been trying to get my google spreadsheet to show up on my wordpress site.

It is published to the web and ALSO publically shared by link
At first it said there was an error getting the spreadsheet, but now, nothing happens at all, and it just shows the code:

[ gdoc key= ” https://docs.google.com/spreadsheets/d/1xFCm-h5zXHMCtTIIGmVdolnNIaDk_n8ogOgZrqY/pubhtml ” ]

please advise

nevermind, I took out the spaces and got it

ashleyashley, as I’m glad you’ve figured out by now, I see a “Google Drive — Page Not Found” error page when I try to follow the link to your spreadsheet.

So, just in case others find this thread in the future: If you indeed have the correct URL but you see a “Page Not Found” error when you try following it, then you have not yet shared the spreadsheet publicly. Try double-checking that you have followed Google’s instructions for how to share a spreadsheet with anyone on the Web. Alternatively, make double (or triple!) sure that you have the correct URL.

Good luck. ??

Daniel, the problem you’re encountering is that you’re using the old-style key with a new-style Google Sheet. Try using the full URL that Google gives you (just copy-and-paste it) in your shortcode’s key parameter, not only the sheet ID itself.

In other words, you need something more like this:

[gdoc key="https://docs.google.com/spreadsheets/d/ABCDEFG/pubhtml"]

and not, as you currently have it, like this:

[gdoc key="ABCDEFG"]

Hope this helps. ??

Ok, it worked out

After copying the url, I had to to change the ending:

Instead of [gdoc key=”https://docs.google.com/spreadsheets/d/ABCDEFG/edit#gid=0″%5D

i put [gdoc key=”https://docs.google.com/spreadsheets/d/ABCDEFG/pubhtml”%5D

Thanks

Glad you got it working, Daniel.

Yeah, I think I might have to rework the key/gid inputs again now that Google is changing those around in their UI a little bit. :\