HSG testing

I am going in Tuesday morning for an HSG test. How painful is it? I’m supposed to go into work that day afterwards and I’ve heard some horror stories about the pain afterwards 😩 And if this test comes back clear, what is the next step?