The documentation in the example migration refers to making the sheet "Public" or that "Anyone with link can view". I was also required to take an additional step and "Publish to the web" for my sheet to be viewable at the feed url.

A note to this effect should be added:

Sheets must be "Published to the web" to be properly accessed. This is found under: File > Publish to the web...

Comments

aprice42 created an issue. See original summary.

duaelfr’s picture

duaelfr
he/him
Primary language French
Location Montpellier, France
commented
Assigned: aprice42 » Unassigned

I found out a tutorial on Medium to figure out what to do: https://medium.com/@scottcents/how-to-convert-google-sheets-to-json-in-j...
It'd be nice to only have to put the sharing URL without having to edit it and the module would extract the part it needs.

  • gcb committed b2e95d8 on 8.x-1.x 
    Add publish hint to readme. #3063859
gcb’s picture

gcb
he/him
Location Portland, OR
commented
Status: Active » Fixed

Good idea, thanks!

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.