Getting "Error Loading Google Spreadsheet Data" Error, only sometimes.

  • Resolved sshanky

    (@sshanky)


    11 years, 7 months ago

    Hi,

    I know I’ve set up the plug in correctly because when I use the URL of a new, test spreadsheet I make, it works perfectly. However, when I use the URL of the sheet I need to embed, I get:

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

    I’ve tried everything I can think of with sharing options — public on the web, anyone with the link, etc. I’m pulling my hair out trying to figure out what makes that particular spreadsheet different from the one I’m able to make work. I do have the spreadsheet shared with a number of people who have Edit access, and it is in a “folder” on google drive. But I also tried adding a user to the other spreadsheet and provided him edit access, and the sheet continued to work inside my wordpress page, and I’ve tried removing the spreadsheet from its folder and placing it in the root of my drive. Nothing makes it work.

    I’m using the “new” google spreadsheets, so I am using this in my wordpress page:

    [https://docs.google.com/spreadsheet/ccc?key=0Ao6Hzg0Rx_kTdGhCZ3NSWjdENlZKRlp1N3dJUklJS1E&usp=drive_web#gid=2]

    I’ve also tried:

    [gdoc key=”https://docs.google.com/spreadsheet/ccc?key=0Ao6Hzg0Rx_kTdGhCZ3NSWjdENlZKRlp1N3dJUklJS1E” gid=”2″]

    (separating the gid parameter as suggested in your readme.txt file), but this also did not work.

    Any input here would be most appreciated. Thank you.

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Meitar

    (@meitar)

    11 years, 7 months ago

    FWIW, that’s the URL for the old Google Spreadsheets. The new ones look like like https://docs.google.com/spreadsheets/d/ABCDEFG/edit. If you’re really using the new Google Spreadsheets, try [gdoc key="https://docs.google.com/spreadsheets/d/0Ao6Hzg0Rx_kTdGhCZ3NSWjdENlZKRlp1N3dJUklJS1E/edit"] instead. If that doesn’t work, maybe your spreadsheet is really an old-style spreadsheet, in which case try [gdoc key="0Ao6Hzg0Rx_kTdGhCZ3NSWjdENlZKRlp1N3dJUklJS1E"].

    Thread Starter sshanky

    (@sshanky)

    11 years, 7 months ago

    Thanks Meitar

    I think you’re right about my spreadsheet being old-style. I didn’t realize it was spreadsheet specific — I thought just the “engine” updated. In any case, I just tried changing the code as you suggested and it didn’t work. I put:

    [gdoc key=”0Ao6Hzg0Rx_kTdGhCZ3NSWjdENlZKRlp1N3dJUklJS1E”]

    and also

    [gdoc key=”0Ao6Hzg0Rx_kTdGhCZ3NSWjdENlZKRlp1N3dJUklJS1E” gid=”2″]

    Neither one worked for me.

    The actual URL for the sheet in question is:

    https://docs.google.com/spreadsheet/ccc?key=0Ao6Hzg0Rx_kTdGhCZ3NSWjdENlZKRlp1N3dJUklJS1E&usp=drive_web#gid=2

    Do you have any other ideas? Thanks!

    Plugin Author Meitar

    (@meitar)

    11 years, 7 months ago

    sshanky, when I access it, Google tells me your document is not published. From the spreadsheet editor, go to the File menu, then select “Publish to the web” (as described in this plugin’s FAQ).

    Thread Starter sshanky

    (@sshanky)

    11 years, 7 months ago

    Yes, Meitar, you’re right. I should have figured that out, and read the FAQ more carefully. The fact that I was logged must have fooled me into thinking the URL was working.

    Thank you so much for your assistance with this. I’ll work on a donation for you.

    Plugin Author Meitar

    (@meitar)

    11 years, 7 months ago

    🙂 Thanks. Donations are very highly appreciated.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Getting "Error Loading Google Spreadsheet Data" Error, only sometimes.’ is closed to new replies.