Anyone have HSG?

Anyone ever have an HSG test? I'm going next Thursday to get one and just wondered about how it went with others.  Did it hurt? Help you find out info?  My husband and I have been trying for our first baby for 8 months (6 using the app) and we're getting anxious and want our little one so badly. I have a "regular" 28 day cycle and I do opk's that say I'm ovulating. I'm getting so tired of logging in everyday to only see af showing up every month.  About to just say F it and Bd our hearts out without logging or stressing myself out  and see what happens.