• Resolved jalonssprl

    (@jalonssprl)


    Hi there.

    The plugin seems correctly installed.

    The shortcode is also written as it should:

    [gdoc key=”1S2vtTJKWKh2HxvEyKzkQ7RfQOaSN-TN9waFr3WARetE” gid=”4″]

    The sharing option of the G. Sheet is set to Public on the web.

    But, the only result I get is:

    [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.]

    Some help will be really appreciated here. :o)

    https://ww.wp.xz.cn/plugins/inline-google-spreadsheet-viewer/

Viewing 1 replies (of 1 total)
  • Plugin Author Meitar

    (@meitar)

    That shortcode is referencing the URL at https://docs.google.com/spreadsheets/pub?key=1S2vtTJKWKh2HxvEyKzkQ7RfQOaSN-TN9waFr3WARetE which as you can see does not exist. This is what’s known as an “old style” Google Spreadsheet. From the plugin’s readme:

    After setting the appropriate Sharing setting, copy the URL you use to view the Spreadsheet from your browser’s address bar into the shortcode. For example, to display the spreadsheet at https://docs.google.com/spreadsheets/d/ABCDEFG/edit, use the following shortcode in your WordPress post or page:

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

    If your spreadsheet uses the “old” Google Spreadsheets, you need to ensure that your spreadsheet is “Published to the Web” and you need to copy only the “key” out of the URL. For instance, if the URL of your old Google Spreadsheet is https://docs.google.com/spreadsheets/pub?key=ABCDEFG, then your shortcode should look like this:

    [gdoc key="ABCDEFG"]

    The sheet you’re trying to view is a “new” Google Spreadsheet, so its URL is like this:
    https://docs.google.com/spreadsheets/d/1S2vtTJKWKh2HxvEyKzkQ7RfQOaSN-TN9waFr3WARetE

    During 2014, Google transitioned from the old to the new styles but some old styles remain. This plugin was first written about 5 years ago, and still supports both old and new style Google Sheets (though some advanced features only work when used with a new style google sheet).

    Hope this helps.

Viewing 1 replies (of 1 total)

The topic ‘Google Sheet not showing.’ is closed to new replies.