Designed an AI-assisted workflow system to improve execution visibility and identify project risks from daily updates.
The Challenge
In many teams, daily updates exist but execution clarity is still missing.
Managers often spend time manually reviewing scattered updates to understand:
whether projects are on track
where delays are happening
what needs immediate attention
This can lead to delayed decisions, missed risks, and unnecessary status meetings.
The Solution
Built an AI-assisted execution tracking workflow using:
Google Forms
Google Sheets
Make.com
Gemini AI
The system
captures structured project updates
analyses execution progress
identifies risks and deviations
generates actionable summaries
updates a centralized visibility dashboard
Example Output
The workflow generates:
project status indicators
deviation analysis
execution risk visibility
recommended next actions
This helps teams improve operational visibility and decision-making.
Result
✓ Improved visibility into project execution status
✓ Reduced manual review effort
✓ Faster identification of risks and delays
✓ Structured reporting from daily updates
Tools Used
Google Forms
Google Sheets
Make.com
Gemini AI
Key Learning
Execution updates alone do not create clarity.
Operational visibility improves when updates are converted into structured insights and actionable information.
Link to Demo: