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