Spot workplace discrimination patterns with AI
Ready for 3.0What this workflow does
This AI workflow has 26 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model and QuickChart. It also calls app.scrapingbee.com and quickchart.io over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- SET company_name (Edit Fields (Set)): sets 1 field: company_name
- Define dictionary of demographic keys (Edit Fields (Set)): sets 19 fields: asian, hispanic, white…
- ScrapingBee Search Glassdoor (HTTP Request): calls app.scrapingbee.com
- Extract company url path (HTML): parses or builds HTML
- ScrapingBee GET company page contents (HTTP Request): calls app.scrapingbee.com
- Extract reviews page url path (HTML): parses or builds HTML
- ScrapingBee GET Glassdoor Reviews Content (HTTP Request): calls app.scrapingbee.com
- Extract Demographics Module (HTML): parses or builds HTML
- Extract Overall Review Summary (HTML): parses or builds HTML
- Extract demographic distributions (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
…plus 12 more steps. See the full node list below.
Services it uses
HTTP calls to: app.scrapingbee.com, quickchart.io
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Code
n8n-nodes-base.code - QuickChart
n8n-nodes-base.quickChart - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
From the author
How It Works: • Scrapes company review data from Glassdoor using ScrapingBee. • Extracts demographic-based ratings using AI-powered text analysis. • Calculates workplace disparities with statistical measures like z-scores, effect sizes, and p-values. •…