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