Second night in a row sleepless. I've had trouble sleeping for 7 nights in 2 weeks now. Pls help

I've had totally sleepless nights and nights where I only god a few hrs of sleep. I'm so exhausted and hopeless. Tomorrow I have an appointment with a psychiatrist who I'll beg to be put on sleeping pills or extremely strong sedatives. I hate anxiety so much. I'm only awake now cus my body thought It was dying while attempting to sleep. But I'm also scared ill be on meds and they'll wear their effectiveness off. I feel so alone and hopeless. I don't know what to do