Portfolio | SpiroTech IT Solutions

Google Sheets + Chatbot Data Flow

Problem: Manual collection and sorting of user responses caused delays and errors.

Solution: Built a Google Apps Script workflow that listens for chatbot triggers (WATI), validates inputs, and auto-routes rows to the correct tabs.

Outcome: Hours saved weekly, higher data accuracy, and no double capture.

Google Apps Script Google Sheets WATI Zapier

Notes: Included error handling & notifications to flag anomalies, plus a readme for hand-over.

My role: Design, implementation, test, and documentation.

Small Business IT Support Stabilisation

Problem: Intermittent printer failures and Wi-Fi drop-outs impacting operations.

Solution: Driver cleanup, standardized printer queues, router DNS adjustments, and basic device hardening.

Outcome: Fewer support incidents, faster startup each day, and traceable documentation.

Windows Networking M365 Documentation

Notes: Added lightweight maintenance checklist and a “when to call” guide for staff.

Data Cleanup & Reporting

Problem: Duplicates and inconsistent fields made reporting unreliable.

Solution: ETL cleanup using Sheets formulas + Apps Script, added validation and import templates.

Outcome: Consistent weekly reports and quicker decision-making.

ETL Validation Reporting

Notes: Set up versioned tabs and a simple “revert” process.