Hsg test

Have any of you ladies had this done? I'm wondering how painful it actually is and if you know of anyone you concieved right after it. I know it isn't done for the reason but my doctor said a lot of women become pregnant after getting it done.