How bad is HSG test?

We just started our fertility testing last week 😬 I am VERY nervous for all the testing and blood work. So far they’ve taken 5 1/2 of those little viles of blood and I’ve had a follicular scan on my CD 3. I haven’t seen anything about that scan hurting, but damn it was so uncomfortable! It felt like the most intense cramps and pressure I’ve ever had! Tomorrow I get an HSG test and they’ve already told me to take a pain pill an hour before. I’m worried about the pain 😕 Doctor said it feels like cramps... whos has an HSG done, and how bad was it really?