How to sync Home Assistant entities with Google Sheets

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!