Weekly Employee Feedback Summary for HR

This workflow triggers every Monday at 10 AM to fetch the past week's employee feedback entries from a designated Google Sheet. It processes up to 100 rows at a time, ensuring efficient handling of submissions. The data is then fed into OpenAI's GPT-4o model to generate a concise, insightful summary report highlighting key themes, sentiments, and actionable insights for HR and management.

After summarization, the workflow sends the polished report via email to relevant stakeholders, keeping everyone informed without manual effort. Finally, it automatically deletes the processed rows from the sheet, maintaining a clean slate for new feedback and preventing data accumulation.

Ideal for HR teams in universities or organizations needing regular feedback oversight. Benefits include time savings on manual reporting, improved decision-making through AI insights, and seamless integration of Google Sheets, AI, and email. Use cases: employee satisfaction tracking, pulse surveys, or performance review prep, reducing administrative burden by 90%.