[SOLVED] Pull data from Google Spreadsheet?

Is there a way to access data from a Google Spreadsheet and use it in OpenHab? This would be for thermostat control. I know there’s already calendar integration, but there’s already a process that uses a spreadsheet, and that’s the natural place to pull the data from.

There is a way but it’s going to require you to code it up yourself. Google provides an API that lets you access, download, and modify spreadsheets. I’ve done this once years ago. I think this is where you can start. https://developers.google.com/sheets/api/

You will probably want to code it as a separate Python script and then use OH’s REST API to update Items from there.

1 Like