Engagement Data Consolidation Agent

Source: SurveyMonkey - Operations
[
  {"EmployeeID": "3001", "Job Satisfaction": 4, "Supervisor Rating": 4, "Submitted": "2025-01-06", "FreeText": "Overall good experience"},
  {"EmployeeID": "3002", "Job Satisfaction": 3, "Supervisor Rating": 3, "Submitted": "2025-01-06", "FreeText": "Would like more training"},
  {"EmployeeID": "3003", "Job Satisfaction": 2, "Supervisor Rating": 2, "Submitted": "2025-01-07", "FreeText": "Too much workload"},
  {"EmployeeID": "3004", "Job Satisfaction": 5, "Supervisor Rating": 5, "Submitted": "2025-01-07", "FreeText": "Supportive environment"},
  {"EmployeeID": "3005", "Job Satisfaction": 3, "Supervisor Rating": 4, "Submitted": "2025-01-08", "FreeText": "Appreciate recent changes"},
  {"EmployeeID": "3006", "Job Satisfaction": 1, "Supervisor Rating": 2, "Submitted": "2025-01-08", "FreeText": "Long hours and no recognition"},
  {"EmployeeID": "3007", "Job Satisfaction": 4, "Supervisor Rating": 5, "Submitted": "2025-01-09", "FreeText": "Great leadership"},
  {"EmployeeID": "3008", "Job Satisfaction": 2, "Supervisor Rating": 3, "Submitted": "2025-01-09", "FreeText": "Need better communication"},
  {"EmployeeID": "3009", "Job Satisfaction": 3, "Supervisor Rating": 3, "Submitted": "2025-01-10", "FreeText": ""},
  {"EmployeeID": "3010", "Job Satisfaction": 5, "Supervisor Rating": 5, "Submitted": "2025-01-10", "FreeText": "Very satisfied"},
  {"EmployeeID": "3011", "Job Satisfaction": 2, "Supervisor Rating": 1, "Submitted": "2025-01-11", "FreeText": "Micromanagement issue"},
  {"EmployeeID": "3012", "Job Satisfaction": 3, "Supervisor Rating": 4, "Submitted": "2025-01-11", "FreeText": "Room for improvement"},
  {"EmployeeID": "3013", "Job Satisfaction": 4, "Supervisor Rating": 4, "Submitted": "2025-01-12", "FreeText": "Workplace has improved"},
  {"EmployeeID": "3014", "Job Satisfaction": 3, "Supervisor Rating": 2, "Submitted": "2025-01-12", "FreeText": "Better conflict resolution needed"},
  {"EmployeeID": "3015", "Job Satisfaction": 1, "Supervisor Rating": 1, "Submitted": "2025-01-13", "FreeText": "Toxic culture"},
  {"EmployeeID": "3016", "Job Satisfaction": 5, "Supervisor Rating": 5, "Submitted": "2025-01-13", "FreeText": "Excellent support and growth"},
  {"EmployeeID": "3017", "Job Satisfaction": 2, "Supervisor Rating": 3, "Submitted": "2025-01-14", "FreeText": "Need tools for remote work"},
  {"EmployeeID": "3018", "Job Satisfaction": 4, "Supervisor Rating": 4, "Submitted": "2025-01-14", "FreeText": "Work-life balance improved"},
  {"EmployeeID": "3019", "Job Satisfaction": 3, "Supervisor Rating": 3, "Submitted": "2025-01-15", "FreeText": "Average experience"},
  {"EmployeeID": "3020", "Job Satisfaction": 1, "Supervisor Rating": 2, "Submitted": "2025-01-15", "FreeText": "Unclear expectations"}
]
Source: Google Forms - Sales Dept
EmployeeNumber,Team,Engagement Level,Supervisor Score,Date,Feedback_Text
1021,Sales,4,3,2025-01-10,Great team spirit
1034,Sales,2,1,2025-01-09,Need more clarity on goals
Source: Internal HR Tool - Human Resources
[
  {
    "employee_id": "5011",
    "department": "HR",
    "responses": {
      "engagement_score": 5,
      "manager_feedback": 5,
      "submission_date": "2025-01-15",
      "text_response": "Best experience so far"
    }
  },
  {
    "employee_id": "5022",
    "department": "HR",
    "responses": {
      "engagement_score": 3,
      "manager_feedback": 4,
      "submission_date": "2025-01-15",
      "text_response": "More transparency needed"
    }
  },
  {
    "employee_id": "5023",
    "department": "HR",
    "responses": {
      "engagement_score": 4,
      "manager_feedback": 5,
      "submission_date": "2025-01-16",
      "text_response": "Appreciate the new initiatives"
    }
  }
]
Source: Email Survey - Finance Dept
Employee_ID,Department,Engagement_Score,Manager_Score,Date,Comments
7001,Finance,3,4,2025-01-16,Leadership listens
7002,Finance,4,5,2025-01-16,Great benefits package
7003,Finance,2,3,2025-01-17,Stress due to deadlines
Source: Legal Dept Form - Legal
Emp_ID,Dept,Engagement_Score,Manager_Score,Date,Feedback
8001,Legal,5,4,2025-01-18,Highly responsive leadership
8002,Legal,3,3,2025-01-18,Neutral on recent changes
8003,Legal,2,2,2025-01-18,Slow decision-making
8004,Legal,4,4,2025-01-18,Great collaboration
Source: Marketing Dept Feedback - Marketing
EmployeeID,Department,Engagement_Level,Manager_Score,Date,Feedback_Text
9001,Marketing,5,5,2025-01-19,Highly engaged team
9002,Marketing,4,4,2025-01-19,Clear communication from leads
9003,Marketing,3,3,2025-01-19,Open to feedback
9004,Marketing,2,2,2025-01-19,High workload
Source: Internal Form - IT
EmployeeID,Department,Engagement_Level,Manager_Score,Date,Feedback_Text
EmployeeID,Department,Engagement_Level,Manager_Score,Date,Feedback_Text
6001,IT,4,3,2025-01-14,Fast response times
6002,IT,2,2,2025-01-14,Need updated tools
6003,IT,3,3,2025-01-15,Improving culture