search

ryan-d-williams / MMM-GoogleSheets

Google Sheets Module for MagicMirror
23 stars 2 forks source link

Unable to get data on MM #13

Closed nymeia closed 3 years ago

nymeia commented 3 years ago

My sheet keeps saying Loading ...

I have added your script to my Google Sheet: function doGet(e){ return MMMGoogleSheets.doGet(e); }

When trying to go to my script URL it says: ReferenceError: MMMGoogleSheets is not defined (regel 2, bestand 'Code')

When i run PM2 LOGS from the console i get the following error:

0|MagicMirror | [18.01.2021 15:07.59.957] [ERROR] 0|MagicMirror | Whoops! There was an uncaught exception... 0|MagicMirror | [18.01.2021 15:07.59.961] [ERROR] SyntaxError: Unexpected token < in JSON at position 0 0|MagicMirror | at JSON.parse () 0|MagicMirror | at Request._callback (/home/pi/MagicMirror/modules/MMM-GoogleSheets/node_helper.js:47:27) 0|MagicMirror | at Request.self.callback (/home/pi/MagicMirror/node_modules/request/request.js:185:22) 0|MagicMirror | at Request.emit (events.js:210:5) 0|MagicMirror | at Request. (/home/pi/MagicMirror/node_modules/request/request.js:1154:10) 0|MagicMirror | at Request.emit (events.js:210:5) 0|MagicMirror | at IncomingMessage. (/home/pi/MagicMirror/node_modules/request/request.js:1076:12) 0|MagicMirror | at Object.onceWrapper (events.js:299:28) 0|MagicMirror | at IncomingMessage.emit (events.js:215:7) 0|MagicMirror | at endReadableNT (_stream_readable.js:1183:12) 0|MagicMirror | [18.01.2021 15:07.59.965] [ERROR] MagicMirror will not quit, but it might be a good idea to check why this happened. Maybe no internet connection? 0|MagicMirror | [18.01.2021 15:07.59.969] [ERROR] If you think this really is an issue, please open an issue on GitHub: https://github.com/MichMich/MagicMirror/issues 0|MagicMirror | [18.01.2021 15:08.02.084] [INFO]

My permissions are set correctly, when i try another script I get "request received".