Data Graphing and Visualization

[kevin]

i still use this with the google sheets logging smartapp…

Google Sheets Charts

There are a couple Google Sheet data logging smart apps (GoogleSheetsLogging and SimpleEventLogger) and I just wanted to share a way to get a chart from a Google Sheet that could be used in SmartTiles or potentially a DH in the SmartThings App. The trick is to publish the chart as an image; from that, you have a URL that can be used anywhere you can reference an image on the internet. 1-set up your preferred logging smart app 2-insert chart from button bar, set up a chart as you like. Note: make sure to include the last row of the sheet in data ranges and this will allow the chart to refresh the new data added by your smart app. 3-(optional)from chart pulldown, select ‘move to own sheet’ (now the chart will have its own tab) 4-click publish, under link, change interactive pulldown to…