Ambien is strong stuff and likely to leave you groggy and tired for a day or two.
I would look at Diphenhydramine HCI, which is an antihistamine that makes you drowsy, but it's pretty mild stuff. It is the active ingredient in lots of over the counter products like Benadryl, Tylenol PM, Sominex, etc.