Google Login Displaying instead of Spreadsheet

What shortcode are you using?

Also, if https://docs.google.com/spreadsheets/d/1-K5W8MOpL1vpTmmrbEQTEFNFPsZsdpJuG5dHJ4soADI/pub is the URL of the spreadsheet you’re trying to load, note that this is not a publicly shared spreadsheet. You can tell because when you log out of your Google account and click that link, you are greeted with a login page.

This is exactly why the FAQ and the screenshots both describe how to share your spreadsheet publicly. Here’s that link (again):

Make sure the Spreadsheet is “Public on the web.” Learn more about Google Docs sharing settings.

Hi Meitar thanks for responding so quickly. I used the share setting “Anyone with the link can view” but I will try again with making it public on the web.

Here is the shortcode I am using: [gdoc key=”1-K5W8MOpL1vpTmmrbEQTEFNFPsZsdpJuG5dHJ4soADI” use_cache=”no”]

I’m confused by Google’s settings. In the share popup menu, it states that using the “Anyone with the link can view” option, no sign-in should be required. See this screencap: Google Sharing Settings Screenshot

I will try setting as public on the web. Thanks again for the response and getting back to me, I did read the FAQ and saw the screenshots however the part that was confusing was Google’s options.

I set the spreadsheet to public on the web and I am still seeing the google login screen. Test page

Do you think there is something I did not configure properly for the plugin?

I have tested the spreadsheet in incognito, it is visible publicly here: Google docs public view test spreadsheet

You may have disabled “downloading” in the advanced options. See this other thread.

You can’t really disable downloading because everything you look at on the Internet is something your computer has already downloaded. That’s how the Internet works. What that option actually disables is CSV exports, which is how this plugin works.

I did not disable options to download the spreadsheet, I know how the internet works – that shouldn’t be the problem because I haven’t enabled disable downloading. The login screen is still appearing with a full public view access enabled, the issue is not yet resolved on my end.

Oh, use the full URL to your sheet, not just the ID part.

[gdoc key="https://docs.google.com/spreadsheets/d/1-K5W8MOpL1vpTmmrbEQTEFNFPsZsdpJuG5dHJ4soADI/edit"]

Ok I will try that

That worked, thanks mate. Quick question – is it possible to disable the CSV, Excel, and PDF and Print buttons?

Looks great now. Seriously appreciate the help.

Oh, it did work? I thought you said it did not work. (I got an email saying you posted that it did not work, maybe you edited your post response?) If it worked, disregard the rest of this post. If it didn’t work, you might need to continue reading.

If it did not work, I suspect you have another plugin interfering with this one’s shortcode in some way. I had no problem getting your spreadsheet to show up. (Screenshot.) I suggest following the plugin troubleshooting guidelines to discover which other plugin is causing the problem. If I had to take a complete guess, I’d say it might be the Magic Liquidizer Responsive Table you’re using, but I can’t say for sure. You’ll have to disable all your plugins except this one and then turn them back on one at a time to find out which one causes the issue.

Quick question – is it possible to disable the CSV, Excel, and PDF and Print buttons?

Yes, read the FAQ under the headline “How do I change the default settings, like can I turn paging off? Can I change the page length? Can I change the sort order?”

You’ll want to remove the B from the DataTables dom option, so you’ll add datatables_dom="YOUR_PATTERN_HERE" where “YOUR_PATTERN_HERE” is whatever DataTables dom option keys you want to use.

Ok I can do that – does that need to be added as javascript in the theme, or is that placed inside the shortcode I use to generate the table?

Thanks