{
  "openruna_format": "flow-graph-v1",
  "title": "Spot Workplace Discrimination Patterns with AI",
  "slug": "spot-workplace-discrimination-patterns-with-ai",
  "source_filename": "1666_Code_Manual_Automation_Webhook.json",
  "nodes": [
    {
      "id": "When clicking ‘Test workflow’",
      "name": "When clicking ‘Test workflow’",
      "integration": "manual",
      "kind": "trigger"
    },
    {
      "id": "OpenAI Chat Model1",
      "name": "OpenAI Chat Model1",
      "integration": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "kind": "action"
    },
    {
      "id": "OpenAI Chat Model2",
      "name": "OpenAI Chat Model2",
      "integration": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "kind": "action"
    },
    {
      "id": "Merge",
      "name": "Merge",
      "integration": "merge",
      "kind": "logic"
    },
    {
      "id": "OpenAI Chat Model",
      "name": "OpenAI Chat Model",
      "integration": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "kind": "action"
    },
    {
      "id": "SET company_name",
      "name": "SET company_name",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Define dictionary of demographic keys",
      "name": "Define dictionary of demographic keys",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "ScrapingBee Search Glassdoor",
      "name": "ScrapingBee Search Glassdoor",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Extract company url path",
      "name": "Extract company url path",
      "integration": "html",
      "kind": "action"
    },
    {
      "id": "ScrapingBee GET company page contents",
      "name": "ScrapingBee GET company page contents",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Extract reviews page url path",
      "name": "Extract reviews page url path",
      "integration": "html",
      "kind": "action"
    },
    {
      "id": "ScrapingBee GET Glassdoor Reviews Content",
      "name": "ScrapingBee GET Glassdoor Reviews Content",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Extract Overall Review Summary",
      "name": "Extract Overall Review Summary",
      "integration": "html",
      "kind": "action"
    },
    {
      "id": "Extract Demographics Module",
      "name": "Extract Demographics Module",
      "integration": "html",
      "kind": "action"
    },
    {
      "id": "Extract overall ratings and distribution percentages",
      "name": "Extract overall ratings and distribution percentages",
      "integration": "@n8n/n8n-nodes-langchain.informationExtractor",
      "kind": "action"
    },
    {
      "id": "Extract demographic distributions",
      "name": "Extract demographic distributions",
      "integration": "@n8n/n8n-nodes-langchain.informationExtractor",
      "kind": "action"
    },
    {
      "id": "Define contributions to variance",
      "name": "Define contributions to variance",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Set variance and std_dev",
      "name": "Set variance and std_dev",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Calculate P-Scores",
      "name": "Calculate P-Scores",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Sort Effect Sizes",
      "name": "Sort Effect Sizes",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Calculate Z-Scores and Effect Sizes",
      "name": "Calculate Z-Scores and Effect Sizes",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Format dataset for scatterplot",
      "name": "Format dataset for scatterplot",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Specify additional parameters for scatterplot",
      "name": "Specify additional parameters for scatterplot",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Quickchart Scatterplot",
      "name": "Quickchart Scatterplot",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "QuickChart Bar Chart",
      "name": "QuickChart Bar Chart",
      "integration": "quickChart",
      "kind": "action"
    },
    {
      "id": "Text Analysis of Bias Data",
      "name": "Text Analysis of Bias Data",
      "integration": "@n8n/n8n-nodes-langchain.chainLlm",
      "kind": "action"
    }
  ],
  "edges": [
    {
      "from": "Merge",
      "to": "Calculate Z-Scores and Effect Sizes"
    },
    {
      "from": "SET company_name",
      "to": "Define dictionary of demographic keys"
    },
    {
      "from": "Sort Effect Sizes",
      "to": "QuickChart Bar Chart"
    },
    {
      "from": "Sort Effect Sizes",
      "to": "Text Analysis of Bias Data"
    },
    {
      "from": "Calculate P-Scores",
      "to": "Sort Effect Sizes"
    },
    {
      "from": "Extract company url path",
      "to": "ScrapingBee GET company page contents"
    },
    {
      "from": "Set variance and std_dev",
      "to": "Merge"
    },
    {
      "from": "Extract Demographics Module",
      "to": "Extract demographic distributions"
    },
    {
      "from": "ScrapingBee Search Glassdoor",
      "to": "Extract company url path"
    },
    {
      "from": "Extract reviews page url path",
      "to": "ScrapingBee GET Glassdoor Reviews Content"
    },
    {
      "from": "Extract Overall Review Summary",
      "to": "Extract overall ratings and distribution percentages"
    },
    {
      "from": "Format dataset for scatterplot",
      "to": "Specify additional parameters for scatterplot"
    },
    {
      "from": "Define contributions to variance",
      "to": "Set variance and std_dev"
    },
    {
      "from": "Extract demographic distributions",
      "to": "Merge"
    },
    {
      "from": "When clicking ‘Test workflow’",
      "to": "SET company_name"
    },
    {
      "from": "Calculate Z-Scores and Effect Sizes",
      "to": "Calculate P-Scores"
    },
    {
      "from": "Calculate Z-Scores and Effect Sizes",
      "to": "Format dataset for scatterplot"
    },
    {
      "from": "Define dictionary of demographic keys",
      "to": "ScrapingBee Search Glassdoor"
    },
    {
      "from": "ScrapingBee GET company page contents",
      "to": "Extract reviews page url path"
    },
    {
      "from": "ScrapingBee GET Glassdoor Reviews Content",
      "to": "Extract Demographics Module"
    },
    {
      "from": "ScrapingBee GET Glassdoor Reviews Content",
      "to": "Extract Overall Review Summary"
    },
    {
      "from": "Specify additional parameters for scatterplot",
      "to": "Quickchart Scatterplot"
    },
    {
      "from": "Extract overall ratings and distribution percentages",
      "to": "Define contributions to variance"
    }
  ]
}