Windows and Apps Script operations automation suiteMVP
Desktop Ops Automation
A suite of PowerShell, Python, and Apps Script tools for file sorting, PC health checks, daily CRM reports, and blog monitoring.
Overview
A set of small tools for office work that was too repetitive to keep doing by hand and too specific to justify buying a SaaS for.
The file classifier sorts Downloads, Desktop, and KakaoTalk files and leaves a run report. PC Health Tool wraps Windows diagnostics into a batch launcher and a zip you can hand someone. Daily CRM reporting and blog monitoring run on Python, HTML dashboards, and Google Apps Script so an operator can just open the output.
Keeping them small was the point. The job only ever touched local Windows files, Google Sheets, dashboards, and reports, and I did not build past that.
Core skills
Windows PowerShell automation and safe file-move design
Python report generation, local packaging, and operations logs
Google Apps Script sheet and dashboard operations
Implementation
- 1Built a smart file classifier to organize Downloads, Desktop, and KakaoTalk files with run reports.
- 2Packaged PC Health Tool as batch launch, PowerShell diagnostics, zip distribution, and report output.
- 3Combined HTML dashboards and Apps Script so non-developer operators can monitor CRM and blog workflows.
Strengths
- Turns repeated back-office problems into small tools without forcing every workflow into a large SaaS.
- File moves leave reports and recovery context so operators can inspect outcomes.
- Covers both local Windows work and Google Sheets workflows for real office environments.
Metrics
35
classifier runs
7
HTML dashboards
5
Apps Scripts
3
health reports
Tech stack
PowerShellPythonGoogle Apps ScriptHTMLSQLiteBatch
Screenshots