Title: Not retrieving data
Last modified: August 16, 2017

---

# Not retrieving data

 *  [eivindeh@gmail.com](https://wordpress.org/support/users/eivindehgmailcom/)
 * (@eivindehgmailcom)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/not-retrieving-data/)
 * Hi
 * I can’t seem to get the plugin to retrieve data from my sheet. It’s public and
   I’ve created a google sheet API, but nothing is happening.
 * What I’m seeing in the Google Developer Console does not match your description.
   Is it possible that the process has changed since you wrote the guide? What are
   the correct steps now?
 * I’m also not seeing the same options as you described to make the spreadsheet
   public.
 * I’m hoping you can help me as the plugin seems perfect!
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fnot-retrieving-data%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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/not-retrieving-data/#post-9445118)
 * Hello! I apologize for taking so long to get back to you. Would you be able to
   share the sheet ID that you’re using, so I can test from my end? Thanks!
 * Dan
 *  [sipitai](https://wordpress.org/support/users/sipitai/)
 * (@sipitai)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/not-retrieving-data/#post-9445324)
 * Hi eivindeh,
 * The current steps for the Google Developer Console part are as follows:
 * 1). Visit [https://console.developers.google.com/](https://console.developers.google.com/)
   
   2). Click on ‘Credentials’ in the left side menu. – If required, create a new
   project. 3). Click on the blue ‘Create credentials’ button, then click ‘API key’.
   4). Click the ‘Close’ button.
 * Also try the shortcode [dansheet cell=A1:E5] and see if that displays any data.
 *  [mahadavid](https://wordpress.org/support/users/mahadavid/)
 * (@mahadavid)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/not-retrieving-data/#post-9995811)
 * Hi, thanks for your efforts…
 * I’m having a similar issue.
 * On this page:
    [http://mhg.davividdesign.com/test/](http://mhg.davividdesign.com/test/)
 * I get this error:
    Warning: Invalid argument supplied for foreach() in /home2/
   daviv592/mhg.davividdesign.com/wp-content/plugins/dans-gsheets/dans-gsheets.php
   on line 178
 * this is the sheet:
    [https://docs.google.com/spreadsheets/d/1dfyTHBYQMeNh6wKTmoS0vuhiYi2CXagGJmNDFGFyndc](https://docs.google.com/spreadsheets/d/1dfyTHBYQMeNh6wKTmoS0vuhiYi2CXagGJmNDFGFyndc)
 * The sheet has the setting “anyone with link can view”
 * this is what I have in sheet ID:
    1dfyTHBYQMeNh6wKTmoS0vuhiYi2CXagGJmNDFGFyndc
 * I have created two different api keys and tried with both.
 * this is the call:
    [dansheet cell=B2:B5]
 * Wordpress 4.8.5
    Divi theme 3.0.4.0
 * Thanks in advance for any input!

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

The topic ‘Not retrieving data’ 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
 * 4 participants
 * Last reply from: [mahadavid](https://wordpress.org/support/users/mahadavid/)
 * Last activity: [8 years, 3 months ago](https://wordpress.org/support/topic/not-retrieving-data/#post-9995811)
 * Status: not resolved