• 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] Display Google Sheets data on your MagicMirror

Scheduled Pinned Locked Moved Utilities
15 Posts 4 Posters 1.5k Views 5 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.
  • S Offline
    santex
    last edited by Jan 17, 2025, 5:22 PM

    Sorry, i followed all the necessary step and i’m getting this for the googlesheet

    [ERROR] [MMM-Google-Sheets] ERROR There was an error with the request. This URL should work in your browser: https://script.google.com/macros/s/AKfycbxvminqCe-gLNZp6X8VlhNLeVmtefpdDYgZaWIBslM27JYxML3K7fS2tec7BsGB_hSILw/exec?sheet=Sheet1&range=A1:B6
    [2025-01-17 18:11:23.273] [ERROR] Full Error Message:
    [2025-01-17 18:11:23.298] [ERROR] TypeError: fetch failed
    at node:internal/deps/undici/undici:12502:13
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at runNextTicks (node:internal/process/task_queues:64:3)
    at listOnTimeout (node:internal/timers:540:9)
    at process.processTimers (node:internal/timers:514:7)
    at async Class.socketNotificationReceived (/home/omiworld/MagicMirror/modules/MMM-GoogleSheets/node_helper.js:27:24) {
    [cause]: AggregateError [ETIMEDOUT]:
    at internalConnectMultiple (node:net:1117:18)
    at internalConnectMultiple (node:net:1185:5)
    at Timeout.internalConnectMultipleTimeout (node:net:1711:5)
    at listOnTimeout (node:internal/timers:575:11)
    at process.processTimers (node:internal/timers:514:7) {
    code: ‘ETIMEDOUT’,
    [errors]: [ [Error], [Error] ]

    S 1 Reply Last reply Jan 17, 2025, 5:58 PM Reply Quote 0
    • S Offline
      sdetweil @santex
      last edited by Jan 17, 2025, 5:58 PM

      @santex did you try the link provided in the error info?

      Sam

      How to add modules

      learning how to use browser developers window for css changes

      S 1 Reply Last reply Jan 17, 2025, 6:06 PM Reply Quote 0
      • S Offline
        santex @sdetweil
        last edited by Jan 17, 2025, 6:06 PM

        @sdetweil
        YES i did. it gave me this

        Sorry, unable to open the file at this time.

        Please check the address and try again.

        Get stuff done with Google Drive

        Apps in Google Drive make it easy to create, store and share online documents, spreadsheets, presentations and more.

        Learn more at drive.google.com/start/apps.

        S 1 Reply Last reply Jan 17, 2025, 6:07 PM Reply Quote 0
        • S Offline
          sdetweil @santex
          last edited by Jan 17, 2025, 6:07 PM

          @santex ok, so the link doesn’t work…

          did you do the right setup of the sheet name?

          Sam

          How to add modules

          learning how to use browser developers window for css changes

          S 2 Replies Last reply Jan 17, 2025, 6:32 PM Reply Quote 0
          • S Offline
            santex @sdetweil
            last edited by Jan 17, 2025, 6:32 PM

            @sdetweil yes i did

            1 Reply Last reply Reply Quote 0
            • S Offline
              santex @sdetweil
              last edited by Jan 17, 2025, 6:34 PM

              @sdetweil
              i follow all the steps, as indicated in the module

              S 1 Reply Last reply Jan 17, 2025, 6:39 PM Reply Quote 0
              • S Offline
                sdetweil @santex
                last edited by Jan 17, 2025, 6:39 PM

                @santex see this link
                https://forum.magicmirror.builders/post/119206

                Sam

                How to add modules

                learning how to use browser developers window for css changes

                S 1 Reply Last reply Jan 17, 2025, 8:27 PM Reply Quote 0
                • S Offline
                  santex @sdetweil
                  last edited by Jan 17, 2025, 8:27 PM

                  @sdetweil
                  thank you. i have followed this i dont find the solution

                  S 1 Reply Last reply Jan 17, 2025, 8:28 PM Reply Quote 0
                  • S Offline
                    sdetweil @santex
                    last edited by sdetweil Jan 17, 2025, 8:28 PM Jan 17, 2025, 8:28 PM

                    @santex then the best option is to open an issue on the module github page to engage the author

                    Sam

                    How to add modules

                    learning how to use browser developers window for css changes

                    S 1 Reply Last reply Jan 19, 2025, 10:16 AM Reply Quote 0
                    • S Offline
                      santex @sdetweil
                      last edited by Jan 19, 2025, 10:16 AM

                      @sdetweil ok, i have also done that

                      1 Reply Last reply Reply Quote 0
                      • 1
                      • 2
                      • 1 / 2
                      1 / 2
                      • First post
                        10/15
                        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