HSG??!!

J
I'm getting my HSG test on weds! I'm a little nervous since I've read some horror stories online! If you have had this test can you please give me your honest opinions about pain! Also did you get pregnant shortly after??