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. Wayne who is Legion11 has the book and slowly working his way though it.
A book you might find useful is by ben Waldie Automator for Mac OS X 10.5 Leopard: Visual QuickStart Guide I have been looking at stuff by this guy online and found it to be very useful. Another option could be this book AppleScript: The Definitive Guide, 2nd Edition by Matt Neuburg
You just have to go and visit this new site with loads of information about Automation on the Mac in particular with Snow Leopard