• Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
MagicMirror Forum
  • Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
A New Chapter for MagicMirror: The Community Takes the Lead
Read the statement by Michael Teeuw here.

MMM-GoogleSheets Not loading

Scheduled Pinned Locked Moved Unsolved Troubleshooting
6 Posts 4 Posters 684 Views 3 Watching
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    mlm198
    last edited by Feb 28, 2022, 9:40 PM

    Hi,

    I am having issues with getting the module working. I have followed the instructions as per https://github.com/ryan-d-williams/MMM-GoogleSheets.

    However when loading all it says is “loading…”.

    Looking in the log it says:
    28.02.2022 21:37.41.094] [LOG] Connecting socket for: MMM-GoogleSheets
    [28.02.2022 21:37.41.096] [LOG] ====================== Starting node_helper for module [MMM-GoogleSheets]
    [28.02.2022 21:37.41.097] [LOG] Sockets connected & modules started …
    [28.02.2022 21:37.41.617] [LOG] Launching application.
    [28.02.2022 21:37.44.794] [ERROR] Whoops! There was an uncaught exception…
    [28.02.2022 21:37.44.810] [ERROR] SyntaxError: Unexpected token < in JSON at position 1
    at JSON.parse ()
    at Request._callback (/home/pi/MagicMirror/modules/MMM-GoogleSheets/node_helper.js:47:27)
    at Request.self.callback (/home/pi/MagicMirror/node_modules/request/request.js:185:22)
    at Request.emit (events.js:315:20)
    at Request. (/home/pi/MagicMirror/node_modules/request/request.js:1154:10)
    at Request.emit (events.js:315:20)
    at IncomingMessage. (/home/pi/MagicMirror/node_modules/request/request.js:1076:12)
    at Object.onceWrapper (events.js:421:28)
    at IncomingMessage.emit (events.js:327:22)
    at endReadableNT (_stream_readable.js:1220:12)
    [28.02.2022 21:37.44.815] [ERROR] MagicMirror will not quit, but it might be a good idea to check why this happened. Maybe no internet connection?
    [28.02.2022 21:37.44.817] [ERROR] If you think this really is an issue, please open an issue on GitHub: https://github.com/MichMich/MagicMirror/issues

    Any help would be appreciated.

    Best wishes

    Matthew

    K R 2 Replies Last reply Feb 28, 2022, 9:46 PM Reply Quote 0
    • K Online
      karsten13 @mlm198
      last edited by Feb 28, 2022, 9:46 PM

      @mlm198

      see https://forum.magicmirror.builders/topic/15778/fix-for-black-screen-in-2-16-and-later

      S 1 Reply Last reply Feb 28, 2022, 9:52 PM Reply Quote 0
      • S Offline
        sdetweil @karsten13
        last edited by Feb 28, 2022, 9:52 PM

        @karsten13 I don’t think that is the problem.

        I think the Google API isn’t authenticated.
        and downloaded credentials file

        Sam

        How to add modules

        learning how to use browser developers window for css changes

        1 Reply Last reply Reply Quote 0
        • M Offline
          mlm198
          last edited by Feb 28, 2022, 10:17 PM

          I couldn’t work out how to run the script in full for the fix blacl screen.

          I got up to "npm install ??? " but then I don’t have a module to install.

          Can you point me in the right direction of authenticating the API and downloading credentials. Also where do I put that?

          THanks for your help.

          Matthew

          S 1 Reply Last reply Feb 28, 2022, 10:27 PM Reply Quote 0
          • S Offline
            sdetweil @mlm198
            last edited by Feb 28, 2022, 10:27 PM

            @mlm198 I see he does this a different way. did u do all of step 1?

            Screenshot_20220228-152628_Chrome.jpg

            Sam

            How to add modules

            learning how to use browser developers window for css changes

            1 Reply Last reply Reply Quote 0
            • R Offline
              ryandwilliams @mlm198
              last edited by Aug 10, 2024, 2:56 PM

              @mlm198 This error is usually caused by not deploying the google apps script correctly. I have updated the README with pictures to hopefully make the deployment easier. Feel free to add an issue to the repo if you are still having problems.

              1 Reply Last reply Reply Quote 0
              • 1 / 1
              • First post
                Last post
              Enjoying MagicMirror? Please consider a donation!
              MagicMirror created by Michael Teeuw.
              Forum managed by Sam, technical setup by Karsten.
              This forum is using NodeBB as its core | Contributors
              Contact | Privacy Policy