top of page

AI Automation & Intelligent Systems Portfolio

Transforming Data Into Intelligent Action

AI-powered automation solutions I designed to solve real operational challenges. Each system integrates workflow automation, structured AI reasoning, and business logic to reduce manual processes and improve decision-making.

Rather than building static reports, I focus on designing intelligent pipelines that:

  • Monitor real-time data

  • Apply conditional logic

  • Integrate LLM-based classification

  • Automate communication

  • Route information to the right stakeholders

  • Create scalable operational infrastructure
     

These projects demonstrate how artificial intelligence can be embedded directly into business workflows to increase efficiency, accountability, and responsiveness.

Case Study: AI-Powered Customer Feedback Routing System
February 2026

Daily Bean Cafe Workflow in n8n.png

A growing café business was receiving

customer feedback through Google

Sheets submissions. However:

  • Feedback was manually reviewed

  • Messages were not consistently

  • routed to the correct department

  • Kitchen, delivery, and service teams
    were not notified promptly

  • Operational issues were sometimes
    delayed due to slow triage

Manual review created bottlenecks and
       inconsistent response times.

The business needed an automated
       system to:

  • Classify feedback

  • Route issues to the correct team

  • Improve response time

  • Reduce manual review workload

🧠 Solution Architecture

I designed and deployed an AI-driven workflow automation system using n8n and a structured LLM model.

System Flow:

Google Sheets Trigger
→ Data Preprocessing
→ AI Categorization (Gemini Model)
→ Structured Output Parsing
→ Conditional Routing Logic
→ Automated Email Notification

The workflow monitors new entries in real time, uses an LLM to categorize the feedback into one of four operational areas:

  • Kitchen

  • Delivery

  • Service

  • Other

The system then automatically routes notifications to the appropriate department via Gmail integration.

🛠 Tools & Technologies Used

  • n8n (Workflow Automation)

  • Google Sheets Trigger

  • Google Gemini Chat Model (LLM)

  • Structured Output Parser

  • Conditional Routing (Rule-based logic)

  • Gmail API Integration

  • Data Normalization Layer

📊 Business Impact

✔ Reduced manual review of feedback
✔ Improved response time by automating routing
✔ Increased operational accountability
✔ Enabled department-level tracking of recurring issues
✔ Created scalable infrastructure for future analytics

This system demonstrates the practical application of AI for operational efficiency and intelligent process automation.

What I Learned

  • How to implement structured LLM outputs for reliable classification

  • How to integrate AI reasoning into real-time workflow automation

  • The importance of rule-based routing after AI classification

  • How to build scalable, business-focused AI solutions

  • The value of combining AI with traditional automation logic

Case Study: AI-Powered Low Inventory Monitoring
& Alert System

January 2026

A retail operation was tracking inventory inside Google Sheets. However:

  • Inventory levels were manually

  •    reviewed

  • Low-stock items were often caught

  •    too late

  • Reordering decisions were

  •    reactive instead of proactive

  • Staff spent unnecessary time

  •    checking spreadsheets

The business needed an automated

 monitoring system that could:

  • Detect low inventory levels

  • Summarize impacted items

  • Notify stakeholders automatically

  • Reduce manual oversight

🧠 Solution Architecture

I designed and implemented a scheduled AI-powered inventory monitoring workflow using n8n and LLM-assisted reasoning.

System Flow:

Scheduled Trigger
→ Retrieve Inventory Data (Google Sheets)
→ Filter Low-Stock Items
→ Aggregate Results
→ AI Agent Reasoning Layer
→ Automated Email Notification (Gmail)

The workflow runs automatically on a schedule and:

  • Identifies products below threshold

  • Aggregates affected items

  • Uses an AI model to generate a contextual alert message

  • Sends a structured notification to stakeholders

This ensures proactive inventory management without human intervention.

🛠 Tools & Technologies Used

  • n8n Workflow Automation

  • Google Sheets API

  • Data Filtering & Aggregation Nodes

  • AI Agent (Gemini Model)

  • Simple Memory Module

  • Gmail API Integration

  • Scheduled Trigger

📊 Business Impact

✔ Prevents stockouts
✔ Reduces manual spreadsheet monitoring
✔ Enables proactive restocking decisions
✔ Improves operational continuity
✔ Demonstrates AI-assisted automation in business workflows

The system transforms passive data storage into active operational intelligence.

 

💡 What I Learned

  • How to combine deterministic filtering logic with AI-generated messaging

  • How to structure scheduled automation for operational monitoring

  • How to use aggregation to reduce noise in alerting

  • How AI can enhance business communication clarity

  • How to design scalable monitoring systems

Low Inventory Alert.png

AI-Powered Business Automation Systems
January 2026

White Structure

AI Customer Feedback Categorization System

AI Customer Feedback Routing System (LLM-Powered Classification)
Developed an AI-powered workflow that:

  • Monitors new customer feedback entries

  • Uses a structured output LLM model

  • Categorizes feedback into:

    • Kitchen

    • Delivery

    • Service

    • Other

  • Automatically routes notifications to the appropriate department

Business Value

  • Reduces response time

  • Improves operational efficiency

  • Enables data-driven quality control

