AI Workplace Bias Analyzer & Reporter

Unlock Insights into Workplace Equity with this AI Agent

This AI-driven n8n workflow empowers you to proactively identify and analyze potential workplace discrimination patterns by leveraging public employee sentiment. It systematically scrapes Glassdoor reviews for a company you specify, employs OpenAI's advanced language models to extract nuanced data on how different demographic groups perceive their workplace, performs statistical analysis (including Z-scores, P-scores, and effect sizes), and then creates clear visual reports (bar charts and scatterplots via QuickChart) alongside an AI-generated textual summary of key findings. This agent is a powerful tool for HR leaders, DEI champions, and founders committed to building an equitable workplace or understanding competitor employee landscapes.

Key Features & Benefits

• Automated Data Collection: Seamlessly scrapes company review data from Glassdoor using ScrapingBee, saving hours of manual effort.
• AI-Powered Sentiment Analysis: Utilizes OpenAI (GPT models via Langchain nodes) to intelligently extract overall review summaries and detailed sentiment scores across various demographic categories (race, gender, LGBTQ+, disability, etc.).
• Robust Statistical Insights: Automatically calculates variance, standard deviation, Z-scores, P-scores, and effect sizes to statistically highlight significant disparities in reported experiences among employee groups.
• Clear Visual Reporting: Generates easy-to-understand bar charts and scatterplots using QuickChart, visualizing the effect sizes and Z-scores for different demographics.
• AI-Generated Summary: Provides a concise, AI-driven textual analysis of the findings, offering key takeaways and potential interpretations of the data.
• Actionable Intelligence: Equips you with data-driven insights to inform DEI strategies, address specific concerns, and foster a more inclusive work environment.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key with access to a suitable model (e.g., gpt-3.5-turbo, gpt-4). Ensure your OpenAI account has sufficient credits/billing enabled.
• ScrapingBee API Key and account with sufficient credits.
• The target company name for analysis.

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure all OpenAI-related nodes (including 'OpenAI Chat Model', 'Information Extractor', and 'LLM Chain' types) by selecting or creating your OpenAI API credentials.
4. Configure the three 'ScrapingBee' HTTP Request nodes ('ScrapingBee Search Glassdoor', 'ScrapingBee GET company page contents', 'ScrapingBee GET Glassdoor Reviews Content') by selecting or creating your ScrapingBee Query Auth credentials. This credential should include your ScrapingBee API key (usually as a query parameter named api_key).
5. In the 'SET company_name' node, update the 'company_name' value with the target company (e.g., ="YourCompanyName").
6. (Optional) Review the 'Define dictionary of demographic keys' node if you need to customize or add demographic categories for analysis.
7. Ensure all credential nodes are correctly configured and tested.
8. Activate the workflow. You can trigger it manually using the 'When clicking ‘Test workflow’' node.
9. Examine the output of the 'Quickchart Scatterplot', 'QuickChart Bar Chart', and 'Text Analysis of Bias Data' nodes for the results.