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 2.3k 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.
    • R Offline
      ryandwilliams Module Developer @FallandeGubbe
      last edited by

      @FallandeGubbe your best bet is to post an issue in the repository.

      When you post, I recommend including your current config (minus any sensitive data) so I can help you fix the problem.

      FallandeGubbeF 1 Reply Last reply Reply Quote 0
      • FallandeGubbeF Offline
        FallandeGubbe @ryandwilliams
        last edited by

        @ryandwilliams OK, thanks - I will do that

        1 Reply Last reply Reply Quote 0
        • R Offline
          ryandwilliams Module Developer @ryandwilliams
          last edited by ryandwilliams

          UPDATE: Version 3 (November 2024)

          • Scrolling data is now supported (you can define how much data to show and customize the scrolling behavior to meet your needs). Check out the README for more info. Gif example: MMM-GoogleSheets-Scroll.gif
          1 Reply Last reply Reply Quote 1
          • S Offline
            santex
            last edited by

            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 Reply Quote 0
            • S Do not disturb
              sdetweil @santex
              last edited by

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

                @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 Reply Quote 0
                • S Do not disturb
                  sdetweil @santex
                  last edited by

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

                    @sdetweil yes i did

                    1 Reply Last reply Reply Quote 0
                    • S Offline
                      santex @sdetweil
                      last edited by

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

                      S 1 Reply Last reply Reply Quote 0
                      • S Do not disturb
                        sdetweil @santex
                        last edited by

                        @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 Reply Quote 0
                        • 1
                        • 2
                        • 2 / 2
                        • 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