Membrane sweep

LJ • 1 baby girl with another baby on the way
Hey ladies 
I'm 39w3d and have a membrane sweep booked for Wednesday morning. I'll be 40w2d. And I'm very nervous about it. My midwife has advised it can be really painful. Has anyone had one that can tell me the process/feeling/aftermath?