MagicMirror Forum
    • Recent
    • Tags
    • Unsolved
    • Solved
    • MagicMirror² Repository
    • Documentation
    • 3rd-Party-Modules
    • Donate
    • Discord
    • Register
    • Login
    1. Home
    2. ryandwilliams
    A New Chapter for MagicMirror: The Community Takes the Lead
    Read the statement by Michael Teeuw here.
    R
    Offline
    • Profile
    • Following 0
    • Followers 0
    • Topics 2
    • Posts 12
    • Groups 1

    ryandwilliams

    @ryandwilliams

    Module Developer
    7
    Reputation
    1
    Profile views
    12
    Posts
    0
    Followers
    0
    Following
    Joined
    Last Online

    ryandwilliams Unfollow Follow
    Module Developer

    Best posts made by ryandwilliams

    • RE: [MMM-GoogleSheets] Display Google Sheets data on your MagicMirror

      UPDATE: Version 4 (February 2026)

      • Checkboxes and dropdowns are now supported. Additionally, they are interactive (if you change a checkbox or dropdown on the mirror, it will make that same change on the spreadsheet. This should allow for fully-customizable self-built modules and advanced spreadsheet interaction!

      Check out the README for more info.

      Example Image (all of the checkboxes and dropdowns are editable and link back to the spreadsheet):
      chores.png

      posted in Utilities
      R
      ryandwilliams
    • RE: Looking for the Right Todo List

      @jtillinghast I’m not well-versed in all of the specific to-do modules, but is this task list something you could create and maintain in a spreadsheet? If so, you can check out my module MMM-GoogleSheets. I recently added checkbox support (with write-back to Google Sheets) so if you build in the formulas to clear tasks as they are checked off this should work as you expect it to.

      posted in General Discussion
      R
      ryandwilliams
    • RE: Google Sheets module help

      @matt1672 This post it old, but in case anyone finds it in the future - I made a module for displaying Google Sheets data on MM. https://github.com/ryan-d-williams/MMM-GoogleSheets.

      You can color code the rows based on custom logic in the config file.

      posted in Requests
      R
      ryandwilliams
    • [MMM-Chance] Flip a Coin or Roll a Dice on your MagicMirror (with animations!)

      MMM-Chance

      My wife and I like to flip a coin to make decisions. I decided to incorporate this (plus some more fun chance options) into our MM!

      What it does:

      • Flip coin button with flip animation + Heads/Tails result
      • Custom probability buttons (examples: 1-in-5, 1-in-10, 1-in-100)
      • Dice-style animation for non-coin buttons
      • Configurable buttons so you can create your own odds/actions
      • Listens for notifications if you don’t have a touch-screen and want to trigger the events without a click
      • Very customizable!

      Example use cases

      • Daily yes/no decisions
      • Game-night odds checks
      • Classroom/random selection moments
      • “Should I do it?” style fun prompts
      • D&D style dice integration (d10, d20, etc.)

      Install / Repo

      GitHub: https://github.com/ryan-d-williams/MMM-Chance

      Examples:
      CoinFlip.gif

      ColorCoin.gif

      D20.gif
      (the dice animation is a little jumpy because of the gif frame-rate, it looks smoother on the module)

      example1.png

      FunColors.gif

      I’d love feedback or feature requests!

      posted in Fun & Games
      R
      ryandwilliams
    • RE: [MMM-GoogleSheets] Display Google Sheets data on your MagicMirror

      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
      posted in Utilities
      R
      ryandwilliams
    • [MMM-GoogleSheets] Display Google Sheets data on your MagicMirror

      Description:

      This module allows you to display any data from Google Sheets directly on your Magic Mirror. It is fully customizable so you can choose which parts you want to mimic exactly and which parts you want to add custom styling to.

      Sample use cases:

      • Custom dashboard
      • Lists or reminders
      • Schedules
      • Financial data / Personal finance tracking
      • Create your own custom MM modules in Google Sheets without having to write the code. If you can get the data into Google Sheets, then you can display it using this module without having to write a new custom module

      Features:

      • Fully customizable styling options
        • Mimic the Google Sheets look exactly or select a subset of styles to mimic
        • Write your own custom styling CSS to all the data or just the header row
        • Write your own custom styling function for dynamic styles based on the data
      • Select a specific range or use a dynamic range based on how much data is in the sheet
      • Formulas and functions in the sheet are recalculated each time the module updates

      Screenshots:

      grocery.png
      Orders_Custom.png Orders_Mimic.png Projects_Custom.png scoreboard_2.png

      Download:

      https://github.com/ryan-d-williams/MMM-GoogleSheets


      Version 1

      • Import data from Google Sheets
      • Custom styling

      Version 2 (Aug 2024)

      • Auto range detection
      • Improved error messaging for invalid requests
      • Auto-update formulas each time the module refreshes

      Version 3 (November 2024)

      • Scrolling Data

      Version 4 (February 2026)

      • Checkbox/Dropdown support
      • Interactive elements (changing the checkbox/dropdown makes the same change in the spreadsheet)
      posted in Utilities
      R
      ryandwilliams

    Latest posts made by ryandwilliams

    • [MMM-Chance] Flip a Coin or Roll a Dice on your MagicMirror (with animations!)

      MMM-Chance

      My wife and I like to flip a coin to make decisions. I decided to incorporate this (plus some more fun chance options) into our MM!

      What it does:

      • Flip coin button with flip animation + Heads/Tails result
      • Custom probability buttons (examples: 1-in-5, 1-in-10, 1-in-100)
      • Dice-style animation for non-coin buttons
      • Configurable buttons so you can create your own odds/actions
      • Listens for notifications if you don’t have a touch-screen and want to trigger the events without a click
      • Very customizable!

      Example use cases

      • Daily yes/no decisions
      • Game-night odds checks
      • Classroom/random selection moments
      • “Should I do it?” style fun prompts
      • D&D style dice integration (d10, d20, etc.)

      Install / Repo

      GitHub: https://github.com/ryan-d-williams/MMM-Chance

      Examples:
      CoinFlip.gif

      ColorCoin.gif

      D20.gif
      (the dice animation is a little jumpy because of the gif frame-rate, it looks smoother on the module)

      example1.png

      FunColors.gif

      I’d love feedback or feature requests!

      posted in Fun & Games
      R
      ryandwilliams
    • RE: [MMM-GoogleSheets] Display Google Sheets data on your MagicMirror

      @wimThoelke I responded to you on github, but just in case anyone stumbles on this thread in the future - you need to update both the module (via git pull) and the Google Apps Script library version (instructions in the readme).

      posted in Utilities
      R
      ryandwilliams
    • RE: [MMM-GoogleSheets] Display Google Sheets data on your MagicMirror

      @wimThoelke thanks for the reply! What steps did you take to update the module? Did you pull the new repo as well as update the Google Apps Script library (currently version 34)?

      It’s also worth noting that when you make a big change to Google Apps Script, the time to load can significantly increase the first time you run the module. For example during my testing, when I did an update the module took ~25-30 seconds to load the very first time, but after the first time it only took 2-3 seconds on subsequent refreshes.

      If there is no error then I think it may be a loading problem or it may be because you did not update the Google Apps Script. The module should always error if something goes wrong (this might be a special situation I’m happy to help you debug).

      I think it might be best to transfer this conversation over to github so I can help you with your problem. Can you open an issue so we can talk about it more?

      posted in Utilities
      R
      ryandwilliams
    • RE: Looking for the Right Todo List

      @jtillinghast I’m not well-versed in all of the specific to-do modules, but is this task list something you could create and maintain in a spreadsheet? If so, you can check out my module MMM-GoogleSheets. I recently added checkbox support (with write-back to Google Sheets) so if you build in the formulas to clear tasks as they are checked off this should work as you expect it to.

      posted in General Discussion
      R
      ryandwilliams
    • RE: [MMM-GoogleSheets] Display Google Sheets data on your MagicMirror

      UPDATE: Version 4 (February 2026)

      • Checkboxes and dropdowns are now supported. Additionally, they are interactive (if you change a checkbox or dropdown on the mirror, it will make that same change on the spreadsheet. This should allow for fully-customizable self-built modules and advanced spreadsheet interaction!

      Check out the README for more info.

      Example Image (all of the checkboxes and dropdowns are editable and link back to the spreadsheet):
      chores.png

      posted in Utilities
      R
      ryandwilliams
    • RE: [MMM-GoogleSheets] Display Google Sheets data on your MagicMirror

      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
      posted in Utilities
      R
      ryandwilliams
    • RE: [MMM-GoogleSheets] Display Google Sheets data on your MagicMirror

      @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.

      posted in Utilities
      R
      ryandwilliams
    • [MMM-GoogleSheets] Display Google Sheets data on your MagicMirror

      Description:

      This module allows you to display any data from Google Sheets directly on your Magic Mirror. It is fully customizable so you can choose which parts you want to mimic exactly and which parts you want to add custom styling to.

      Sample use cases:

      • Custom dashboard
      • Lists or reminders
      • Schedules
      • Financial data / Personal finance tracking
      • Create your own custom MM modules in Google Sheets without having to write the code. If you can get the data into Google Sheets, then you can display it using this module without having to write a new custom module

      Features:

      • Fully customizable styling options
        • Mimic the Google Sheets look exactly or select a subset of styles to mimic
        • Write your own custom styling CSS to all the data or just the header row
        • Write your own custom styling function for dynamic styles based on the data
      • Select a specific range or use a dynamic range based on how much data is in the sheet
      • Formulas and functions in the sheet are recalculated each time the module updates

      Screenshots:

      grocery.png
      Orders_Custom.png Orders_Mimic.png Projects_Custom.png scoreboard_2.png

      Download:

      https://github.com/ryan-d-williams/MMM-GoogleSheets


      Version 1

      • Import data from Google Sheets
      • Custom styling

      Version 2 (Aug 2024)

      • Auto range detection
      • Improved error messaging for invalid requests
      • Auto-update formulas each time the module refreshes

      Version 3 (November 2024)

      • Scrolling Data

      Version 4 (February 2026)

      • Checkbox/Dropdown support
      • Interactive elements (changing the checkbox/dropdown makes the same change in the spreadsheet)
      posted in Utilities
      R
      ryandwilliams
    • RE: Google Sheets module help

      @matt1672 This post it old, but in case anyone finds it in the future - I made a module for displaying Google Sheets data on MM. https://github.com/ryan-d-williams/MMM-GoogleSheets.

      You can color code the rows based on custom logic in the config file.

      posted in Requests
      R
      ryandwilliams
    • RE: MMM-GoogleSheets Not loading

      @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.

      posted in Troubleshooting
      R
      ryandwilliams