HSG what to expect

La

Hi ladies, I'm having a HSG test on the 14th of Oct and I'm feeling really anxious about it. I've heard such mixed stories about what to expect. I have been preg twice before but mc both babies. Last bfp was March 2017 so this is the last test before we go on the NHS waiting list here in Scotland. Can any of you lovely ladies share your experience? Did you get results on the day? How painful was it? Anyone get pregnant after it? Thanks in advance!