How to make my workflows run again with Automator Runner after upgrading to Mountain Lion?
You could always convert your workflows to Automator Applications if you want to be able to run them by double clicking. Open the workflow up in Automator, duplicate it, and save it with a File Format of Application, rather than the default Workflow: