Here is a video from Sal Soghoian who is the lead man at Apple for AppleScript and Automator. He has recently published a book to teach us how to get the best from Automating our Mac’s. has the book and slowly working his way though it.
A book you might find useful is by ben Waldie I have been looking at stuff by this guy online and found it to be very useful. Another option could be this book by Matt Neuburg
You just have to go and visit this on the Mac in particular with Snow Leopard