I think everyone is different when it comes to this procedure. What I'm going to tell you about my experience is not meant to scare you. Just to tell you how it was for myself personally.
I was pretty nervous about the whole thing. I've never had anything like that done ever. I'd never even broken a bone in my life let alone have a biopsy. So to say I was scared and nervous would be an understatement. My doctor and NP were really good though in trying to keep me calm and so forth. They had a tv monitor there so if I wanted, I could watch as they were performing it. Before taking samples off of the cervix, they also used what I like to call a stir stick (sorry, don't remember the technical name). They use that to take a sample from inside your cervix where they can't see. To double check nothing's there. That wasn't so bad for me personally.
Due to how it was, on my cervix they took three samples. I have to say that was the worst part. Even though they are taking a tiny sample, and supposedly a pinch, to me...well it felt like my whole cervix was being taken. lol! That's me, though. I don't do pain well. Especially the type of pain I'm not used to like this. That's when I started to cry. I think mostly from fear, and things sinking in on what was happening to me. They had the nurse try to help keep me calm, and talk to me. I was never so happy to have something over and done with in my life. lol!
As for the after effects, it wasn't so bad for me. I had discharge which I can't remember if I had it for one or one and a half days. Not bad. As for cramping, I honestly don't remember any. I think I may have had some ibprofuen before I had the procedure done in order to kind of stop that in it's tracks. Or at least make the cramps not so bad. I even went to Costco afterwards, and felt fine while I was there. I did pretty well after it was all over.
Hang in there and take a deep breath. It's not the greatest of procedures by any means, but you'll get through it. Hopefully your Dr. is good, and you won't have too much discomfort during and after. Goodluck!!