I use a spreadsheet too and my general feeling is that effective effortless budgeting is a non starter.
My budget is only really as effective as much as it influences my understanding of my finance and influences my behaviour. Time spent collating my budget is time for me to think ‘oh I’ve bought too much of that’, ‘hey where did that pot go’ etc - that’s why I manually categorise all my transactions at the end of the month.
Sure I could do it automatically but I’d probably spend the same hour or so then looking at the results, and if I didn’t, then it’d be sort of pointless because it doesn’t really matter if there’s a great automatic spreadsheet or something sitting there that calculates my spending unless I’m actively engaged with that!
Still, for people who prefer not to do it, You Need a Budget is still the king in my eyes. By far the best layout and data analysis to help people manage their budget and I’ve read it’s helped a lot of people out of debt. There is a paywall, but it’s probably worth it.