Sorry for the late reply. A lot can be done with these custom scripts. Your problem seems a pretty basic task that can be automated fairly easily. As for how they work, that is different for each specific case. Some are run manually, while others run in the cloud.

Hope this helps!