Membrane sweep 39+4

Shawna • Wife and mother of (soon to be) 2!
So my doctor informed me that she will be doing a membrane sweep to kick start labor on Wednesday (I'll be 39+4) and I'm nervous it will hurt! Has anyone gone through this? How long did it take for labor to start or did it even work at all?