使用 AI 识别职场歧视模式
高级
这是一个HR, AI领域的自动化工作流，包含 38 个节点。主要使用 Set, Code, Html, Merge, QuickChart 等节点，结合人工智能技术实现智能自动化。 利用 AI 识别职场歧视模式
前置要求
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
使用的节点 (38)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "vzU9QRZsHcyRsord",
"meta": {
"instanceId": "a9f3b18652ddc96459b459de4fa8fa33252fb820a9e5a1593074f3580352864a",
"templateCredsSetupCompleted": true
},
"name": "使用 AI 识别职场歧视模式",
"tags": [
{
"id": "76EYz9X3GU4PtgSS",
"name": "human_resources",
"createdAt": "2025-01-30T18:52:17.614Z",
"updatedAt": "2025-01-30T18:52:17.614Z"
},
{
"id": "ey2Mx4vNaV8cKvao",
"name": "openai",
"createdAt": "2024-12-23T07:10:13.400Z",
"updatedAt": "2024-12-23T07:10:13.400Z"
}
],
"nodes": [
{
"id": "b508ab50-158a-4cbf-a52e-f53e1804e770",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
280,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "11a1a2d5-a274-44f7-97ca-5666a59fcb31",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2220,
800
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "XXXXXX",
"name": "OpenAi account"
}
},
"typeVersion": 1
},
{
"id": "395f7b67-c914-4aae-8727-0573fdbfc6ad",
"name": "OpenAI 聊天模型2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2220,
380
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "XXXXXX",
"name": "OpenAi account"
}
},
"typeVersion": 1
},
{
"id": "6ab194a9-b869-4296-aea9-19afcbffc0d7",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
2940,
600
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3
},
{
"id": "1eba1dd7-a164-4c70-8c75-759532bd16a0",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
3840,
420
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "XXXXXX",
"name": "OpenAi account"
}
},
"typeVersion": 1
},
{
"id": "f25f1b07-cded-4ca7-9655-8b8f463089ab",
"name": "设置公司名称",
"type": "n8n-nodes-base.set",
"position": [
540,
380
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "dd256ef7-013c-4769-8580-02c2d902d0b2",
"name": "company_name",
"type": "string",
"value": "=Twilio"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "87264a93-ab97-4e39-8d40-43365189f704",
"name": "定义人口统计键字典",
"type": "n8n-nodes-base.set",
"position": [
740,
380
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "6ae671be-45d0-4a94-a443-2f1d4772d31b",
"name": "asian",
"type": "string",
"value": "Asian"
},
{
"id": "6c93370c-996c-44a6-a34c-4cd3baeeb846",
"name": "hispanic",
"type": "string",
"value": "Hispanic or Latinx"
},
{
"id": "dee79039-6051-4e9d-98b5-63a07d30f6b0",
"name": "white",
"type": "string",
"value": "White"
},
{
"id": "08d42380-8397-412f-8459-7553e9309b5d",
"name": "pacific_islander",
"type": "string",
"value": "Native Hawaiian or other Pacific Islander"
},
{
"id": "09e8ebc5-e7e7-449a-9036-9b9b54cdc828",
"name": "black",
"type": "string",
"value": "Black or African American"
},
{
"id": "39e910f8-3a8b-4233-a93a-3c5693e808c6",
"name": "middle_eastern",
"type": "string",
"value": "Middle Eastern"
},
{
"id": "169b3471-efa0-476e-aa83-e3f717c568f1",
"name": "indigenous",
"type": "string",
"value": "Indigenous American or Native Alaskan"
},
{
"id": "b6192296-4efa-4af5-ae02-1e31d28aae90",
"name": "male",
"type": "string",
"value": "Men"
},
{
"id": "4b322294-940c-459d-b083-8e91e38193f7",
"name": "female",
"type": "string",
"value": "Women"
},
{
"id": "1940eef0-6b76-4a26-9d8f-7c8536fbcb1b",
"name": "trans",
"type": "string",
"value": "Transgender and/or Non-Binary"
},
{
"id": "3dba3e18-2bb1-4078-bde9-9d187f9628dd",
"name": "hetero",
"type": "string",
"value": "Heterosexual"
},
{
"id": "9b7d10ad-1766-4b18-a230-3bd80142b48c",
"name": "lgbtqia",
"type": "string",
"value": "LGBTQ+"
},
{
"id": "458636f8-99e8-4245-9950-94e4cf68e371",
"name": "nondisabled",
"type": "string",
"value": "Non-Disabled"
},
{
"id": "a466e258-7de1-4453-a126-55f780094236",
"name": "disabled",
"type": "string",
"value": "People with Disabilities"
},
{
"id": "98735266-0451-432f-be7c-efcb09512cb1",
"name": "caregiver",
"type": "string",
"value": "Caregivers"
},
{
"id": "ebe2353c-9ff5-47bc-8c11-b66d3436f5b4",
"name": "parent",
"type": "string",
"value": "Parents/Guardians"
},
{
"id": "ab51c80c-d81d-41ab-94d9-c0a263743c17",
"name": "nonparent",
"type": "string",
"value": "Not a Parent or Caregiver"
},
{
"id": "cb7df429-c600-43f4-aa7e-dbc2382a85a0",
"name": "nonveteran",
"type": "string",
"value": "Non-Veterans"
},
{
"id": "dffbdb13-189a-462d-83d1-c5ec39a17d41",
"name": "veteran",
"type": "string",
"value": "Veterans"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "862f1c77-44a8-4d79-abac-33351ebb731b",
"name": "ScrapingBee 搜索 Glassdoor",
"type": "n8n-nodes-base.httpRequest",
"position": [
940,
380
],
"parameters": {
"url": "https://app.scrapingbee.com/api/v1",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth",
"queryParameters": {
"parameters": [
{
"name": "url",
"value": "=https://www.glassdoor.com/Search/results.htm?keyword={{ $json.company_name.toLowerCase().urlEncode() }}"
},
{
"name": "premium_proxy",
"value": "true"
},
{
"name": "block_resources",
"value": "false"
},
{
"name": "stealth_proxy",
"value": "true"
}
]
}
},
"credentials": {
"httpQueryAuth": {
"id": "XXXXXX",
"name": "ScrapingBee Query Auth"
}
},
"typeVersion": 4.2
},
{
"id": "4c9bf05e-9c50-4895-b20b-b7c329104615",
"name": "提取公司 URL 路径",
"type": "n8n-nodes-base.html",
"position": [
1140,
380
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "url_path",
"attribute": "href",
"cssSelector": "body main div a",
"returnValue": "attribute"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "d20bb0e7-4ca7-41d0-a3e9-41abc811b064",
"name": "ScrapingBee 获取公司页面内容",
"type": "n8n-nodes-base.httpRequest",
"position": [
1340,
380
],
"parameters": {
"url": "https://app.scrapingbee.com/api/v1",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth",
"queryParameters": {
"parameters": [
{
"name": "url",
"value": "=https://www.glassdoor.com{{ $json.url_path }}"
},
{
"name": "premium_proxy",
"value": "true"
},
{
"name": "block_resources",
"value": "false"
},
{
"name": "stealth_proxy",
"value": "true"
}
]
}
},
"credentials": {
"httpQueryAuth": {
"id": "XXXXXX",
"name": "ScrapingBee Query Auth"
}
},
"typeVersion": 4.2
},
{
"id": "fce70cab-8ce3-4ce2-b040-ce80d66b1e62",
"name": "提取评论页面 URL 路径",
"type": "n8n-nodes-base.html",
"position": [
1540,
380
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "url_path",
"attribute": "href",
"cssSelector": "#reviews a",
"returnValue": "attribute"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "d2e7fee9-e3d4-42bf-8be6-38b352371273",
"name": "ScrapingBee 获取 Glassdoor 评论内容",
"type": "n8n-nodes-base.httpRequest",
"position": [
1760,
380
],
"parameters": {
"url": "https://app.scrapingbee.com/api/v1",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth",
"queryParameters": {
"parameters": [
{
"name": "url",
"value": "=https://www.glassdoor.com{{ $json.url_path }}"
},
{
"name": "premium_proxy",
"value": "True"
},
{
"name": "block_resources",
"value": "False"
},
{
"name": "stealth_proxy",
"value": "true"
}
]
}
},
"credentials": {
"httpQueryAuth": {
"id": "XXXXXX",
"name": "ScrapingBee Query Auth"
}
},
"typeVersion": 4.2
},
{
"id": "0c322823-0569-4bd5-9c4e-af3de0f8d7b4",
"name": "提取总体评论摘要",
"type": "n8n-nodes-base.html",
"position": [
1980,
260
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "review_summary",
"cssSelector": "div[data-test=\"review-summary\"]",
"returnValue": "html"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "851305ba-0837-4be9-943d-7282e8d74aee",
"name": "提取人口统计模块",
"type": "n8n-nodes-base.html",
"position": [
1980,
520
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "demographics_content",
"cssSelector": "div[data-test=\"demographics-module\"]",
"returnValue": "html"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "cf9a6ee2-53b5-4fbf-a36c-4b9dab53b795",
"name": "提取总体评分和分布百分比",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
2200,
200
],
"parameters": {
"text": "={{ $json.review_summary }}",
"options": {},
"attributes": {
"attributes": [
{
"name": "average_rating",
"type": "number",
"required": true,
"description": "The overall average rating for this company."
},
{
"name": "total_number_of_reviews",
"type": "number",
"required": true,
"description": "The total number of reviews for this company."
},
{
"name": "5_star_distribution_percentage",
"type": "number",
"required": true,
"description": "The percentage distribution of 5 star reviews"
},
{
"name": "4_star_distribution_percentage",
"type": "number",
"required": true,
"description": "The percentage distribution of 4 star reviews"
},
{
"name": "3_star_distribution_percentage",
"type": "number",
"required": true,
"description": "The percentage distribution of 3 star reviews"
},
{
"name": "2_star_distribution_percentage",
"type": "number",
"required": true,
"description": "The percentage distribution of 2 star reviews"
},
{
"name": "1_star_distribution_percentage",
"type": "number",
"required": true,
"description": "The percentage distribution of 1 star reviews"
}
]
}
},
"typeVersion": 1
},
{
"id": "ae164f6e-04e7-4d8b-951e-a17085956f4b",
"name": "提取人口统计分布",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
2200,
620
],
"parameters": {
"text": "={{ $json.demographics_content }}",
"options": {
"systemPromptTemplate": "You are an expert extraction algorithm.\nOnly extract relevant information from the text.\nIf you do not know the value of an attribute asked to extract, you may use 0 for the attribute's value."
},
"attributes": {
"attributes": [
{
"name": "asian_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as asian."
},
{
"name": "asian_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as asian."
},
{
"name": "hispanic_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as hispanic."
},
{
"name": "hispanic_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as hispanic."
},
{
"name": "white_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as white."
},
{
"name": "white_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as white."
},
{
"name": "pacific_islander_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as native hawaiian or pacific islander."
},
{
"name": "pacific_islander_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as native hawaiian or pacific islander."
},
{
"name": "black_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as black."
},
{
"name": "black_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as black."
},
{
"name": "middle_eastern_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as middle eastern."
},
{
"name": "middle_eastern_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as middle_eastern."
},
{
"name": "indigenous_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as indigenous american or native alaskan."
},
{
"name": "indigenous_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as indigenous american or native alaskan."
},
{
"name": "male_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as men."
},
{
"name": "male_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as men."
},
{
"name": "female_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as women."
},
{
"name": "female_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as women."
},
{
"name": "trans_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as transgender and/or non-binary."
},
{
"name": "trans_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as trans and/or non-binary."
},
{
"name": "hetero_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as heterosexual."
},
{
"name": "hetero_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as heterosexual."
},
{
"name": "lgbtqia_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as lgbtqia+."
},
{
"name": "lgbtqia_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as lgbtqia+."
},
{
"name": "nondisabled_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as non-disabled."
},
{
"name": "nondisabled_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as non-disabled."
},
{
"name": "disabled_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as people with disabilities."
},
{
"name": "disabled_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as people with disabilities."
},
{
"name": "caregiver_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as caregivers."
},
{
"name": "caregiver_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as caregivers."
},
{
"name": "parent_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as parents/guardians."
},
{
"name": "parent_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as parents/guardians."
},
{
"name": "nonparent_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as not a parent or caregiver."
},
{
"name": "nonparent_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as not a parent or guardian."
},
{
"name": "nonveteran_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as non-veterans."
},
{
"name": "nonveteran_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as non-veterans."
},
{
"name": "veteran_average_rating",
"type": "number",
"required": true,
"description": "=The average rating for this company by employees who self identified as veterans."
},
{
"name": "veteran_total_number_of_reviews",
"type": "number",
"required": true,
"description": "=The number of reviews for this company by employees who self-identified as veterans."
}
]
}
},
"typeVersion": 1
},
{
"id": "c8d9e45c-7d41-47bd-b9a9-0fa70de5d154",
"name": "定义方差贡献",
"type": "n8n-nodes-base.set",
"position": [
2560,
200
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7360b2c2-1e21-45de-8d1a-e72b8abcb56b",
"name": "contribution_to_variance.5_star",
"type": "number",
"value": "={{ ($json.output['5_star_distribution_percentage'] / 100) * Math.pow(5 - $json.output.average_rating,2) }}"
},
{
"id": "acdd308a-fa33-4e33-b71b-36b9441bfa06",
"name": "contribution_to_variance.4_star",
"type": "number",
"value": "={{ ($json.output['4_star_distribution_percentage'] / 100) * Math.pow(4 - $json.output.average_rating,2) }}"
},
{
"id": "376818f3-d429-4abe-8ece-e8e9c5585826",
"name": "contribution_to_variance.3_star",
"type": "number",
"value": "={{ ($json.output['3_star_distribution_percentage'] / 100) * Math.pow(3 - $json.output.average_rating,2) }}"
},
{
"id": "620d5c37-8b93-4d39-9963-b7ce3a7f431e",
"name": "contribution_to_variance.2_star",
"type": "number",
"value": "={{ ($json.output['2_star_distribution_percentage'] / 100) * Math.pow(2 - $json.output.average_rating,2) }}"
},
{
"id": "76357980-4f9b-4b14-be68-6498ba25af67",
"name": "contribution_to_variance.1_star",
"type": "number",
"value": "={{ ($json.output['1_star_distribution_percentage'] / 100) * Math.pow(1 - $json.output.average_rating,2) }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "8ea03017-d5d6-46ef-a5f1-dae4372f6256",
"name": "设置方差和标准差",
"type": "n8n-nodes-base.set",
"position": [
2740,
200
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3217d418-f1b0-45ff-9f9a-6e6145cc29ca",
"name": "variance",
"type": "number",
"value": "={{ $json.contribution_to_variance.values().sum() }}"
},
{
"id": "acdb9fea-15ec-46ed-bde9-073e93597f17",
"name": "average_rating",
"type": "number",
"value": "={{ $('Extract overall ratings and distribution percentages').item.json.output.average_rating }}"
},
{
"id": "1f3a8a29-4bd4-4b40-8694-c74a0285eadb",
"name": "total_number_of_reviews",
"type": "number",
"value": "={{ $('Extract overall ratings and distribution percentages').item.json.output.total_number_of_reviews }}"
},
{
"id": "1906c796-1964-446b-8b56-d856269da938",
"name": "std_dev",
"type": "number",
"value": "={{ Math.sqrt($json.contribution_to_variance.values().sum()) }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0570d531-8480-4446-8f02-18640b4b891e",
"name": "计算 P 值",
"type": "n8n-nodes-base.code",
"position": [
3340,
440
],
"parameters": {
"jsCode": "// Approximate CDF for standard normal distribution\nfunction normSDist(z) {\n const t = 1 / (1 + 0.3275911 * Math.abs(z));\n const d = 0.254829592 * t - 0.284496736 * t * t + 1.421413741 * t * t * t - 1.453152027 * t * t * t * t + 1.061405429 * t * t * t * t * t;\n return 0.5 * (1 + Math.sign(z) * d * Math.exp(-z * z / 2));\n}\n\nfor (const item of $input.all()) {\n if (!item.json.population_analysis.p_scores) {\n item.json.population_analysis.p_scores = {};\n }\n\n for (const score of Object.keys(item.json.population_analysis.z_scores)) {\n // Check if review count exists and is greater than zero\n if (item.json.population_analysis.review_count[score] > 0) {\n // Apply the p_score formula: 2 * NORM.S.DIST(-ABS(z_score))\n const p_score = 2 * normSDist(-Math.abs(item.json.population_analysis.z_scores[score]));\n\n // Store the calculated p_score\n item.json.population_analysis.p_scores[score] = p_score;\n } else {\n // Remove z_scores, effect_sizes, and p_scores for groups with no reviews\n delete item.json.population_analysis.z_scores[score];\n delete item.json.population_analysis.effect_sizes[score];\n delete item.json.population_analysis.p_scores[score];\n }\n }\n}\n\nreturn $input.all();"
},
"typeVersion": 2
},
{
"id": "0bdb9732-67ef-440d-bdd2-42c4f64ff6b6",
"name": "排序效应大小",
"type": "n8n-nodes-base.set",
"position": [
3540,
440
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "61cf92ba-bc4e-40b8-a234-9b993fd24019",
"name": "population_analysis.effect_sizes",
"type": "object",
"value": "={{ Object.fromEntries(Object.entries($json.population_analysis.effect_sizes).sort(([,a],[,b]) => a-b )) }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "fd9026ef-e993-410a-87d6-40a3ad10b7a7",
"name": "计算 Z 分数和效应大小",
"type": "n8n-nodes-base.set",
"position": [
3140,
600
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "790a53e8-5599-45d3-880e-ab1ad7d165d2",
"name": "population_analysis.z_scores.asian",
"type": "number",
"value": "={{ ($json.output.asian_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.asian_total_number_of_reviews)) }}"
},
{
"id": "ebd61097-8773-45b9-a8e6-cdd840d73650",
"name": "population_analysis.effect_sizes.asian",
"type": "number",
"value": "={{ ($json.output.asian_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "627b1293-efdc-485a-83c8-bd332d6dc225",
"name": "population_analysis.z_scores.hispanic",
"type": "number",
"value": "={{ ($json.output.hispanic_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.hispanic_total_number_of_reviews)) }}"
},
{
"id": "822028d0-e94f-4cf7-9e13-8f8cc5c72ec0",
"name": "population_analysis.z_scores.white",
"type": "number",
"value": "={{ ($json.output.white_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.white_total_number_of_reviews)) }}"
},
{
"id": "d32321f9-0fcf-4e54-9059-c3fd5a901ce0",
"name": "population_analysis.z_scores.pacific_islander",
"type": "number",
"value": "={{ ($json.output.pacific_islander_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.pacific_islander_total_number_of_reviews)) }}"
},
{
"id": "e212d683-247f-45c4-9668-c290230a10ed",
"name": "population_analysis.z_scores.black",
"type": "number",
"value": "={{ ($json.output.black_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.black_total_number_of_reviews)) }}"
},
{
"id": "882049c3-eb81-4c09-af0c-5c79b0ef0154",
"name": "population_analysis.z_scores.middle_eastern",
"type": "number",
"value": "={{ ($json.output.middle_eastern_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.middle_eastern_total_number_of_reviews)) }}"
},
{
"id": "9bdc187f-3d8d-4030-9143-479eff441b7e",
"name": "population_analysis.z_scores.indigenous",
"type": "number",
"value": "={{ ($json.output.indigenous_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.indigenous_total_number_of_reviews)) }}"
},
{
"id": "0cf11453-dbae-4250-a01a-c98e35aab224",
"name": "population_analysis.z_scores.male",
"type": "number",
"value": "={{ ($json.output.male_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.male_total_number_of_reviews)) }}"
},
{
"id": "35a18fbc-7c2c-40fe-829d-2fffbdb13bb8",
"name": "population_analysis.z_scores.female",
"type": "number",
"value": "={{ ($json.output.female_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.female_total_number_of_reviews)) }}"
},
{
"id": "a6e17c1b-a89b-4c05-8184-10f7248c159f",
"name": "population_analysis.z_scores.trans",
"type": "number",
"value": "={{ ($json.output.trans_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.trans_total_number_of_reviews)) }}"
},
{
"id": "5e7dbccf-3011-4dba-863c-5390c1ee9e50",
"name": "population_analysis.z_scores.hetero",
"type": "number",
"value": "={{ ($json.output.hetero_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.hetero_total_number_of_reviews)) }}"
},
{
"id": "1872152f-2c7e-4c24-bcd5-e2777616bfe2",
"name": "population_analysis.z_scores.lgbtqia",
"type": "number",
"value": "={{ ($json.output.lgbtqia_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.lgbtqia_total_number_of_reviews)) }}"
},
{
"id": "91b2cb00-173e-421a-929a-51d2a6654767",
"name": "population_analysis.z_scores.nondisabled",
"type": "number",
"value": "={{ ($json.output.nondisabled_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.nondisabled_total_number_of_reviews)) }}"
},
{
"id": "8bb7429e-0500-482c-8e8d-d2c63733ffe1",
"name": "population_analysis.z_scores.disabled",
"type": "number",
"value": "={{ ($json.output.disabled_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.disabled_total_number_of_reviews)) }}"
},
{
"id": "89f00d0f-80db-4ad9-bf60-9385aa3d915b",
"name": "population_analysis.z_scores.caregiver",
"type": "number",
"value": "={{ ($json.output.caregiver_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.caregiver_total_number_of_reviews)) }}"
},
{
"id": "0bb2b96c-d882-4ac1-9432-9fce06b26cf5",
"name": "population_analysis.z_scores.parent",
"type": "number",
"value": "={{ ($json.output.parent_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.parent_total_number_of_reviews)) }}"
},
{
"id": "9aae7169-1a25-4fab-b940-7f2cd7ef39d9",
"name": "population_analysis.z_scores.nonparent",
"type": "number",
"value": "={{ ($json.output.nonparent_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.nonparent_total_number_of_reviews)) }}"
},
{
"id": "aac189a0-d6fc-4581-a15d-3e75a0cb370a",
"name": "population_analysis.z_scores.nonveteran",
"type": "number",
"value": "={{ ($json.output.nonveteran_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.nonveteran_total_number_of_reviews)) }}"
},
{
"id": "d40f014a-9c1d-4aea-88ac-d8a3de143931",
"name": "population_analysis.z_scores.veteran",
"type": "number",
"value": "={{ ($json.output.veteran_average_rating - $json.average_rating) / ($json.std_dev / Math.sqrt($json.output.veteran_total_number_of_reviews)) }}"
},
{
"id": "67e0394f-6d55-4e80-8a7d-814635620b1d",
"name": "population_analysis.effect_sizes.hispanic",
"type": "number",
"value": "={{ ($json.output.hispanic_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "65cd3a22-2c97-4da1-8fcc-cc1af39118f2",
"name": "population_analysis.effect_sizes.white",
"type": "number",
"value": "={{ ($json.output.white_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "a03bdf0f-e294-4a01-bb08-ddc16e9997a5",
"name": "population_analysis.effect_sizes.pacific_islander",
"type": "number",
"value": "={{ ($json.output.pacific_islander_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "b0bdc40e-ed5f-475b-9d8b-8cf5beff7002",
"name": "population_analysis.effect_sizes.black",
"type": "number",
"value": "={{ ($json.output.black_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "45cac3f0-7270-4fa4-8fc4-94914245a77d",
"name": "population_analysis.effect_sizes.middle_eastern",
"type": "number",
"value": "={{ ($json.output.middle_eastern_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "cf5b7650-8766-45f6-8241-49aea62bf619",
"name": "population_analysis.effect_sizes.indigenous",
"type": "number",
"value": "={{ ($json.output.indigenous_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "7c6a8d38-02b7-47a1-af44-5eebfb4140ec",
"name": "population_analysis.effect_sizes.male",
"type": "number",
"value": "={{ ($json.output.male_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "4bf3dba9-4d07-4315-83ce-5fba288a00c9",
"name": "population_analysis.effect_sizes.female",
"type": "number",
"value": "={{ ($json.output.female_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "d5e980b8-d7a8-4d4c-bcd9-fd9cbd20c729",
"name": "population_analysis.effect_sizes.trans",
"type": "number",
"value": "={{ ($json.output.trans_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "2c8271c1-b612-4292-9d48-92c342b83727",
"name": "population_analysis.effect_sizes.hetero",
"type": "number",
"value": "={{ ($json.output.hetero_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "996f2ea0-2e46-424b-9797-2d58fd56b1d3",
"name": "population_analysis.effect_sizes.lgbtqia",
"type": "number",
"value": "={{ ($json.output.lgbtqia_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "8c987b6e-764d-422e-82de-00bd89269b22",
"name": "population_analysis.effect_sizes.nondisabled",
"type": "number",
"value": "={{ ($json.output.nondisabled_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "ab796bb7-06ff-4282-b4b3-eefd129c743e",
"name": "population_analysis.effect_sizes.disabled",
"type": "number",
"value": "={{ ($json.output.disabled_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "a17bf413-a098-4f24-8162-821a6a0ddb5e",
"name": "population_analysis.effect_sizes.caregiver",
"type": "number",
"value": "={{ ($json.output.caregiver_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "99911e1e-06e8-4bbd-915d-b92b8b37b374",
"name": "population_analysis.effect_sizes.parent",
"type": "number",
"value": "={{ ($json.output.parent_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "4ddf729b-361e-4d81-a67c-b6c18509e60b",
"name": "population_analysis.effect_sizes.nonparent",
"type": "number",
"value": "={{ ($json.output.nonparent_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "725b8abb-7f72-45fc-a0c0-0e0a4f2cb131",
"name": "population_analysis.effect_sizes.nonveteran",
"type": "number",
"value": "={{ ($json.output.nonveteran_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "20e54fa5-2faa-4134-90e5-81224ec9659e",
"name": "population_analysis.effect_sizes.veteran",
"type": "number",
"value": "={{ ($json.output.veteran_average_rating - $json.average_rating) / $json.std_dev }}"
},
{
"id": "2cc6465a-3a1c-4eb5-9e5a-72d41049d81e",
"name": "population_analysis.review_count.asian",
"type": "number",
"value": "={{ $json.output.asian_total_number_of_reviews }}"
},
{
"id": "0a5f6aae-ba21-47b5-8af8-fec2256e4df6",
"name": "population_analysis.review_count.hispanic",
"type": "number",
"value": "={{ $json.output.hispanic_total_number_of_reviews }}"
},
{
"id": "ae124587-7e24-4c1a-a002-ed801f859c30",
"name": "population_analysis.review_count.pacific_islander",
"type": "number",
"value": "={{ $json.output.pacific_islander_total_number_of_reviews }}"
},
{
"id": "fc790196-ca8e-4069-a093-87a413ebbf3e",
"name": "population_analysis.review_count.black",
"type": "number",
"value": "={{ $json.output.black_total_number_of_reviews }}"
},
{
"id": "7fd72701-781e-4e33-b000-174a853b172b",
"name": "population_analysis.review_count.middle_eastern",
"type": "number",
"value": "={{ $json.output.middle_eastern_total_number_of_reviews }}"
},
{
"id": "3751e7da-11a7-4af3-8aa6-1c6d53bcf27d",
"name": "population_analysis.review_count.indigenous",
"type": "number",
"value": "={{ $json.output.indigenous_total_number_of_reviews }}"
},
{
"id": "9ee0cac9-d2dd-4ba0-90ee-b2cdd22d9b77",
"name": "population_analysis.review_count.male",
"type": "number",
"value": "={{ $json.output.male_total_number_of_reviews }}"
},
{
"id": "ae7fcdc7-d373-4c24-9a65-94bd2b5847a8",
"name": "population_analysis.review_count.female",
"type": "number",
"value": "={{ $json.output.female_total_number_of_reviews }}"
},
{
"id": "3f53d065-269f-425a-b27d-dc5a3dbb6141",
"name": "population_analysis.review_count.trans",
"type": "number",
"value": "={{ $json.output.trans_total_number_of_reviews }}"
},
{
"id": "d15e976e-7599-4df0-9e65-8047b7a4cda8",
"name": "population_analysis.review_count.hetero",
"type": "number",
"value": "={{ $json.output.hetero_total_number_of_reviews }}"
},
{
"id": "c8b786d3-a980-469f-bf0e-de70ad44f0ea",
"name": "population_analysis.review_count.lgbtqia",
"type": "number",
"value": "={{ $json.output.lgbtqia_total_number_of_reviews }}"
},
{
"id": "e9429215-0858-4482-964a-75de7978ecbb",
"name": "population_analysis.review_count.nondisabled",
"type": "number",
"value": "={{ $json.output.nondisabled_total_number_of_reviews }}"
},
{
"id": "2c6e53c4-eab1-42aa-b956-ee882832f569",
"name": "population_analysis.review_count.disabled",
"type": "number",
"value": "={{ $json.output.disabled_total_number_of_reviews }}"
},
{
"id": "b5edfa25-ab11-4b94-9670-4d5589a62498",
"name": "population_analysis.review_count.caregiver",
"type": "number",
"value": "={{ $json.output.caregiver_total_number_of_reviews }}"
},
{
"id": "41084e96-c42f-4bb0-ac1a-883b46537fca",
"name": "population_analysis.review_count.parent",
"type": "number",
"value": "={{ $json.output.parent_total_number_of_reviews }}"
},
{
"id": "96496a38-9311-4ade-bd2f-2943d1d92314",
"name": "population_analysis.review_count.nonparent",
"type": "number",
"value": "={{ $json.output.nonparent_total_number_of_reviews }}"
},
{
"id": "5071771d-5f41-43cb-a8ce-e4e40ed3519b",
"name": "population_analysis.review_count.nonveteran",
"type": "number",
"value": "={{ $json.output.nonveteran_total_number_of_reviews }}"
},
{
"id": "2358e782-70da-4964-b625-5fe1946b5250",
"name": "population_analysis.review_count.veteran",
"type": "number",
"value": "={{ $json.output.veteran_total_number_of_reviews }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "85536931-839a-476b-b0dd-fa6d01c6d5c1",
"name": "为散点图格式化数据集",
"type": "n8n-nodes-base.code",
"position": [
3340,
760
],
"parameters": {
"jsCode": "// Iterate through the input data and format the dataset for QuickChart\nfor (const item of $input.all()) {\n // Ensure the data object exists and initialize datasets\n item.json.data = {\n datasets: []\n };\n\n const z_scores = item.json.population_analysis.z_scores;\n const effect_sizes = item.json.population_analysis.effect_sizes;\n const review_count = item.json.population_analysis.review_count;\n\n // Ensure z_scores, effect_sizes, and review_count are defined and are objects\n if (z_scores && effect_sizes && review_count && typeof z_scores === 'object' && typeof effect_sizes === 'object' && typeof review_count === 'object') {\n // Initialize the dataset object\n const dataset = {\n label: 'Demographics Data',\n data: []\n };\n\n // Iterate through the demographic keys\n for (const key in z_scores) {\n // Check if review count for the demographic is greater than 0\n if (z_scores.hasOwnProperty(key) && effect_sizes.hasOwnProperty(key) && review_count[key] > 0) {\n\n // Add each demographic point to the dataset\n dataset.data.push({\n x: z_scores[key], // x = z_score\n y: effect_sizes[key], // y = effect_size\n label: $('Define dictionary of demographic keys').first().json[key],\n });\n }\n }\n\n // Only add the dataset if it contains data\n if (dataset.data.length > 0) {\n item.json.data.datasets.push(dataset);\n }\n\n delete item.json.population_analysis\n }\n}\n\n// Return the updated input with the data object containing datasets and labels\nreturn $input.all();\n"
},
"typeVersion": 2
},
{
"id": "957b9f6c-7cf8-4ec6-aec7-a7d59ed3a4ad",
"name": "为散点图指定额外参数",
"type": "n8n-nodes-base.set",
"position": [
3540,
760
],
"parameters": {
"options": {
"ignoreConversionErrors": false
},
"assignments": {
"assignments": [
{
"id": "5cd507f6-6835-4d2e-8329-1b5d24a3fc15",
"name": "type",
"type": "string",
"value": "scatter"
},
{
"id": "80b6f981-e3c7-4c6e-a0a1-f30d028fe15e",
"name": "options",
"type": "object",
"value": "={\n \"title\": {\n \"display\": true,\n \"position\": \"top\",\n \"fontSize\": 12,\n \"fontFamily\": \"sans-serif\",\n \"fontColor\": \"#666666\",\n \"fontStyle\": \"bold\",\n \"padding\": 10,\n \"lineHeight\": 1.2,\n \"text\": \"{{ $('SET company_name').item.json.company_name }} Workplace Population Bias\"\n },\n \"legend\": {\n \"display\": false\n },\n \"scales\": {\n \"xAxes\": [\n {\n \"scaleLabel\": {\n \"display\": true,\n \"labelString\": \"Z-Score\",\n \"fontColor\": \"#666666\",\n \"fontSize\": 12,\n \"fontFamily\": \"sans-serif\"\n }\n }\n ],\n \"yAxes\": [\n {\n \"scaleLabel\": {\n \"display\": true,\n \"labelString\": \"Effect Score\",\n \"fontColor\": \"#666666\",\n \"fontSize\": 12,\n \"fontFamily\": \"sans-serif\"\n }\n }\n ]\n },\n \"plugins\": {\n \"datalabels\": {\n \"display\": true,\n \"align\": \"top\",\n \"anchor\": \"center\",\n \"backgroundColor\": \"#eee\",\n \"borderColor\": \"#ddd\",\n \"borderRadius\": 6,\n \"borderWidth\": 1,\n \"padding\": 4,\n \"color\": \"#000\",\n \"font\": {\n \"family\": \"sans-serif\",\n \"size\": 10,\n \"style\": \"normal\"\n }\n }\n }\n }"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "a937132c-43fc-4fa0-ae35-885da89e51d1",
"name": "Quickchart 散点图",
"type": "n8n-nodes-base.httpRequest",
"position": [
3740,
760
],
"parameters": {
"url": "https://quickchart.io/chart",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "c",
"value": "={{ $json.toJsonString() }}"
},
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "encoding",
"value": "url"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "ede1931e-bac8-4279-b3a7-5980a190e324",
"name": "QuickChart 条形图",
"type": "n8n-nodes-base.quickChart",
"position": [
3740,
560
],
"parameters": {
"data": "={{ $json.population_analysis.effect_sizes.values() }}",
"output": "bar_chart",
"labelsMode": "array",
"labelsArray": "={{ $json.population_analysis.effect_sizes.keys() }}",
"chartOptions": {
"format": "png"
},
"datasetOptions": {
"label": "={{ $('SET company_name').item.json.company_name }} Effect Size on Employee Experience"
}
},
"typeVersion": 1
},
{
"id": "6122fec0-619c-48d3-ad2c-05ed55ba2275",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
40
],
"parameters": {
"color": 7,
"width": 3741.593083126444,
"height": 1044.8111554136713,
"content": "# 使用 ScrapingBee、Glassdoor、OpenAI 和 QuickChart 识别职场歧视模式"
},
"typeVersion": 1
},
{
"id": "5cda63e8-f31b-46f6-8cb2-41d1856ac537",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
900,
180
],
"parameters": {
"color": 4,
"width": 1237.3377621763516,
"height": 575.9439659309116,
"content": "## 使用 ScrapingBee 从 Glassdoor 收集原始数据"
},
"typeVersion": 1
},
{
"id": "28d247b2-9020-4280-83d2-d6583622c0b7",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
240
],
"parameters": {
"color": 7,
"width": 804.3951263154196,
"height": 125.73173301324687,
"content": "### 由于 JavaScript 限制，无法使用普通 HTTP 请求从 Glassdoor 收集用户报告的详细信息。"
},
"typeVersion": 1
},
{
"id": "d65a239c-06d2-470b-b24a-23ec00a9f148",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2180,
99.69933502879758
],
"parameters": {
"color": 5,
"width": 311.0523273992095,
"height": 843.8786512173932,
"content": "## 使用 AI 提取详细信息"
},
"typeVersion": 1
},
{
"id": "3cffd188-62a1-43a7-a67f-548e21d2b187",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2516.1138215303854,
100
],
"parameters": {
"color": 7,
"width": 423.41585047129973,
"height": 309.71740416262054,
"content": "### 从评论评分分布计算方差和标准差。"
},
"typeVersion": 1
},
{
"id": "b5015c07-03e3-47d4-9469-e831b2c755c0",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3320,
706.46982689582
],
"parameters": {
"color": 5,
"width": 639.5579220386832,
"height": 242.80759628871897,
"content": "## 为散点图格式化数据集"
},
"typeVersion": 1
},
{
"id": "e52bb9d9-617a-46f5-b217-a6f670b6714c",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
120
],
"parameters": {
"width": 356.84794255678776,
"height": 186.36110628732342,
"content": "## 此工作流的工作原理"
},
"typeVersion": 1
},
{
"id": "d83c07a3-04ed-418f-94f1-e70828cba8b2",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
880
],
"parameters": {
"color": 6,
"width": 356.84794255678776,
"height": 181.54335665904924,
"content": "### 灵感来自 [Wes Medford 的 Medium 文章](https://medium.com/@wryanmedford/an-open-letter-to-twilios-leadership-f06f661ecfb4)"
},
"typeVersion": 1
},
{
"id": "ed0c1b4a-99fe-4a27-90bb-ac38dd20810b",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
4020,
880
],
"parameters": {
"color": 7,
"width": 847.5931795867759,
"height": 522.346478008115,
"content": "![image](https://quickchart.io/chart?c=%7B%0A%20%20%22type%22%3A%20%22scatter%22%2C%0A%20%20%22data%22%3A%20%7B%0A%20%20%20%20%22datasets%22%3A%20%5B%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%22label%22%3A%20%22Demographics%20Data%22%2C%0A%20%20%20%20%20%20%20%20%22data%22%3A%20%5B%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%201.1786657494327952%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%200.16190219204909295%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%200.5119796850491362%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%200.0809510960245463%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-0.9300572848378476%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.16190219204909329%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-0.42835293687811976%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.16190219204909329%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-1.0890856121128139%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.08095109602454664%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-1.7362075843299012%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.16190219204909329%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-2.9142394568836774%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.971413152294559%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-1.2088576542791578%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.08095109602454664%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-2.5276971632072494%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.4047554801227329%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%200%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%200%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-5.504674529669168%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-1.376168632417292%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-0.8412684674574105%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.24285328807363996%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-2.896194457023989%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.32380438409818657%0A%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22x%22%3A%20-1.0303392409819254%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22y%22%3A%20-0.08095109602454664%0A%20%20%20%20%20%20%20"
},
"typeVersion": 1
},
{
"id": "7b92edf8-3a58-4931-abf4-d9c2f57cfa32",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
3980,
800
],
"parameters": {
"color": 6,
"width": 989.7621518164046,
"height": 636.6345107975716,
"content": "## Example Scatterplot output"
},
"typeVersion": 1
},
{
"id": "bd6859b4-096c-401e-9bce-91e970e1afd1",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2540,
800
],
"parameters": {
"color": 6,
"width": 737.6316136259719,
"height": 444.9087184962878,
"content": "## Glossary\n**Z-Score** – A statistical measure that indicates how many standard deviations a data point is from the mean. In this analysis, a negative z-score suggests a group rates their workplace experience lower than the average, while a positive z-score suggests a better-than-average experience.\n\n**Effect Size** – A measure of the magnitude of difference between groups. Larger negative effect sizes indicate a more substantial disparity in workplace experiences for certain groups, making it useful for identifying meaningful gaps beyond just statistical significance.\n\n**P-Score (P-Value)** – The probability that the observed differences occurred by chance. A lower p-score (typically below 0.05) suggests the difference is statistically significant and unlikely to be random. In this analysis, high p-scores confirm that the disparities in ratings for marginalized groups are unlikely to be due to chance alone.\n\n### Relevance to This Analysis\nThese metrics help quantify workplace disparities among demographic groups. Z-scores show which groups report better or worse experiences, effect sizes reveal the severity of these differences, and p-scores confirm whether the disparities are statistically meaningful. This data allows for a more informed discussion about workplace equity and areas needing improvement."
},
"typeVersion": 1
},
{
"id": "5af3ef87-ed4b-481e-b1ba-d44ffb7551d8",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
4140,
80
],
"parameters": {
"color": 6,
"width": 643.5995639515581,
"height": 646.0030521944287,
"content": "## Example AI Analysis (Twilio Example)\n\n### Key Takeaways\n1. **Significant Disparity Among Disabled Employees**\nDisabled employees reported the lowest average ratings, with a z-score of -5.50, indicating a far worse experience compared to their non-disabled peers. \n2. **LGBTQIA Community's Challenges**\nMembers of the LGBTQIA community showed significantly lower ratings (z-score of -2.53), suggesting they may experience a workplace environment that is less inclusive or supportive compared to others.\n3. **Transgender Experiences Are Particularly Negative**\nTransgender employees rated their experiences considerably lower (z-score of -2.91), highlighting a critical area for improvement in workplace culture and acceptance.\n4. **Veterans Report Higher Satisfaction**\nIn contrast, veterans had the highest ratings (z-score of 1.54), which could indicate a supportive environment or programs tailored to their needs.\n5. **Overall Gender Discrepancies**\nA noticeable gap exists in average ratings by gender, with female employees scoring below male employees, suggesting potential gender biases or challenges in workplace dynamics.\n\n### Employee Experiences\n#### Perceptions of Workplace Environment\nFor members of groups reporting significantly worse experiences, such as disabled, transgender, and LGBTQIA employees, the workplace may feel alienating or unwelcoming. These individuals might perceive that their contributions are undervalued or overlooked and that necessary support systems are lacking, creating a culture of exclusion rather than one of inclusivity. This feeling of being marginalized can lead to poorer engagement, higher turnover rates, and diminished overall job satisfaction, adversely impacting both employees and the organization."
},
"typeVersion": 1
},
{
"id": "a39cdbe7-d6ae-4a84-98c7-52ebf98242f3",
"name": "Text Analysis of Bias Data",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
3720,
280
],
"parameters": {
"text": "=This data compares the average rating given by different demographic groups against a baseline (the overall mean rating).\n\nObjective:\n1. Analyze the data and offer between 2 and 5 key takeaways with a title and short (one-sentence) summary.\n2. Below the key takeaways, Include a heading called \"Employee Experiences\". Under this heading, include a subheader and paragraph describing the possible perception of the workplace for members of any groups reporting significantly worse (or better) experiences than others.\n3. Ensure there are between 2-5 key takeaways and employee experiences\n\nData for analysis:\n{{ $json.population_analysis.toJsonString() }}",
"promptType": "define"
},
"typeVersion": 1.4
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ff1df786-ebaf-4ed0-aeca-1872b93ef275",
"connections": {
"Merge": {
"main": [
[
{
"node": "Calculate Z-Scores and Effect Sizes",
"type": "main",
"index": 0
}
]
]
},
"SET company_name": {
"main": [
[
{
"node": "Define dictionary of demographic keys",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Text Analysis of Bias Data",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Sort Effect Sizes": {
"main": [
[
{
"node": "QuickChart Bar Chart",
"type": "main",
"index": 0
},
{
"node": "Text Analysis of Bias Data",
"type": "main",
"index": 0
}
]
]
},
"Calculate P-Scores": {
"main": [
[
{
"node": "Sort Effect Sizes",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Extract demographic distributions",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model2": {
"ai_languageModel": [
[
{
"node": "Extract overall ratings and distribution percentages",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Extract company url path": {
"main": [
[
{
"node": "ScrapingBee GET company page contents",
"type": "main",
"index": 0
}
]
]
},
"Set variance and std_dev": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Extract Demographics Module": {
"main": [
[
{
"node": "Extract demographic distributions",
"type": "main",
"index": 0
}
]
]
},
"ScrapingBee Search Glassdoor": {
"main": [
[
{
"node": "Extract company url path",
"type": "main",
"index": 0
}
]
]
},
"Extract reviews page url path": {
"main": [
[
{
"node": "ScrapingBee GET Glassdoor Reviews Content",
"type": "main",
"index": 0
}
]
]
},
"Extract Overall Review Summary": {
"main": [
[
{
"node": "Extract overall ratings and distribution percentages",
"type": "main",
"index": 0
}
]
]
},
"Format dataset for scatterplot": {
"main": [
[
{
"node": "Specify additional parameters for scatterplot",
"type": "main",
"index": 0
}
]
]
},
"Define contributions to variance": {
"main": [
[
{
"node": "Set variance and std_dev",
"type": "main",
"index": 0
}
]
]
},
"Extract demographic distributions": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "SET company_name",
"type": "main",
"index": 0
}
]
]
},
"Calculate Z-Scores and Effect Sizes": {
"main": [
[
{
"node": "Calculate P-Scores",
"type": "main",
"index": 0
},
{
"node": "Format dataset for scatterplot",
"type": "main",
"index": 0
}
]
]
},
"Define dictionary of demographic keys": {
"main": [
[
{
"node": "ScrapingBee Search Glassdoor",
"type": "main",
"index": 0
}
]
]
},
"ScrapingBee GET company page contents": {
"main": [
[
{
"node": "Extract reviews page url path",
"type": "main",
"index": 0
}
]
]
},
"ScrapingBee GET Glassdoor Reviews Content": {
"main": [
[
{
"node": "Extract Demographics Module",
"type": "main",
"index": 0
},
{
"node": "Extract Overall Review Summary",
"type": "main",
"index": 0
}
]
]
},
"Specify additional parameters for scatterplot": {
"main": [
[
{
"node": "Quickchart Scatterplot",
"type": "main",
"index": 0
}
]
]
},
"Extract overall ratings and distribution percentages": {
"main": [
[
{
"node": "Define contributions to variance",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人力资源, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
BambooHR AI 驱动的公司政策和福利聊天机器人
BambooHR AI 驱动的公司政策和福利聊天机器人
Set
Filter
Bamboo Hr
+20
50 节点Ludwig
人力资源
在不更改WEBHOOK_URL的情况下测试n8n中的Webhooks（PostBin和BambooHR示例）
在不更改WEBHOOK_URL的情况下测试n8n中的Webhooks（PostBin和BambooHR示例）
Set
Wait
Merge
+16
58 节点Ludwig
人力资源
使用AI自动化品牌风格博客创建
使用AI自动化品牌风格博客创建
Set
Html
Limit
+11
27 节点Jimleuk
人工智能
使用Bright Data和OpenAI的TrustPilot SaaS产品评论追踪器
使用Bright Data和OpenAI的TrustPilot SaaS产品评论追踪器
Set
Code
Merge
+11
22 节点Ranjan Dailata
产品
使用AI自动为WordPress博客文章添加标签
使用AI自动为WordPress博客文章添加标签
If
Set
Code
+14
32 节点Ludwig
人工智能
使用GPT-4.1、Outlook和Mem.ai自动化Microsoft Teams会议分析
使用GPT-4.1、Outlook和Mem.ai自动化Microsoft Teams会议分析
If
Set
Code
+19
61 节点Wayne Simpson
人力资源
工作流信息
难度等级
高级
节点数量38
分类2
节点类型11
作者
Ludwig
@ludwigIf you have any questions about any of the templates I've built, please reach out to me on LinkedIn (https://www.linkedin.com/in/ludwiggerdes) or via my website down below. 👇
外部链接
在 n8n.io 查看 →
分享此工作流