What have your experiences been with a HSG?

Am having an HSG done on friday and I am very scared because some women say that it really hurts. Any suggestions? Tell me what it feels like and what I should expect, please. there r possibilities of being pregnant??? I am going to take motrin 1 hour before but I am very nervous :(