Analyze Workplace Discrimination Patterns with AI
detail.loadingPreview
Scrape Glassdoor data and use OpenAI to identify and analyze potential workplace discrimination patterns based on demographic and rating information.
About This Workflow
This workflow automates the process of gathering company review data from Glassdoor and leveraging AI to analyze it for signs of workplace discrimination. It scrapes company information, extracts review summaries and demographic data, and then uses OpenAI's language models to process this information into structured insights.
Key Features
- Automates data scraping from Glassdoor.
- Utilizes OpenAI's
lmChatOpenAifor advanced text analysis. - Extracts key metrics like average ratings and review distributions.
- Analyzes demographic data for potential biases.
- Generates structured metadata for further analysis.
How To Use
- Trigger: Start the workflow by clicking 'Test workflow' on the manual trigger node.
- Set Company: The 'SET company_name' node defines the company to analyze (currently set to 'Twilio'). Modify this to analyze other companies.
- Scraping: The workflow uses ScrapingBee to access Glassdoor, first searching for the company and then navigating to its company and reviews pages.
- Data Extraction: HTML nodes are used to extract the overall review summary and the demographics module.
- AI Analysis: Two
lmChatOpenAinodes are employed:- 'Extract overall ratings and distribution percentages' analyzes the review summary.
- 'Extract demographic distributions' analyzes the demographics content.
- Merging Data: The 'Merge' node combines the extracted data from both AI analysis steps.
- Final AI Processing: The 'OpenAI Chat Model' node performs a final analysis on the combined data to generate structured metadata.
Prerequisites:
- Valid OpenAI API credentials.
- Valid ScrapingBee API credentials.
Apps Used
Workflow JSON
{
"id": "a17e3a3a-d6d8-464d-9741-96d798c30294",
"name": "Analyze Workplace Discrimination Patterns with AI",
"nodes": 25,
"category": "human_resources",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: a17e3a3a-d6d8...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Automate Local Business Outreach with AI-Powered Yelp Scraper
This workflow automates the process of scraping local business details from Yelp using AI, then leverages that data to send personalized partnership proposals via Gmail. It's perfect for sales and marketing teams looking to streamline lead generation and outreach campaigns.
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.