HSG test

Anyone had this done? If so how was it and was it informative to you? also I read that people got pregnant not long after, was it like that for you?