Get a workout buddy. Can be a friend or spouse or a trainer, but someone who will make you show up because you know they're going to be there and you'll be a jackass if you bail on them. They'll also make you look forward to the time together, and help you not think about being tired or sore or sweaty or how many left you have, whatever. I'm a trainer and my most valuable skill is making my clients forget they're working out and that they hate working out. The less you hate what you're doing, the more likely you are to do it, so find something you don't mind, and then find someone you like to do it with. Start there.
If you want to get into gym life and weight training, find a good trainer. Date around and find someone you click with. The Internet is full of good and bad advice, but a real(that means certified) trainer will have mostly good advice. If you can't afford a trainer, then stick to the machines because it's harder to hurt yourself on those. Anything is better than nothing, but be sure to take your time because moving too fast causes injuries and injuries only waste time, set you back and possibly stop you for good. Learn to enjoy the process and the journey and this will become the lifestyle change people say it should be.
Good luck and be sure to have fun!