{ WYO } DREW
  • Home
  • Blog
  • Projects
  • About
  • Contact
  • XML Conversion & Automated Publishing Pipeline

    A fully automated XML ingestion and publishing workflow that processes uploaded files, renames them to a standardized format, and delivers them to a public-facing document library—eliminating manual intervention and ensuring timely updates to customer-facing content.

    This project was built to simplify and standardize the process of publishing XML files required by a public-facing website. Previously, files were manually renamed, moved, and validated by multiple team members, creating bottlenecks and increasing the risk of errors. To solve this, I designed an automated pipeline using Power Automate and SharePoint Online.

    The system begins with a dedicated drop-off document library where internal teams upload raw XML files. The moment a file arrives, a Power Automate workflow triggers and reads the file metadata, validates the filename and structure, and applies a consistent naming convention based on predefined business rules.

    After processing, the workflow automatically moves the renamed XML file to a separate publishing document library—a location synchronized with a publicly accessible website. This ensures that updated files are available online within seconds of being submitted.

    The automation eliminates manual handling, reduces errors caused by inconsistent filenames, and ensures a continuous and reliable flow of content updates to the public site. With this workflow in place, the teams involved gained a faster, more accurate publishing process with clear separation between staging and production environments.

  • AI-Driven Receipt & Invoice Processing Workflow

    A fully automated workflow built in n8n that extracts structured financial data from uploaded receipts and invoices using AI, validates and formats the output, and logs all entries into Google Sheets for bookkeeping and property-management tracking.

    This project demonstrates my ability to design and build real-world AI automation solutions using n8n, OpenAI, and Google Workspace.

    The workflow accepts a document upload from a custom form, processes it with an AI extraction model, and returns structured fields including vendor, date, amount, category, and payment type. The automation then sanitizes the extracted values, checks for missing data, and handles fallback logic if the AI returns incomplete results.

    Once validated, the flow writes a new row into a Google Sheet, serving as a simple accounting ledger for property management. Future versions include auto-categorization, OCR fallback for low-quality scans, and a mobile app for snapping photos of receipts on the go.

    This system replaces inconsistent manual entry with a clean automation pipeline—saving time, reducing errors, and giving property managers real-time visibility into expenses.

  • New Hire IT Request Application

    A streamlined onboarding application built with Power Apps, Power Automate, and SharePoint to centralize IT provisioning requests, automate approval workflows, and reduce setup time for new employees across multiple departments.

    This project was created to solve a recurring onboarding challenge: IT teams were receiving scattered, inconsistent new-hire requests from managers across the company, leading to delays, missing equipment, and unclear access rights. I designed and developed a dedicated New Hire IT Request Application to centralize the process, enforce accuracy, and introduce automation.

    Using Power Apps, I built a clean, user-friendly form where managers can request devices, software access, system permissions, and special setup needs for incoming employees. Each selection dynamically reveals the relevant configuration options and prevents incomplete submissions.

    Submitted requests trigger a Power Automate workflow that routes the request to the appropriate departments (IT, HR, Security) and automatically generates tasks based on what equipment or system access is needed. All requests are logged in SharePoint, with metadata allowing the IT team to filter by priority, job role, manager, and provisioning status.

    By introducing this tool, onboarding time was reduced, communication improved, and accountability strengthened. The app eliminated manual emails, ensured nothing fell through the cracks, and gave the IT team a reliable dashboard of all incoming new-hire needs.

© 2025 Drew Reutlinger. All rights reserved.