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:

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

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:

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

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:

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

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:

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

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

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

@sdetweil In case anyone finds this post in the future.

This problem is usually one of two causes:

1. The google apps script was not deployed correctly and the request runs into a permission error page
2. There is an error in the request due to bad script URL or other parameter

I have updated the module to fail gracefully in these cases and hopefully provide a better error message. If you are still having problems feel free to add an issue to the repo. (https://github.com/ryan-d-williams/MMM-GoogleSheets/issues).

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