Project Activity Monitoring Automated System
An automated system that detects inactive projects (15 working days without time logs) and instantly notifies responsible stakeholders.
Client / Department Overview
Client Type
IT companies,Marketing agencies,Consulting firms,Remote teams,Startups,Enterprises
Department
Project Management
Tools Involved
Zoho Projects, Google Sheets, n8n, Gmail
The Challenge
As the number of active projects increased, the Project Management team struggled to consistently monitor tasks stuck in Pending, Review, and other waiting statuses.
There was no automated visibility into how long tasks had remained in a specific status creating delays, follow-up gaps, and operational inefficiencies.
Key Pain Points
-
1
Lack of Centralized Status Monitoring
-
2
Heavy Manual Effort for Daily Monitoring
-
3
High Risk of Missed or Delayed Follow-ups
-
4
Delayed Reviews & Client Communication
The Automation Solution
The objective was to build an automated inactivity monitoring system that identifies projects with no time entries in the last 15 working days and immediately notifies the responsible stakeholders. The system eliminates manual tracking, ensures timely follow-ups, and maintains a structured historical log of inactive projects for operational transparency.
Daily Automated Trigger
The workflow runs automatically every day at 5 AM. It pulls the master project list from Google Sheets and starts scanning active projects without manual intervention.
Active Project Filtering
Only projects marked as “Active” are processed. Completed or archived projects are excluded to ensure focused and efficient monitoring.
Dynamic 15 Working Day Calculation
The system dynamically calculates the last 15 working days by excluding weekends. This ensures inactivity is measured based on business days, not calendar days.
Zoho Time Log Verification
For each active project, the system checks via API whether any time logs exist within the defined period. If logs are found, the project is skipped; if not, it is flagged as inactive.
Inactivity Logging in Sheet
Flagged projects are automatically added to a tracking sheet with key details such as Project ID, Name, Owner, Status and Detection Date, creating a historical inactivity record.
Duplicate Prevention & Date Filtering
Before sending alerts, the system filters only today’s detections and removes duplicates. This prevents repeated notifications for the same project on the same day
Owner-Level Grouping
Inactive projects are grouped by PC Owner. If ownership details are missing, a fallback owner is assigned to ensure accountability.
Automated Email Report Generation
For each owner, a structured HTML email is generated containing a summary table of inactive projects with status and direct links for quick action.
Notification Dispatch
The system automatically sends the report to the coordinator and relevant stakeholders, with BCC added for monitoring purposes.
Rate Limit & Stability Control
Wait intervals are implemented between API calls and loops to prevent throttling and ensure stable daily execution.
Workflow Diagram
The Impact
Improved Project Visibility
The automation provided real-time visibility into inactive projects, ensuring that no stalled task went unnoticed. Managers could instantly identify delays and take corrective action without manually reviewing each project.
Significant Time Savings
Daily manual monitoring was completely eliminated, saving several hours of operational effort each week. The team could shift focus from tracking tasks to driving project execution and client communication.
Faster Follow-ups & Reduced Delays
Automated alerts ensured responsible owners were notified immediately. This reduced review delays, improved response time, and accelerated overall project delivery cycles.
Scalable & Reliable Monitoring System
The solution created a structured, repeatable monitoring process that scales easily as project volume grows. With built-in stability controls and logging, the system ensures consistent and error-free daily operations.
Before vs After Snapshot
| Activity | Before Automation | After AI Workflow |
|---|---|---|
| Data Collection | Manual data pull from Zoho Projects; time-consuming and repetitive | Automatic API fetch of the latest project data on schedule |
| Report Generation | Weekly Excel reports, often delayed and dependent on manual effort | Ready every Monday morning, instantly generated and delivered |
| Error Rate | High due to manual entry, copy-paste mistakes, and formula errors | Near 0%, calculated directly from raw API data |
| Manager Visibility | Delayed by 2–3 days with limited oversight | Immediate full overview of all budget deviations and inactive projects |
| Timesheet Follow-Up | Manual reminders sent inconsistently | Automated alerts sent directly to project owners |
| Archived Projects Tracking | Tracked inconsistently and often missed | Logged automatically in the master Google Sheet |
| Compliance Check | Manual validation, prone to oversight | Fully automated and accurate verification process |
Key Features
Automated Inactivity Detection
The system automatically identifies projects with no time entries in the last 15 working days using dynamic business-day logic, eliminating manual monitoring.
API-Driven Real-Time Data
Project and timesheet data are fetched directly from Zoho Projects via API, ensuring accurate, up-to-date, and error-free reporting.
Smart Notification & Owner Grouping
Inactive projects are grouped by responsible owners, and structured email alerts are automatically sent with project details and direct links for quick action.
Centralized Tracking & Audit Log
All flagged projects are stored in a master Google Sheet, creating a historical inactivity record for reporting, compliance checks, and performance analysis.
Streamline Your Projects Today
Transform manual processes into intelligent, automated workflows that keep your projects accurate, aligned, and on track.
