I am a 27 year old female i had a severe stomach pain that woke me up in the middle of the night and was so painful it was causing me to sweat.

Too little info: Abdominal pain that awakens one from sound sleep can be serious and causes can include ulcers, gallbladder disease, bowel obstruction or perforation, pancreatitis, incarcerated hernia, ischemic bowel to name just a few. If persistent or recurrent you need evaluation. If was single self limited episode that resolved then can wait to see if recurs as long as no other symptoms of concern.