Great news (in a really strange kinda way!!!!). I had a HSG too, and its a yukky and a bit undignified, but if it helps us then we do it.
My sis took me, definitely need someone with you. And I was lucky as they put a nice next to me who just talked random shite to try and keep me at ease. I was ok as I had a woman do mine.
Don't know why, but I found the worst bit was when they cleaned my loo-laa. I was just mortified and wanted to say "It is clean I only bathed this morning"
Some of the others were saying there OHs went in with them, wearing a lead tunic.