HSG Procedure

Has anyone ever had a HSG dye test done? My doctor wants to test because we are having a hard time getting pregnant. I keep reading that it is super painful. Can you please share your experiences so I know what to honestly expect. Thanks!!