Hi,
I’m looking to build an automation to play a particular MP3 file based on the date and time which is imported via a CSV file.
I’ve got the automation working based on a fixed time via Google Cast as media player. But now I need to extend the development so that this automation runs at the times provided in a file.
A sample file format:
Activity,Date,Time
Up,2025-01-01,03:45
Run,2025-01-01, 13:30
Walk,2025-01-01, 18:30
Run,2025-01-13,14:50
Does anyone know how I can import the file and extract the Date and Time per ‘Activity’ to and build some sort of a date Time sensor which I can plug into my automation? E.g. Run sensor which will have 2 upcoming DateTime i.e. Run,2025-01-01, 13:30 and Run,2025-01-13,14:50
Happy to change the format of the file (json, xml etc…) and the format of dates and times to make it work.
TIA