Google Sheets last row sensor


I wrote an integration that pulls the last row of a column from a google spreadsheet and sends it over MQTT as a sensor. It runs as a docker container. There’s an example dockerfile for building an image and an example docker compose in the repo. It also supports many columns in one spreadsheet for many sensors.

The code is rough and i’m still improving it - but it works. I use this to manually record my utility bills and utility usage statements. But, can use it for anything.

You’ll need to follow these instructions to setup the google side of things
You do steps 1-5 here: Accessing Google Sheet Data with Python: A Practical Guide using the Google Sheets API | by Jobin J | Medium


1 Like