How was your HSG?

Faith
Had my first fertility consultation today. Doctor said everything looks fine from the exam he did, so he ordered an HSG and some ovarian scans and blood tests. I'm curious about how the HSG went for those who have had one. Doctor says they use a new type of dye so it shouldn't be painful... but I've read some scary stories! 
Do I need to be worry about it???