使用 Bright Data 和 GPT 抓取 Glassdoor 发现高意向销售线索
高级
这是一个Sales, AI, Marketing领域的自动化工作流，包含 16 个节点。主要使用 If, Wait, SplitOut, FormTrigger, HttpRequest 等节点，结合人工智能技术实现智能自动化。 通过 Bright Data 和 GPT 抓取 Glassdoor 发现高意向销售线索
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "1eadd5bc7c3d70c587c28f782511fd898c6bf6d97963d92e836019d2039d1c79"
},
"nodes": [
{
"id": "e936b195-744d-4c0b-a1ee-d9123190c0cd",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
-160
],
"parameters": {
"color": 4,
"width": 1280,
"height": 460,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "60db8b95-e1c8-464d-a214-599e963db599",
"name": "快照进度",
"type": "n8n-nodes-base.httpRequest",
"position": [
2080,
260
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/progress/{{ $('HTTP Request- Post API call to Bright Data').item.json.snapshot_id }}",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer <YOUR_BRIGHT_DATA_API_KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "d7b8a05a-0545-4c7e-ba4a-077325d7061c",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
3140,
40
],
"parameters": {
"width": 195,
"height": 646,
"content": "在此工作流中，我使用 Google Sheets 存储结果。"
},
"typeVersion": 1
},
{
"id": "92c5471e-8980-4328-ae88-2f5798d9e010",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
780,
-160
],
"parameters": {
"width": 480,
"height": 880,
"content": "🔍 Glassdoor 职位抓取器 - 参数指南"
},
"typeVersion": 1
},
{
"id": "9c33f4ab-e235-4118-91e6-be8f9b02a7ce",
"name": "表单提交时 - 发现职位",
"type": "n8n-nodes-base.formTrigger",
"position": [
1160,
480
],
"webhookId": "8d0269c7-d1fc-45a1-a411-19634a1e0b82",
"parameters": {
"options": {},
"formTitle": "Linkedin High Intent Prospects And Job Post Hunt",
"formFields": {
"values": [
{
"fieldLabel": "Job Location",
"placeholder": "example: new york",
"requiredField": true
},
{
"fieldLabel": "Keyword",
"placeholder": "example: CMO, AI architect",
"requiredField": true
},
{
"fieldLabel": "Country (2 letters)",
"placeholder": "example: US,UK,IL",
"requiredField": true
}
]
},
"formDescription": "This form lets you customize your job search / prospecting by choosing:\n\nLocation (city or region)\n\nJob title or keywords\n\nCountry code\n"
},
"typeVersion": 2.2
},
{
"id": "64644514-8b80-4b6d-ad03-3c1e3910bcbc",
"name": "HTTP 请求 - 向 Bright Data 发送 API POST 调用",
"type": "n8n-nodes-base.httpRequest",
"position": [
1500,
520
],
"parameters": {
"url": "https://api.brightdata.com/datasets/v3/trigger",
"method": "POST",
"options": {},
"jsonBody": "=[\n {\n \"location\": \"{{ $json['Job Location'] }}\",\n \"keyword\": \"{{ $json.Keyword }}\",\n \"country\": \"{{ $json['Country (2 letters)'] }}\"\n }\n] ",
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "dataset_id",
"value": "gd_lpfbbndm1xnopbrcr0"
},
{
"name": "include_errors",
"value": "true"
},
{
"name": "type",
"value": "discover_new"
},
{
"name": "discover_by",
"value": "keyword"
},
{
"name": "uncompressed_webhook",
"value": "true"
},
{
"name": "type",
"value": "discover_new"
},
{
"name": "discover_by",
"value": "=keyword"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer <YOUR_BRIGHT_DATA_API_KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "a3ecdf16-4e39-43d6-8409-5dec26fc2b37",
"name": "等待 - 轮询 Bright Data",
"type": "n8n-nodes-base.wait",
"position": [
1840,
260
],
"webhookId": "8005a2b3-2195-479e-badb-d90e4240e699",
"parameters": {
"unit": "minutes"
},
"executeOnce": false,
"typeVersion": 1.1
},
{
"id": "27e70649-72e6-4241-9568-a11c8a7de93d",
"name": "If - 检查快照状态 - 数据是否就绪",
"type": "n8n-nodes-base.if",
"position": [
2280,
260
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7932282b-71bb-4bbb-ab73-4978e554de7e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "running"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "8e264a0c-b326-4bec-af4e-433cd1ed77c2",
"name": "HTTP 请求 - 从 Bright Data 获取数据",
"type": "n8n-nodes-base.httpRequest",
"position": [
2560,
280
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/snapshot/{{ $('HTTP Request- Post API call to Bright Data').item.json.snapshot_id }}",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "format",
"value": "json"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer <YOUR_BRIGHT_DATA_API_KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "c29a06db-00bf-4d6b-bbf1-c0716ba8f7ce",
"name": "Google Sheets - 添加所有职位发布",
"type": "n8n-nodes-base.googleSheets",
"position": [
3180,
340
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_url_overview",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_url_overview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_overview",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_overview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_headquarters",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_headquarters",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_revenue",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_revenue",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_sector",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_sector",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "percentage_that_recommend_company_to_a friend",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "percentage_that_recommend_company_to_a friend",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "percentage_that_approve_of_ceo",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "percentage_that_approve_of_ceo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_ceo",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_ceo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_career_opportunities_rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_career_opportunities_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_comp_and_benefits_rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_comp_and_benefits_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_culture_and_values_rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_culture_and_values_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_senior_management_rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_senior_management_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_work/life_balance_rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_work/life_balance_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_by_same_job_pros",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "reviews_by_same_job_pros",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_by_same_job_cons",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "reviews_by_same_job_cons",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_benefits_rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_benefits_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_benefits_employer_summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_benefits_employer_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "employee_benefit_reviews",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "employee_benefit_reviews",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_posting_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_posting_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_application_link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_application_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_website",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_range_glassdoor_est",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pay_range_glassdoor_est",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_median_glassdoor",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pay_median_glassdoor",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_range_employer_est__DUPLICATE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pay_range_employer_est__DUPLICATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_median_employer",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pay_median_employer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_range_currency",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pay_range_currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pay_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "discovery_input",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "discovery_input",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"handlingExtraData": "insertInNewColumn"
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4/edit#gid=0",
"cachedResultName": "input"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1ZYRk83hNIQCyQNaKpchdnbTiapVxE4aG6ZFIQlwEoWM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ZYRk83hNIQCyQNaKpchdnbTiapVxE4aG6ZFIQlwEoWM/edit?usp=drivesdk",
"cachedResultName": "NoFluff-N8N-Sheet-Template- GlassdoorJob Scraping WIth Bright Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "4RJOMlGAcB9ZoYfm",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.3,
"alwaysOutputData": true
},
{
"id": "cffc101d-cf3f-46c8-a2e0-9989fa2ec0fe",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1400,
100
],
"parameters": {
"width": 300,
"height": 880,
"content": "🧠 Bright Data 触发器 - 自定义您的职位查询"
},
"typeVersion": 1
},
{
"id": "e74213c5-dafe-4c7a-a8fc-4014b94e434b",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1780,
120
],
"parameters": {
"color": 4,
"width": 940,
"height": 360,
"content": "Bright Data 获取职位"
},
"typeVersion": 1
},
{
"id": "a01857bf-ef31-4972-940e-e3bac2c5fe40",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
3400,
320
],
"parameters": {
"options": {},
"fieldToSplitOut": "company_name, job_title, description_text"
},
"typeVersion": 1
},
{
"id": "855217f7-f790-413e-a767-68dd204fe0b4",
"name": "基础 LLM 链",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
3620,
320
],
"parameters": {
"text": "=Read these fields from the job post:\n- Company: `{{ $json.company_name }}`\n- Title: `{{ $json.job_title }}`\n- Description: `{{ $('Google Sheets - Adding All Job Posts').item.json.job_overview }}`\n\n**Task** \n1. If this role relates to marketing, content creation, or audience engagement, write **1–2 concise icebreaker sentences** that:\n - Reference the company or job context \n - Explain how our Content Repurposing service can help\nMake sure to add the compnay name and job title.\n\nNote that we're not pitching based on the job title.\nWere pitching to the organization only if the job position they are looking for, can be fulfilled by our agency.\n\nExample:\nHey,\nI've noticed your'e looking for {{ $('Google Sheets - Adding All Job Posts').item.json.job_title }}.\n\nI have an offer that might be relevant to your team.\n\nThen transition to our offer of content repurpose\n2. Otherwise, reply with: \n---JOB POST NOT RELEVANT---",
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "c7b193d4-aec4-4438-8e0c-8bb12c50e629",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
3720,
540
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "MX2lQOZcGpmRvdVD",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.2
},
{
"id": "28b581d7-1245-45b2-af16-8eb945f2c553",
"name": "Google Sheets - 更新推荐内容",
"type": "n8n-nodes-base.googleSheets",
"position": [
3980,
320
],
"parameters": {
"columns": {
"value": {
"Pitch": "={{ $json.text }}",
"company_name": "={{ $('Split Out').item.json.company_name }}"
},
"schema": [
{
"id": "url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_url_overview",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_url_overview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_overview",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_overview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_headquarters",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_headquarters",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_revenue",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_revenue",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_sector",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_sector",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "percentage_that_recommend_company_to_a friend",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "percentage_that_recommend_company_to_a friend",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "percentage_that_approve_of_ceo",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "percentage_that_approve_of_ceo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_ceo",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_ceo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_career_opportunities_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_career_opportunities_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_comp_and_benefits_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_comp_and_benefits_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_culture_and_values_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_culture_and_values_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_senior_management_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_senior_management_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_work/life_balance_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_work/life_balance_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_by_same_job_pros",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reviews_by_same_job_pros",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_by_same_job_cons",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reviews_by_same_job_cons",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_benefits_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_benefits_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_benefits_employer_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_benefits_employer_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "employee_benefit_reviews",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "employee_benefit_reviews",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_posting_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_posting_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_application_link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_application_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_website",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_range_glassdoor_est",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pay_range_glassdoor_est",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_median_glassdoor",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pay_median_glassdoor",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_range_employer_est__DUPLICATE",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pay_range_employer_est__DUPLICATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_median_employer",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pay_median_employer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_range_currency",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pay_range_currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pay_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "discovery_input",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "discovery_input",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timestamp",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "input",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "input",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "error",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "error",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "error_code",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "error_code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pay_range_Employer_est",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pay_range_Employer_est",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Pitch",
"type": "string",
"display": true,
"required": false,
"displayName": "Pitch",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"company_name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ZYRk83hNIQCyQNaKpchdnbTiapVxE4aG6ZFIQlwEoWM/edit#gid=0",
"cachedResultName": "input"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1ZYRk83hNIQCyQNaKpchdnbTiapVxE4aG6ZFIQlwEoWM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ZYRk83hNIQCyQNaKpchdnbTiapVxE4aG6ZFIQlwEoWM/edit?usp=drivesdk",
"cachedResultName": "NoFluff-N8N-Sheet-Template- GlassdoorJob Scraping WIth Bright Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "4RJOMlGAcB9ZoYfm",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.5
}
],
"pinData": {},
"connections": {
"Split Out": {
"main": [
[
{
"node": "Basic LLM Chain",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain": {
"main": [
[
{
"node": "Google Sheets - Update Pitches",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Snapshot Progress": {
"main": [
[
{
"node": "If - Checking status of Snapshot - if data is ready or not",
"type": "main",
"index": 0
}
]
]
},
"Wait - Polling Bright Data": {
"main": [
[
{
"node": "Snapshot Progress",
"type": "main",
"index": 0
}
]
]
},
"On form submission - Discover Jobs": {
"main": [
[
{
"node": "HTTP Request- Post API call to Bright Data",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Adding All Job Posts": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request- Post API call to Bright Data": {
"main": [
[
{
"node": "Wait - Polling Bright Data",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request - Getting data from Bright Data": {
"main": [
[
{
"node": "Google Sheets - Adding All Job Posts",
"type": "main",
"index": 0
}
]
]
},
"If - Checking status of Snapshot - if data is ready or not": {
"main": [
[
{
"node": "Wait - Polling Bright Data",
"type": "main",
"index": 0
}
],
[
{
"node": "HTTP Request - Getting data from Bright Data",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 销售, 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
抓取竞品评论并使用 Bright Data 和 OpenAI 生成广告创意
抓取竞品评论并使用 Bright Data 和 OpenAI 生成广告创意
If
Wait
Gmail
+8
17 节点Yaron Been
产品
使用 Bright Data 和 GPT-4o-mini 抓取 Trustpilot 评论以制作成功广告文案
使用 Bright Data 和 GPT-4o-mini 抓取 Trustpilot 评论以制作成功广告文案
If
Wait
Gmail
+8
18 节点Yaron Been
人工智能
使用Bright Data和LLMs自动化大规模超个性化外联
通过Bright Data和大语言模型实现大规模超个性化外联自动化
If
Set
Wait
+8
21 节点Yaron Been
销售
使用 Bright Data 和 LLM 抓取 Indeed 职位列表以获取招聘信号
使用 Bright Data 和 LLM 抓取 Indeed 职位列表以获取招聘信号
If
Wait
Split Out
+6
17 节点Yaron Been
人力资源
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
AI个性化多产品邮件营销
基于SMTP轮换的AI个性化多产品邮件营销（GPT-4o/o3-mini）
If
Code
Wait
+16
41 节点Badr
销售
工作流信息
难度等级
高级
节点数量16
分类3
节点类型9
作者
Yaron Been
@yaron-nofluffBuilding AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host
外部链接
在 n8n.io 查看 →
分享此工作流