Title: Plugin generating response code 400 errors
Last modified: August 27, 2017

---

# Plugin generating response code 400 errors

 *  Resolved [sipitai](https://wordpress.org/support/users/sipitai/)
 * (@sipitai)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/plugin-generating-response-code-400-errors/)
 * Hi Dan,
 * Your plugin doesn’t seem to be working for me.
 * I’ve setup a fresh install of WordPress, with just your plugin installed.
 * I’ve created a test Google Sheet with some basic test data, and set it’s sharing
   permissions to “Anyone on the internet can find and edit”.
 * I’ve created a project via the Google Developers Console and created an API key.
 * It’s worth noting both the Google Sheet and project were created using the same
   Google account.
 * I’ve filled in the API Key and Folder ID fields in the plugin settings.
 * I’ve created a page and added the [dansheet] shortcode.
 * But when I view the page it doesn’t display anything. Looking at the HTML it’s
   just outputting `<span class="gsheets-single-value "></span>`
 * I double checked everything, but I couldn’t spot any mistakes.
 * To test I enabled the Google Sheets API for my Google account. This didnt fix
   the problem, but it gave me access to Traffic and Errors panels, which note the
   plugin is generating response code 400 errors via the method ‘google.apps.sheets.
   v4.SpreadsheetsService.GetValues’.
 * I’m assuming here is that the plugin no longer works with either the latest version
   of the Google Sheets API or WordPress, but it’s possible I’ve setup something
   incorrectly.
 * Any ideas what the problem might be here? I’m happy to provide you with logins
   in required.

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

 *  Plugin Author [Dan D](https://wordpress.org/support/users/duplaja/)
 * (@duplaja)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/plugin-generating-response-code-400-errors/#post-9445121)
 * Hello! I have updated everything on my test server, and it seems to be working
   ok. Would it be possible for you to share the sheet ID that you are using, so
   I can try to track this down?
 * Thanks!
 * Dan
 *  Plugin Author [Dan D](https://wordpress.org/support/users/duplaja/)
 * (@duplaja)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/plugin-generating-response-code-400-errors/#post-9445264)
 * We were able to track this down, for anyone who reads this. The confusion came
   from the sheetname parameter, from some ambiguity on the naming of things in 
   Google Sheets. The sheetname parameter is for the “tab” name at the bottom, not
   the name of the document itself.
 *  Thread Starter [sipitai](https://wordpress.org/support/users/sipitai/)
 * (@sipitai)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/plugin-generating-response-code-400-errors/#post-9445291)
 * Thanks again Dan!
 * Further to what Dan’s said above, when using the [dansheet] shortcode, you must
   set the ‘cell’ parameter.
 * Just [dansheet] by itself wont return any cells, but [dansheet cell=A1:E5] for
   example will.

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

The topic ‘Plugin generating response code 400 errors’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/dans-gsheets.svg)
 * [Dan's GSheets Data Embedder](https://wordpress.org/plugins/dans-gsheets/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/dans-gsheets/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/dans-gsheets/)
 * [Active Topics](https://wordpress.org/support/plugin/dans-gsheets/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/dans-gsheets/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/dans-gsheets/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [sipitai](https://wordpress.org/support/users/sipitai/)
 * Last activity: [8 years, 9 months ago](https://wordpress.org/support/topic/plugin-generating-response-code-400-errors/#post-9445291)
 * Status: resolved