Apparently it will only create local alerts. I never noticed that before. It's probably because there is no way for it to start Mail and send one. A limitation of iOS.
I generally create my appointments with email alerts on my computer, or go to the web site of the service and create it there. If you are using Google, you can do this in Safari on the iPad.
Sorry I don't have a better answer for you.