Skip to content
Back to portfolio
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.

Desktop Ops Automation | Windows and Apps Script operations automation suite

Overview

Desktop Ops Automation collects small but high-leverage tools built for office workflows that were too repetitive to keep manual and too specific to justify a large SaaS.

The smart file classifier organizes Downloads, Desktop, and KakaoTalk files with run reports. PC Health Tool packages Windows diagnostics into a batch launcher and zip distribution. Daily CRM reporting and blog monitoring use Python, HTML dashboards, and Google Apps Script so operators can inspect results directly.

Its strength is practical fit. It handles local Windows files, Google Sheets, HTML dashboards, and generated reports, reducing friction in real office operations.

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

  1. 1Built a smart file classifier to organize Downloads, Desktop, and KakaoTalk files with run reports.
  2. 2Packaged PC Health Tool as batch launch, PowerShell diagnostics, zip distribution, and report output.
  3. 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

Desktop Ops Automation screenshot 1