Tools Used
n8n | Google Sheets Trigger | Gemini LLM | Structured Output Parser | Conditional Routing | Gmail API

Automated Sales Reporting Agent

Automated Sales Reporting Agent (n8n + API Integration)
Designed and deployed a scheduled automation workflow that:

  • Pulls sales data via API

  • Applies conditional logic

  • Formats business-ready reporting metrics

  • Sends structured outputs to Airtable and Discord

  • Runs on a scheduled trigger

Business Value

  • Eliminates manual reporting

  • Ensures consistent KPI tracking

  • Enables real-time decision visibility

Tools Used
n8n | HTTP APIs | Conditional Logic | JavaScript | Airtable | Discord Integration

Low Inventory AI Alert System

Low Inventory Monitoring Agent (Google Sheets + AI + Gmail)
Built an automated agent that:

  • Reads inventory data from Google Sheets

  • Filters low-stock items

  • Aggregates data

  • Uses AI reasoning to determine notification criteria

  • Sends automated alert emails

Business Value

  • Prevents stockouts

  • Improves supply chain response

  • Reduces manual inventory checks

Tools Used
n8n | Google Sheets API | AI Agent | Gemini Model | Gmail API

Stripes

Portfolio List

September 2025
Database Management


This course expanded my understanding of advanced database concepts, focusing on optimization, indexing, and data integrity across multi-user environments. I designed and implemented relational databases using MySQL Workbench, emphasizing referential integrity, normalization, and security best practices.

Through applied projects, I explored transaction management, concurrency control, and performance tuning — essential skills for maintaining efficiency and accuracy in enterprise-level database systems.

September 2025
Managerial Applications of Business Analytics


In this capstone-level analytics course, I applied data analysis techniques to real-world business challenges. Using Excel and Python, I developed models for forecasting, regression, and decision support to guide managerial decision-making.

My final project focused on Monte Carlo simulation and business scenario modeling to evaluate performance metrics and optimize strategic planning.

July 2025
AI-Driven Business Application Coding
CIS313


This project demonstrates my foundational knowledge and practical experience in artificial intelligence and machine learning. Through this work, I have explored and applied key AI and data science concepts, including knowledge representation and designing effective data workflows. I collected, cleaned, and prepared datasets to train and test various machine learning models.

As part of this project, I built and trained a linear regression model for predictive analytics and developed classification models to categorize data accurately. I also designed and implemented clustering models to identify patterns and groupings within complex datasets, gaining experience with different clustering algorithms.

To expand my machine learning toolkit, I developed decision trees and random forest models, and built an artificial neural network to deepen my understanding of advanced predictive methods. Throughout the project, I also examined the ethical, security, and privacy considerations critical to responsible AI development and deployment.

December 2024
Introduction to Operating Systems
CEIS106


This course covers the fundamental concept of an operating system and outlines the key features of the Linus operating system. It covers the origins of the Linus operating system and identifies the characteristics of various Linus distribution a and where to find them.

It also tells about the common uses of Linus in the industry today, work with a virtual machine, and access the Linus system.

September 2024
Smart Home
Automatic Security System
CEIS101


This course project covers the fundamental concept of the IoT b integrating hardware, software, and networks into an entire system. The project is divided into six parts where each part builds upon the previous resulting in an IoT device that will simulate a smart home automation and security system. The design and development process of this project truly encompasses various aspects of the IoT and will prepare you for your future career in technology. The objective is to introduce simulation using a virtual emulator, to familiarize with hardware components required to build physical system, to familiarize with programming logic and design of hardware, to familiarize with error handling principles in operating systems.

March 2025
Introduction to Technical Project Management
CEIS298


Technical project management (TPM) is a specialized approach focusing on technical projects like software development, IT infrastructure, and hardware installation. It requires technical expertise, project management skills, and planning, budgeting, scheduling, risk management, and communication. TPM projects include cloud migration, SDLC, infrastructure upgrades, and cybersecurity initiatives.

May(2) 2025
Database Systems and Program Fundamentals CEIS236
Gameboard Database


This course explores universal aspects of database systems that are common across
programming languages, operating systems, or application types. Systems reviewed range from personal device and desktop databases to large-scale, distributed database servers. Classic
relational databases to modern data warehouses are presented. Topics covered are library
creation, primary key selection, column identification, defining relationships, normalization, data indexing and storage, and query languages. Students code and execute programs and routines that create, insert, update, and delete data

May 2025
Database Systems and Program Fundamentals CEIS236
GroundedGlory Database


This course examines database system features that are uniform across operating systems, computer languages, and application categories. The systems under review span from desktop databases and personal devices to massive, dispersed database servers. We present both contemporary data warehouses and traditional relational databases. Throughout this course, i achieved the following: created a physical database from the logical model, created an entity relationship diagram, described the normalization process for a database, assessed the security requirements for a database, created a database with both basic and sophisticated reports based on queries, and designed queries to retrieve requested data using SQL statements.

© 2024. Anita R. Woods
© 2025 TechCore Projects | Virtual Assistant & Data Analytics Support
Powered and secured by Wix

bottom of page