Google Sheets
- Installs
- 2.8k sharing analytics
- Connection
- Uses the vendor's cloud
- Upkeep
- Part of Home Assistant
- Category
- DIY and makers, Web and data connectors
- Kind
- Built-in integration
- Brand
- Needs
- Built into Home Assistant
- Domain
google_sheets
Independent directory, made by the developer of Vulpo. Not affiliated with Home Assistant or the Open Home Foundation.
About
Google Sheets is a built-in integration that reads and writes worksheet data in Google Sheets from Home Assistant. It adds two actions: one appends data to a worksheet, and the other gets data from a worksheet. These can be used in automations and scripts, for example to log values to a spreadsheet or to pull stored values back in. The integration depends on Google's cloud, so it needs an internet connection to work. It is set up in the UI, where the sign-in goes through Google's own page using application credentials.
Automatic summary of Home Assistant's source code. Something wrong? Get in touch
Supports
Uses the vendor's cloud Needs an internet connection and an account with the vendor.
Set up in the UI Add it in Settings, Devices and services. Nothing to download.
Sign in with the vendor Connects through the vendor's own sign-in page.
Updated with Home Assistant Ships and updates with every Home Assistant release.
Setting it up
It is added under Settings, Devices and services, with Add integration.
Pick authentication method
- Application credentialsThe credentials you want to use to authenticate.
Texts from Home Assistant's source code, Apache License 2.0.
Actions
- Append data to Google sheetAppends data to a worksheet in Google Sheets.Fields: Add created column, Sheet, Data, Worksheet
- Get data from Google sheetGets data from a worksheet in Google Sheets.Fields: Sheet, Rows, Worksheet
Information
- Installs
- 2.8k sharing analytics
- Connection
- Uses the vendor's cloud
- Upkeep
- Part of Home Assistant
- Category
- DIY and makers, Web and data connectors
- Kind
- Built-in integration
- Brand
- Needs
- Built into Home Assistant
- Domain
google_sheets
