Manually triggered automation advice

I don’t use node red or know much about it, but you may find this helpful:

If you stay native HA, you would create a script and have the button call the script (either directly with script.my_script_name or use the script.turn_on service)