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 720 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

      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

      karsten13K R 2 Replies Last reply Reply Quote 0
      • karsten13K Offline
        karsten13 @mlm198
        last edited by

        @mlm198

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

        S 1 Reply Last reply Reply Quote 0
        • S Away
          sdetweil @karsten13
          last edited by

          @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

            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 Reply Quote 0
            • S Away
              sdetweil @mlm198
              last edited by

              @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

                @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