Common mistakes include automating broken processes without improvement, underestimating change management needs, choosing wrong automation tools, insufficient testing, over-automating processes requiring human judgment, poor documentation, inadequate security planning, focusing only on cost reduction, and lacking clear success metrics to measure effectiveness.