I had mine this week. I took antibiotics for two days prior to it, and took 400 mg advil an hour before.
Mine hurt like a b***h. He said my cervix was bouncing around when he tried to put the catheter in so he had to use the tenaculum to clamp it in place. Holy hell that gave me some shooting pain. He was really quick with the dye and the xray. For me it was the type of pain that gave me a hot flush up the back of the neck and a flash of nausea. I breathed in and out deeply and just reminded myself that it was less then 5 mins total and it would be over soon.
They obviously saw my discomfort but once all of the instruments were remove we were joking around.
I will say that I bled for the rest of the day, and had a couple large clots pass. I suspect it was because of the tenaculum. I called my clinic and they said to monitor the amount and if I bled through a pad within an hour then it was too much. Mine wasn't that much thankfully, but I was just shocked because I wasn't expecting it at all.
Sorry I don't want to scare you, I wanted to be honest! It sucked, it hurt, but it is over FAST! Breath through it! The doctor told me right away that my tubes were clear and showed me the images after the procedure was done.
Good luck!