Has anyone used docs Automator?

Yes, that should be quite doable using a workflow.
How would you want it to be triggered?
ie. by a User clicking a button, on a schedule, or some other way?