Well from just going by the examples they have shown with downloading pictures from the internet and then burning them to disc with iDVD tells me that Automater to be able to automate that process it would have to open Safari to get the pictures then iDVD to burn them.
I thought Automater will also be able to start at specific times to do tasks that you want it to do like get the pictures off your friends site every Friday at 6. This is the only part of Automater that I am not to sure on.
But if it can start at times that you assigned to it on a schedule and can open programes and use basic funtions in them. Basically I thought Automater is basically a user friendly GUI for Apple Script. Seeing that Apple Script can do all that (Not a script kiddie so I might be mistaken in any of the above) it should be able to do what you want. Guess you'll find out in a few days.