Automated Employee Feedback Sentiment Tracker & Weekly Digest

📌 OverviewThis workflow automates the weekly collection and sentiment analysis of anonymous employee feedback. It retrieves responses from Google Sheets, aggregates and processes them, performs AI-powered sentiment analysis, and emails HR a summarized digest report for tracking overall employee sentiment.

Category: HR & People OperationsTrigger: Every Friday at 12:00 PM (Scheduled)

⚙️ Workflow Steps

1. Trigger Once a Week (Schedule)
2. • Runs automatically every Friday at 12:00 PM.
   • Starts the workflow for weekly feedback processing.
3. Get Employee Feedbacks of The Week (Google Sheets)
4. • Fetches employee feedback responses from the Google Sheet linked to the company’s feedback form.
   • Retrieves all new responses marked as not yet processed.
5. Aggregate Responses
6. • Combines all feedback entries into a single dataset.
   • Prepares the data for analysis and reporting.
7. Update Response Status (Google Sheets)
8. • Marks processed responses as Done in the feedback sheet.
   • Ensures that only new responses are included in the next week’s analysis.
9. Sentiment Analysis Agent (OpenAI)
10. • Runs AI sentiment analysis on the collected feedback.
    • Generates an easy-to-read HTML summary that highlights employee satisfaction levels and recurring themes.
11. Send Analysis Result to HR (Gmail)
12. • Sends the weekly feedback digest to HR.
    • Subject: Analysis of This Week’s Feedback
    • Body: Includes the AI-generated sentiment analysis report.

🗂️ Data Sources

• Google Sheets: Stores employee feedback responses and tracking status.
• OpenAI: Performs sentiment analysis on employee feedback.
• Gmail: Sends the digest report to HR weekly.

✅ Key Benefits

• Automates weekly collection and analysis of employee feedback.
• Ensures HR receives consistent, structured insights without manual effort.
• Improves visibility into employee satisfaction trends.
• Saves time while keeping employee responses anonymous and actionable.