Automator is inviting to open but once its open it confuses a lot of people. I use it quite a bit for purposes relating to importing music and pictures. I even have it set up to send files to remote computers (really helpful in the Finder).
Use the tutorial that comes with Automator, it will open your eyes a bit.