Ask HN: How To Be a Good Leader?

I been trying to make some cool projects with some people, sometimes co-workers or friends, I can make them excited enough to start a project, but I can't manage to keep them excited to finish a project, at first I thought it was them but after many different groups I started to think that maybe I wasn't a good leader and I need to get better at it