I was awake for the procedure and it did not hurt at all. The only thing that slightly hurts is the pinch of the first novacaine needle, after that you are pretty numb. My procedure went very fast. I was in and out of the office in about an hour and that included the time it took to get numb, get xrays, and pay the bill (which I thought was the most painful part of the procedure, lol).
If you make sure to take the pain medication that the doctor prescribes you before the novacaine wears off, you should be fine. I am not going to lie, it does hurt after, but it wasn't anything that I couldn't handle. Also, my face swelled, they told me to put ice on and off the area that swelled in 15 minute increments. The swelling lasted for about two days. Today they removed my stitches, which they do one week after the procedure and they told me that I am healing nicely.
My only advice is to take the day of the procedure off from work and possibly the day after (due to the swelling). I definitely did not feel like doing much of anything those two days. But other than that, you will be fine. It was no worse than having your wisdom teeth pulled. Try not to worry, you'll feel better once you get it over with. Good luck