Read the statement by Michael Teeuw here.
[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):
-
dear @ryandwilliams ,
thanx for updating the module. unfortunately, it breaks the display of my GoogleSheet, i.e. it is not loading anymore. If i go back to commit “25685e9” it works fine again. In the magicmirror logs i cannot find any ERROR or WARNING.
i am happy to support fixing the issue, in this case i would need some instructions which data to provide. -
@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?
-
@ryandwilliams
thanx for your quick reply and offer to support.
i did a simple git pull. no touches to Google Apps Script library, since i am not very familiar with it and prefer to go step-by-step to isolate root casues.
i will raise the issue on github, so we can continue there. -
@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).
-
just for reference, link to github issue to follow up:
https://github.com/ryan-d-williams/MMM-GoogleSheets/issues/72
