HSG test next week

Mac • 27 yrs old. Married for 4 years. TTC since marriage for baby #1. Clomid 6 failed rounds. Dx with fibroids 9/2016.
I went to the OBGYN today. The doctor said my blood work and sonagram both came back good. My husbands semen analysis was good too! What a relief! 
 My doctor wants to do a HSG. Any advice/experience/tips etc. about the test are appreciated. Will I be able to work afterwards? Should I have someone drive for me? Has anyone had any luck with conceiving after having the test?