Google Sheets | Home Assistant | Page 1

gentle shard Mar 30, 2025, 6:31 PM

#

So I've gotten how to append a sheet with new data.

my question is, how the heck can I pull data from sheets to display in Home Assistant?

Bascially, I'd like to display the last time each one of these events happened. Any tips without using rednode?

grand oak Mar 31, 2025, 1:46 AM

#

gentle shard So I've gotten how to append a sheet with new data. my question is, how the he...

a spreadsheet is not a database...
why are you writing stuff out to sheets to read it back in again?
why not just keep stuff in HA?

what are you actually trying to do?

gentle shard Mar 31, 2025, 2:02 AM

#

To answer the first question... because this 👇, looks like shit.

#

#

All i want is
"date - event"

grand oak Mar 31, 2025, 2:12 AM

#

you could make a helper entity which you then display.
then when your automation runs you just update the helper to the current datetime

grand oak Mar 31, 2025, 2:26 AM

#

gentle shard All i want is "date - event"

if you use a markdown card you could do something like this

# Latest Feeding
{{ as_datetime(state_attr('automation.FEEDING_AUTOMATION_ENTITY', 'last_triggered')).strftime('%B %d, %Y, %H:%M')  }}

# Latest Poop
{{ as_datetime(state_attr('automation.POOPING_AUTOMATION_ENTITY', 'last_triggered')).strftime('%B %d, %Y, %H:%M')  }}

# Latest Shed
{{ as_datetime(state_attr('automation.SHED_AUTOMATION_ENTITY', 'last_triggered')).strftime('%B %d, %Y, %H:%M')  }}

# Latest Cleaning
{{ as_datetime(state_attr('automation.CLEANING_AUTOMATION_ENTITY', 'last_triggered')).strftime('%B %d, %Y, %H:%M')  }}

obviously updating to the correct automation names

#

that would give you something like this

#

#

obviously your theme would adapt it

#

is that more what your looking for?

#Google Sheets