Back to the overview
Google Sheets in Home Assistant
google_sheets
part of Home Assistant since 2022.10
Cloud, polling
Set up in the user interface
Google Sheets is an official Home Assistant integration for Utility. Works through the manufacturer’s cloud and asks for changes at regular intervals – it depends on the internet connection and the service.
Facts about this integration
- Compatible with Home Assistant
- yes, official integration
- Connection
- Cloud, polling – Works through the manufacturer’s cloud and asks for changes at regular intervals – it depends on the internet connection and the service.
- Setup
- in the user interface
- Kind
- Online service
- Installations
- 2,824 (0.4 % of the installations that share statistics)
- Categories
- Utility
- Maintained by
- @tkdrob
- Python packages
gspread==6.2.1
Setup
- In Home Assistant open Settings → Devices & services.
- Click "Add integration" and search for Google Sheets.
- Follow the dialog – it asks for everything the integration needs.
The link goes through my.home-assistant.io and opens the setup dialog in your own instance – no address of ours is involved.
Blueprints that use this integration
- Automation Power State Monitor – Monitors power state and logs data to Google Sheets. Uses input entities and mobile app integration for alerts.
- Automation Car Travel Log – Logs car trips using sensors, Waze, and Google Sheets. Requires device tracker and input text entities.
- Automation 👷♂️ Timbratura Ingresso/Uscita NFC
Source of this entry: the official documentation of the integration