Advice/Motivation

So I have been hoping and praying to God for an opportunity (can't really go into details) since last year but I have been met with disappointment after disappointment. It's like I get close and then it just falls through. My faith began to shake. I was close to giving up I thought maybe God doesn't want this for me. Recently another opportunity has occurred...looks promising soo far but I am scared. Scared that I will reach and then and it will be the same story as before. I even don't want to get excited because I feel like if I do it won't happen. I catch myself trying to not get too excited everyday. I addition I recently fell into sin(willingly ngl) and I feel like that will also affect God given me this opportunity as a punishment or something (ik that's not what God does but I am just very scared) if this opportunity falls through idk what to do tbh I need advice on what to do or pray to help me in this situation or some motivation