I have written a simple "audit" system for tables that patches the dal. You can do something similar to send an email on record creation.
See this thread: https://groups.google.com/d/msg/web2py/jKpUVyvNHeE/oufbLz_n1GEJ - which did not receive any response so far.
