What Happens If I Take Too Many Sleeping Pills?

In extreme case you can die.
Even if you escape death, Overdose of sleeping pills have long term effects on their nervous system and the normal functionality of the brain.
..
If you know that someone has taken sleeping pills, then immediately give them salt water so that they bring the pills out through vomit. Making the person forcibly vomit until medical help arrives is the best strategy.