HSG help!

Christine
Hi! I've been TTC 14 mts with no luck. My obgyn checked ovarian function (normal), my husband had a semen analysis (normal), next step is HSG. I hear such conflicting reports of if it is fine, uncomfortable, painful, etc. Can anyone tell me how they felt during/after and if I'll be fine to go myself or should I bring someone with me?