fertility testing

Hello all I'm new here and have some questions. After 3 failed at home inseminations we decided to stop doing this blindly and see if I can even get pregnant and find out my options. We went to a fertility doctor and I'm going into have a HSG test Monday. Has anyone had this test done? Is it as scary as the nurse and internet is describing? 😞I'm a bit nervous about this.