2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I wired my Excel inventory sheet to WhatsApp so it texts me when stock is low. is this dumb?

so I got tired of the morning routine where I open my inventory spreadsheet, scroll through 30 rows looking for red cells, then manually type up a purchase order. every single day. maybe 30-45 minutes of just.. looking and copying.

I ended up connecting the Excel file to a WhatsApp number. the sheet is still the source of truth, all the safety stock thresholds and status flags live in Excel like before. but now instead of me opening the file, it texts me when something drops below safety stock. like "Widget A is at 3 units, safety stock is 10, want me to draft a PO?" and I can reply "yeah and add 10 extra to each" and it generates the whole purchase order. last time it spit out a ~$5,180 PO in seconds instead of me doing it by hand.

when a shipment comes in I just text "update Widget A stock to 50" and it updates the file, flips the status from CRITICAL to OK, and sends me back the updated Excel. if it's not sure what I mean it asks instead of guessing which was important to me.

the core logic still lives in Excel. nothing changed there. there's just a separate service that reads and writes to the file based on my WhatsApp messages.

full disclosure I'm building this into a small tool (ExcelClaw) for myself and a few other people who are way too deep in spreadsheets. so this isn't a neutral post. but I genuinely want to know from people who live in Excel all day:

would you trust something that edits your Excel based on text messages if you can see every change and get the file back? what would you need to feel safe with it.. logging? approval steps? version backups?

and honestly if there's a way to do this natively with Power Automate or VBA that I'm overcomplicating I want to hear that too. I tried VBA before and broke things twice so I gave up but maybe I was doing it wrong

curious what you guys think. if mods feel this is too promo-y I'll take it down, just want honest feedbak from the people who actually use Excel for operations

submitted by /u/hiclemi
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#rows.com
#big data management in spreadsheets
#modern spreadsheet innovations
#self-service analytics tools
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#AI-native spreadsheets
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#real-time data collaboration
#automation in spreadsheet workflows
#no-code spreadsheet solutions