Hsg advice

Getting a hsg done on Thursday, should I take anything before hand? I’ve herd that it can be painful? How much fluid comes out afterwards? Any positive stories or pregnancy afterwards? I’m due to ovulate a few days after getting this test, will this affect my chances of falling pregnant this month? TTC #2 for a few years now. Thanks ladies x