Write sensor's values to google spreadsheet?

Configuration
1

Hi All,
I was wondering if anyone has a guide on how to write values on google spreadsheet based on automation trigger?

Thank you !

2

Have you done any research at all? For starters, you will need a way of putting data into your Google spreadsheet. Perhaps they provide an API of some sort.

When you have worked out how to do that then please come back here and we’ll assist you with stuffing data into it. Bear in mind that you will need some form of schema (spreadsheet layout - columns/rows)

See you soon.

3

I’d look at https://www.home-assistant.io/components/ifttt/

Let us know if it works, I’m interested in this too

4

I haven’t tried it, but it sounds doable using the google sheets rest api: https://developers.google.com/sheets/api/reference/rest/

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append seems to be the action you are looking to use in that case.

If you can get it to work with curl it should be doable from the shell action in an automation.

5

Hi , Could you help me writing sensors value into google sheets ?