Title: Getting "Error Loading Google Spreadsheet Data" Error, only sometimes. Last modified: August 22, 2016 --- # Getting "Error Loading Google Spreadsheet Data" Error, only sometimes. * Resolved [sshanky](https://wordpress.org/support/users/sshanky/) * (@sshanky) * [11 years, 7 months ago](https://wordpress.org/support/topic/getting-error-loading-google-spreadsheet-data-error-only-sometimes/) * 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”](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://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 7 months ago](https://wordpress.org/support/topic/getting-error-loading-google-spreadsheet-data-error-only-sometimes/#post-5375073) * 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](https://wordpress.org/support/users/sshanky/) * (@sshanky) * [11 years, 7 months ago](https://wordpress.org/support/topic/getting-error-loading-google-spreadsheet-data-error-only-sometimes/#post-5375080) * 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](https://docs.google.com/spreadsheet/ccc?key=0Ao6Hzg0Rx_kTdGhCZ3NSWjdENlZKRlp1N3dJUklJS1E&usp=drive_web#gid=2) * Do you have any other ideas? Thanks! * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 7 months ago](https://wordpress.org/support/topic/getting-error-loading-google-spreadsheet-data-error-only-sometimes/#post-5375188) * sshanky, when I [access it](https://docs.google.com/spreadsheet/pub?key=0Ao6Hzg0Rx_kTdGhCZ3NSWjdENlZKRlp1N3dJUklJS1E), 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](https://wordpress.org/support/users/sshanky/) * (@sshanky) * [11 years, 7 months ago](https://wordpress.org/support/topic/getting-error-loading-google-spreadsheet-data-error-only-sometimes/#post-5375229) * 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](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 7 months ago](https://wordpress.org/support/topic/getting-error-loading-google-spreadsheet-data-error-only-sometimes/#post-5375258) * 🙂 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. * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer. svg) * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq) * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/) * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/) * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/) * 5 replies * 2 participants * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/) * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/getting-error-loading-google-spreadsheet-data-error-only-sometimes/#post-5375258) * Status: resolved