Taking some hopelessly byzantine, spreadsheet-driven process and “automating” it by building a Rube Goldberg scripting framework around it is the kind of totally stupid automation that doesn’t work.
Actually getting down to surface level and understanding fundamentally what each of those humans is accomplishing via those spreadsheets, extracting that all the way back out to a domain model and process flow diagram, and then selectively replacing process steps, whole cloth, with tech designed to be an actual subservice with SLA targets, is the right way to do it.
Throwing the spreadsheets and/or humans out altogether and starting “from scratch” is so exceedingly and needlessly risky from an information loss and hubris point that, well, good luck, but you’re nearly certain to fail.
Taking some hopelessly byzantine, spreadsheet-driven process and “automating” it by building a Rube Goldberg scripting framework around it is the kind of totally stupid automation that doesn’t work.
Actually getting down to surface level and understanding fundamentally what each of those humans is accomplishing via those spreadsheets, extracting that all the way back out to a domain model and process flow diagram, and then selectively replacing process steps, whole cloth, with tech designed to be an actual subservice with SLA targets, is the right way to do it.
Throwing the spreadsheets and/or humans out altogether and starting “from scratch” is so exceedingly and needlessly risky from an information loss and hubris point that, well, good luck, but you’re nearly certain to fail.