ryan-d-williams / MMM-GoogleSheets

Google Sheets Module for MagicMirror
23 stars 2 forks source link

"..Loading.." #17

Closed richcj10 closed 3 years ago

richcj10 commented 3 years ago

Any thoughts on how to debug?

` { module: "MMM-GoogleSheets", header: "House Rules", position: "top_center", config: { url: "https://script.google.com/macros/s/AKfycbwsIT7L5aJYwLip1s7Clrorg1r_wNsEOctO1dz5/exec", sheet: "HouseRules", range: "A1:B2", } },

`

Any way to debug it?

ryan-d-williams commented 3 years ago

Looks like there is not a sheet with the name "HouseRules". You should start by verifying that there is a sheet with that exact name.

richcj10 commented 3 years ago

image

There should be...

ryan-d-williams commented 3 years ago

@richcj10 "HouseRules" is the name of the spreadsheet, not the name of the sheet. The name of the sheet is at the bottom of the screen.

It seems as though the sheet name is "Sheet1". If you change the sheet name to "Sheet1" in your config file it should work as expected.

richcj10 commented 3 years ago

LOL, thanks for that... I feel so stupid...haha

ryan-d-williams commented 3 years ago

Happy to help!