#How do I create a work time tracker with device tracker and google sheets?

25 messages · Page 1 of 1 (latest)

frigid venture
#

Hi there,

I would like to know whether it is possible to couple a google spreadsheet account to home assistant, and then create an automation where if I enter my work zone, it starts clocking in time until I leave that work zone (device tracker in home assistant), and then at the end of the day, puts it in a google spreadsheet so that each day of the week for each month of the year it has a automated work time tracker in my google spreadsheets account.

Is this possible?

I'm looking to do something like this, whether it be through automations or Node-RED. I'm new to Node-RED, I have it installed but haven't made any automations with it yet. Eventually I want to move to Node-RED for my automations because I heard it could do more then what home assistant has to offer from it's automations by default. Please advice me what would be a good way of accomplishing this.

Does anyone have experience with setting up such a work clocking system?

crimson plume
frigid venture
#

hmmm so it can only do this for a single spreadsheet I see here, is there a way to create different worksheets in home assistant for different use cases? And will this change later?

crimson plume
#

I'm looking to do something like this, whether it be through automations or Node-RED. I'm new to Node-RED, I have it installed but haven't made any automations with it yet. Eventually I want to move to Node-RED for my automations because I heard it could do more then what home assistant has to offer from it's automations by default.

I disagree with this in theory. Automations and scripts in HA can do a LOT. I've yet to run into any situation where NR can do more than HA can. Maybe a few edge cases, but generally speaking, the automation/script in HA can do pretty much everything NR can do without the overhead of connections from a 3rd party app into HA.

crimson plume
frigid venture
#

ah there is a worksheet data attribute

#

awesome

crimson plume
#

So, yeah, the integration only applies to a single document. But you can create as many sheets as you want within that single document.

#

Yup

crimson plume
#

Plus, you have to account for the overhead of NR -> HA. It all happens over the websocket API, so there are times where you might have a lag for whatever reason (depending on how you host NR).

frigid venture
#

that sounds awesome, I'm kind of a programmer myself, so I'm fine editing yaml code if need be. I just have to get a bit used to the whole home assistant way of creating yaml's

crimson plume
#

lol you really don't need to drop to YAML for too much unless you are getting "fancy".

#

The UI editor is usually good for about 80% of everything you might want to do.

frigid venture
#

it's fine, I'd love to learn how to do it both ways anyways 🙂

crimson plume
#

Smart attitude.

#

I do both, but I have some stupid templates/automations/scripts where I kind of push the limit of what the UI can really do.

frigid venture
#

for my initial idea, would this be possible with just the UI? Or should I create an automation script?

frigid venture
crimson plume
#

Yup. That should all be do-able through the UI. Basically, you'll want to use a small template for the sheet name (easy to do). A couple of date/time helpers for the start and end working times and a couple of automations for when you get to work/leave work (that could all be done in a single automation as well).

frigid venture
#

awesome! 👍

#

I'll give it a go, thank you

crimson plume
#

Anytime 🙂

frigid venture
#

do you know if there is also a office 365 version of this? Or would this only work with google spreadsheet?