From Manual to Automated: Building Scalable Agency Workflows with AI