Take a look at Marco Polo.... http://www.symonds.id.au/marcopolo/
What you are looking to do is detect an attached USB Device... Which then you can run an shell script, which could activate the automator script, or if you compile the automator script, you could just execute it.