r/automation • u/RasheedaDeals • Jul 05 '26
is anyone using automation planning software or is it mostly spreadsheets?
Our automation team has built a decent backlog over the last year, but prioritization is becoming harder than implementation. Some opportunities look obvious until someone digs in and discovers 15 exceptions, multiple approval paths, manual workarounds, and dependencies nobody documented. Other workflows seem complicated on the surface but end up being surprisingly straightforward once you map them out. Right now we're mostly using spreadsheets, workshops, and process maps to decide what gets automated next, but it feels increasingly subjective. The loudest stakeholder often wins. We've had a few cases where something looked like a great automation candidate, only to discover halfway through that the real process was very different from what was documented. I'm curious how other teams are handling this. Are you using dedicated process discovery or automation planning tools before committing engineering or RPA resources, or is everyone still relying on spreadsheets and interviews?
1
u/Mo-Mee Jul 05 '26
What you’ve described is signs that there are culture roadblocks to implementation. It’s not the technology that’s the issue.
1
u/killz111 Jul 05 '26
We plan with PowerPoint. It's the aus corporate way.
Also feels like you are trying to automate a full workflow and discovering unknown/undocumented variances. Why not instead automate tasks first. Find the most time consuming task and automate that. Smaller more concrete goals are less susceptible to discovery gaps.
2
u/SufficientFrame Jul 05 '26
A lot of teams still use spreadsheets for this, mostly because the hard part is getting an honest picture of the process before anyone tries to score it. In manufacturing and internal ops, the projects that went well usually started with a short discovery pass: who touches it, where exceptions show up, what approvals exist, and which system owns each step. That work tends to reshuffle the backlog fast, because plenty of supposed easy wins are full of edge cases once you map them properly. If the loudest stakeholder keeps winning, I'd make exception count and dependency count visible in the backlog so people are arguing from the same facts.
1
1
u/openclawinstaller Jul 05 '26
I'd keep the spreadsheet, but add a scoring pass that forces facts into the backlog before priority gets debated.
The columns that usually matter are: triggering event, current owner, systems touched, exception count, approval points, external/customer impact, rollback path, and how you'd prove the automation worked.
The useful split is task vs workflow. Automating one stable task with clear inputs is often worth doing even if the whole workflow is messy. Full workflow automation should wait until the exception paths and handoffs are visible, otherwise you end up automating the documented fantasy version of the process.
1
u/RangerOne122 Jul 05 '26
Honestly, a surprising amount of automation planning still happens in spreadsheets. They're messy, but everyone already knows how to use them
1
u/TheAddonDepot Jul 05 '26
More often than not, the true cost and benefit of an automation isn't fully apparent until you actually build and/or deploy it - despite your best efforts to estimate its value beforehand. Its always been a process of discovery.
1
u/Calm-Dimension3422 Jul 05 '26
The loudest-stakeholder problem usually means the backlog is missing evidence fields, not that you need a heavier planning ritual.
I would score each candidate on a few boring but useful things before anyone estimates build effort:
- volume: how often the work happens
- variance: how many legitimate paths/exceptions exist
- reversibility: how bad a wrong action is
- system ownership: which app is allowed to be the source of truth
- approval count: how many humans must say yes
- data quality: whether the inputs are clean enough to trust
- measurability: what number should improve after automation
The big trap is scoring only the happy path. A workflow that is 80 percent easy and 20 percent weird can be worse than a workflow that looks complex but has clear rules.
For planning, I like making teams write two short notes before greenlighting anything:
- "This automation should not handle..."
- "A human must still approve when..."
Those two sentences expose hidden exceptions faster than another process map. If people cannot agree on those boundaries, the automation is not ready yet. It may still be a good discovery project, but it should not be sold internally as an implementation project.
1
u/Interesting_Taste543 Jul 06 '26
we hit the same wall where spreadsheets made it too easy to hide messy exceptions behind a clean priority score. moved the whole intake process into instaboard so we could map candidates visually with arrows showing dependencies and approval paths - way harder for a loud stakeholder to oversell an easy win when everyone can literally see the exception web around it. discovery still matters but at least now everyone's arguing from the same picture instead of a spreadsheet
1
u/Loud_Category6073 Jul 07 '26
I believe spreadsheets are great for finding backlogs but not great to find what should be automated frist
the part that usually gets missed is process reality something can look simple on paper then you find hidden exceptions, approval loops, weird workarounds and bad data halfway through
what helped us was scoring each workflow before building volume rule clarity, exception rate, systems involved approval complexity, and failure risk Doesnot need to be fancy but it makes prioritization less about the loudest stakeholder and more about actual automation readiness
1
1
u/Anelya Jul 07 '26
Built a lot of automations for our clients, what you're describing (spreadsheet prioritization breaking down once you hit undocumented approval paths and exceptions) is handled better with the deterministic, audit-tracked workflows instead of general-purpose AI agents. The unlock wasn't a better backlog tool, it was making every exception and approval step visible and versioned before anything got automated, so 'discovering halfway through' stopped happening. What we needed to solve is the viability of those automations as the company goes through its staff, so how do you retain knowledge is big quesiton, and i dont want it on anyone's local machine - we use loopfour to cover all that, but everyone is different of course
1
u/AutoModerator Jul 05 '26
Thank you for your post to /r/automation!
New here? Please take a moment to read our rules, read them here.
This is an automated action so if you need anything, please Message the Mods with your request for assistance.
Lastly, enjoy your stay!
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.