Interest Check: Google Sheets Reader and ShowData
Hi all,
I use Google Sheets to store daily energy consumption data from Homey. What started as a simple spreadsheet has gradually grown into quite an extensive collection of tables.
I also wanted to display this data as charts on my Homey Dashboard. So, with the help of AI, I started developing two Homey apps: Google Sheets Reader and ShowData.
Google Sheets Reader
This app retrieves data from Google Sheets using a shared link, without requiring a connection to a Google account.
The retrieved values are available as Flow tags. The app can also provide complete tables in JSON format, allowing other apps, such as ShowData, to use this data.
ShowData
ShowData allows you to display data from Google Sheets Reader, on your Homey Dashboard using various widgets. The screenshot of my demo dashboard gives an impression of what’s possible.
Both apps are now working and have grown quite a bit in functionality. I use them myself to display my energy data, although development is not entirely finished yet.
I originally created these apps for my own use, but I’m curious whether other Homey users might find them useful too.
If there’s enough interest, I’d like to explore the possibility of making both apps available in the Homey App Store.
Would anyone be interested in using one or both of these apps?
