HSG Test... how bad is it?

Going in this afternoon and I've heard mixed reviews from excruciating to just awkward.

I was told to take 800mg of ibuprofen and they use local anesthetic at my fertility clinic.

Also, did anyone have luck getting a BFP in the months after? I've heard this test can help.