Hi everyone,
I’m looking for a simple solution to sync Home Assistant with Google Sheets. As I’m not very technical, I need an easy-to-implement solution or a detailed step-by-step tutorial.
My goal is to maintain an up-to-date inventory of all my HA entities:
- Automatically export the complete list of my Home Assistant entities to a Google Sheet
- For each entity, I want to track:
- Entity name
- Entity ID
- Associated room
- Have the sheet update automatically when a new entity is created
If possible, I’d like to avoid complex solutions requiring extensive coding or technical configuration.
Does anyone have a “plug and play” solution or could guide me step by step? Alternatively, at minimum, I’d like to be able to export the list of all my entities to put in a spreadsheet to have a clean list of my HA entities.
Thanks in advance for your help!