I have used it to convert text to an audio file to play in iTunes. I have also used it to close a QT window and play the next one as described in my posting at
http://discussions.apple.com/thread.jspa?threadID=2115674&tstart=0. This was to save time in a repetitive sequence.
Have you viewed the description of the Automator, video, and tutorials on the web?
Open the Automator, click on the Automator drop down menu in the menu bar, & click on "Display Automator Website". This will open an Apple web page of applications and descriptions. Read the Automator description and click on the link "Learn more about Automator". (You may also later want to click on the link "Learn more about AppleScript".) This link will take you to a site to learn lots about it and how to create workflows that you may want to put to use. At the home page there is a movie at the top of the right hand bar that is about 7 minutes long. You can watch it as an introduction to Automator and a few things to do with it.
Hope that helps.
Have Fun,
DarrellSY