Anyone has HSG

Wam
My doctor recommended a HSG scan and am hoping all will go well. I hear it's painful so am also scared. Please share your experiences.... Thanks in advance