This is our roadworks extension. It can read data from mail, converts it to our needs and save records in DB. The process was realized with a scheduler task.
As this extension is currently customer restricted you have to modify some part on your own. Or you can take some parts as snippets for your own projects.