• Resolved isadork

    (@isadork)


    I set up the API access correctly, it is showing that I’m getting 100% Errors on google.apps.sheets.v4.SpreadsheetsService.GetValues

    I’ve correctly applied the Folder ID as per the instructions, and I’ve even pasted example shortcodes to ensure that I’m not making a typo. I’ve used both the default Sheet1 and the actual sheet name, and I’ve tried both single cells and ranges.

    Nothing is working for me. Any help would be appreciated.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Dan D

    (@duplaja)

    @isadork , hello!

    Would you be able to share a link to the page with the calendar embedded?

    Thank you,
    Dan

    Thread Starter isadork

    (@isadork)

    Sorry about this, it was a dumb mistake on my part – I shared by “Publishing to the Web” and not by the actual “Share” button to make it viewable for anyone on the web. After making it viewable to anyone on the web, it worked perfectly.

    Plugin Author Dan D

    (@duplaja)

    Hey, no worries! I’m glad that it’s working well for you now!

    Hi, this is a great idea but wish I could get it to work!

    I have the API configured and a Google Sheet ID added. When I try the [dansheet cell=A1:E5] shortcode, nothing appears on the page. I ran a debug and get:

    Notice: Undefined index: values in /var/www/html/wp-content/plugins/dans-gsheets/dans-gsheets.php on line 178

    Warning: Invalid argument supplied for foreach() in /var/www/html/wp-content/plugins/dans-gsheets/dans-gsheets.php on line 178

    This is the page I’m running the shortcode on: https://code1web.com/dan-test/
    This is the Google Sheet ID I’m referencing: 1y7q2q6WexU2snXX3SUIOcVC6vDHLshFl7csrm9WOf88

    Thanks in advance!

    • This reply was modified 5 years, 1 month ago by rshok.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Errors’ is closed to new replies.