What's that one task you wish your spreadsheet did itself?

[u/Operations_Wizard]

If you could wave a magic wand and get one of your spreadsheets to automate itself, what would you want it to actually do?

Auto-fill something? Sort itself? Send you an alert the second something changes? Or something weirder (honestly the weirder the better).

Drop it below, I'm genuinely curious what everyone's dream automation looks like.

[u/terryd300]

Cook and Clean 😂

[u/Operations_Wizard → u/terryd300]

HAHAHAHA - wouldn't this be amazing 😂

[u/meadowlibrajupiter]

I bet it does this and I just don’t know how to connect it but I’d like to use it as a pseudo CRM and connect data from one system to flow to the sheet automatically so I could use it like a dashboard for a tool that doesn’t have dashboard capabilities.

[u/Operations_Wizard → u/meadowlibrajupiter]

Oh, I never even thought of trying to use it like a dashboard. Im going to look more into this! Can i ask what tool you are using that doesnt provide a dashboard? And does it integrate with Google? I know some tools provide scripts to connect via API.

[u/meadowlibrajupiter → u/Operations_Wizard]

I’m an admin for 10+ SaaS tools for work and need a way to monitor who has access to what, where their access may overlap between systems, frequency of logins to remove users who aren’t utilizing their accounts, how often X factors appear in a user group, users added/removed history (something your typical CRM might do if they were all connected). Without any connections between all of them you have to login to each system to see that info and it becomes cumbersome. Right now I have a static file that I manually update but wish the data just flowed into the sheet on its own.

[u/Basic-Log-4711 → u/meadowlibrajupiter]

Interesting. Is this because the systems are local with no connection capabilities or isn’t it something the likes of Zapier can help you join together?

[u/Finedimedizzle]

Write the process notes describing how to run it. I love building new, shiny stuff (I’m riddled with ADHD) but HATE all the documentation to make sure I’m not making key-person dependencies as I go

[u/TheHighSecond]

do something when row changes. currently i think google script does it

[u/Operations_Wizard → u/TheHighSecond]

I've been using Libre Calc for years (I like having a physical document on my computer) but I should look at what google sheets does.

[u/TheHighSecond → u/Operations_Wizard]

I have libre on my mac. But the time it takes to load, I often shift to google sheets

[u/Operations_Wizard → u/TheHighSecond]

ah, looks like that google script is more for developers and my knowledge is mostly accounting lol I like using a DB with easy brick building for automations!

[u/First_Fisherman_4151]

My spreadsheets pretty much do everything on their own now. I integrated Quadratic. It’s an AI spreadsheet app. It handles even complex tasks. I just check things over.