HSG painful?

Jennifer • TTC for 3 years (1 blocked tube), 2 MC
I have an HSG scheduled in a week. I'm wondering if I should take the rest of the day off work. I've heard can be smooth sailing for some and really uncomfortable and crampy for others according to my doc. I have a low threshold for pain. Just wondering everyone's experience with this and if they went right back to work. (I am on my feet and lifting things at work and do not sit down once during my 8-10 hour shifts so I'm thinking don't go in)?