TTC after 6 years

So I recently did fertility labs, they have all come back normal. My vaginal ultrasound came back normal and now in four days I do the HSG. To the women that have had one done, how bad of pain did you experience? Did anyone do a HSG and get pregnant shortly after? Give me all the info ladies!