How to use Google Sheets in Home Assistant - TUTORIAL
Hi! Since version 2022.10 of Home Assistant, it's possible to store data in Google Sheets. I will show you how in this tutorial!
⭐ You can download the code that I created for this video at: https://ko-fi.com/s/727ac5115a ⭐
Links referred to in this video:
Google Sheets integration page: https://www.home-assistant.io/integra...
Google Developers Console: https://console.developers.google.com...
Google Drive API: https://console.developers.google.com...
Google Sheets API: https://console.cloud.google.com/apis...
Authorized Redirect URL: https://my.home-assistant.io/redirect...
Blog version: https://www.smarthomejunkie.net/how-t...
⭐⭐⭐
Join this channel to get access to perks: 📺 / smarthomejunkie
Please consider becoming my patron 🏅 at / smarthomejunkie
Or please support me by buying me a ☕ at https://ko-fi.com/smarthomejunkie/
⭐⭐⭐
My Devices: https://github.com/smarthomejunkie/My...
Instagram: / smarthomejunkie
Twitter: / smarth0mejunkie
Facebook: / smarthomejunkie
TikTok: / smarthomejunkie
Discord: / discord
Music by:
2TECH-AUDIO: https://2tech-audio.bandcamp.com/
00:00:00 Introduction
00:00:53 Create Developer Credentials in Google
00:05:59 Set up Google Sheets in Home Assistant
00:08:34 Show Created Google Sheet
00:09:30 Fill Google Sheets with data using the developer tools
00:11:07 Add data to Google Sheets using an automation
00:14:54 Add a sensor value to a Google Sheet
#homeassistant #googlesheets #googledrive #excel #smarthome #homeautomation
