HSG tips and advice

Please. Tell me it’ll be ok 🥴. Im an extremely anxious person and freaking out over there. Been trying 6 months and no success. Hormones look good, ovulating regularly, therefor doc suggested this to check for blockage (I had a c section and d/c prior). I don’t understand why I just can’t be put out. Let’s just say, I had a colposcopy done and literally the most excruciating pain I ever had when they did the biopsies. I need advice and success stories please !!!