Upcoming HSG

Tania
I went to a fertility specialist today and she wants me to get an HSG. I know a few of you have had the procedure done. Is it really horrible? I'm a bit scared. ..