This app was mentioned in 11 comments, with an average of 1.45 upvotes
Apilio.io is an ok first start but it's still very limited. Stringify is also an option but it is 100% cloud based. Home Assistant is where I ended up for my automations. You should take a look at it.
I'm not 100% sure this will work, but look at the app Stringify. It allows you to connect different smart devices into all sorts of flows. I just started messing with it, so I'm not sure if you can use voice commands or not. But for everything else, it should be able to do the trick! I would check it out!
Edit: I just checked, you definitely can do this. "Ok Google, tell Stringify goodnight" or something similar would be your trigger phrase. I don't have a Harmony hub so I can't fully test it out, but I would look into it with your setup.
We have nearly my same setup. Look into Stringify on Google Play. I wanted to make lights flash and Stringify made it happen. I have it setup to turn a series of ceiling fan lights on, then off, then on in my living room when someone rings the doorbell. Took a little trial and error, but it works flawlessly now. If you need help, drop me a PM and I'll upload my flow.
That's why I set up routines in Stringify:
iOS: https://itunes.apple.com/us/app/stringify-smart-automation-home-work-life-iot/id1012539039?mt=8
Android: https://play.google.com/store/apps/details?id=com.stringify.stringify&hl=en_GB
So now I have a flow (routine) that when I say "Alexa, tell Stringify night time" it runs the "night time" routine which dims both my downstairs lights to 0 brightness over the space of a minute (to give me time to walk upstairs with some light), and also sets my Nest to my overnight temperature.
You can set up flows based on all sorts of inputs. It can still be a bit picky with the words themselves - like sometimes Alexa will reply with "I can't find a flow named my time", but it works well other than that.
I've been using the Stringify app https://play.google.com/store/apps/details?id=com.stringify.stringify - which is ~~currently Android only I believe~~ on Android and iOS which can turn the lights on at a time before sunset (which you can specify) - seems to be working for my hue lights.
I also have a "night time" routine with it that I can trigger through Alexa that will fade off my lights over the space of a minute (to allow me to walk upstairs with lights on) and set the Nest temperature lower.
edit: Corrected by /u/gotlactose !
/u/blindxx use stringify. Its a simpler app version similar to CoRE.
https://play.google.com/store/apps/details?id=com.stringify.stringify
https://www.stringify.com/stringify-flow-basics/
I really like that I can choose current Hue scenes that I have saved in Stringify. So my flow is: WHEN sunset ONLY IF "TV is on" THEN "Turn on Living Room Hue scene to Twilight Sunset." That changes my living room hue lights to a saved scene that I have at sunset only if my TV is on (via harmony hub)
Unlike IFTTT, Stringify also lets you set Ecobee comfort settings to permanent or until next transition (IFTTT only lets you do until next transition). Because my gf has off hours, this is very helpful since the regular ecobee scheduling wont work well in our situation
https://play.google.com/store/apps/details?id=com.stringify.stringify
Might help with the first.
Don't need an invite to install it. It's in the Play Store: https://play.google.com/store/apps/details?id=com.stringify.stringify