La gestion des marchés publics implique de nombreux documents et échéances. L’automatisation centralise chaque dossier, programme des rappels pour les dates clés, archive les échanges et prépare efficacement les audits. Ce système limite les risques d’oubli, sécurise les contrats et valorise la gestion administrative.
{
"meta": {
"instanceId": "1eadd5bc7c3d70c587c28f782511fd898c6bf6d97963d92e836019d2039d1c79"
},
"nodes": [
{
"id": "bee233ee-7212-4fbd-b151-0bb49919ca42",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
280
],
"parameters": {
"color": 4,
"width": 1289,
"height": 4398,
"content": "LinkedIn Job Data Scraper to Google SheetsnScrape live job posts from LinkedIn via Bright Data, clean them, and send to Google Sheets. Use for:nu2705 Job Hunting u2014 fresh, filtered rolesnu2705 Sales Prospecting u2014 find companies hiring (aka growing)nu2699ufe0f What's Usednn8n Nodes: Form u2192 HTTP Request u2192 Wait u2192 If u2192 Code u2192 Google SheetsnExternal Tools:nnBright Data u2013 Dataset APInGoogle Sheets u2013 Template Copynnud83dudd11 Setup u2013 Credentials NeedednnBright Data API Key u2192 Add to HTTP headers as: Authorization: Bearer YOUR_KEYnGoogle Sheets OAuth2 u2192 Connect account in n8nnnud83dudcdd Input Form u2013 FieldsnUsed to define what job data to scrape.nFieldDescriptionExampleLocationCity/regionNew York, BerlinKeywordRole to searchCMO, Data AnalystCountry2-letter ISO codeUS, UK, DETime RangeHow recent the jobs should be"Past 24 hours" or "Last 7 days" (recommended)Job TypeFull-time / Part-time / Contract(Optional)ExperienceEntry, Mid, Senior(Optional)RemoteFilter by remote-friendly roles(Optional)CompanyFilter by specific employer(Optional)nud83dude80 Workflow StepsnnUser fills input formnTrigger snapshot via Bright Data Dataset APInWait node + polling checks when data is ready (~1u20133 mins)nCleanup step:nnFlattens nested fields (job_poster, base_salary, etc.)nRemoves HTML from job descriptionsnnnSend to Google SheetnnSheet is pre-linked, 1 job per rownExample columns: job_title, company_name, location, salary_min, apply_link, job_description_plainnnnYou use the datannJob seekers u2192 Apply fastnSalespeople u2192 Spot buyers & offer helpnnnnud83dudca1 Pro TipsnnUse "Past 24 hours" or "Last 7 days" for fresher resultsnLeave filters empty if unsure u2014 Bright Data will return broader resultsnUse cleaned data for:nnCold email personalizationnLinkedIn outreachnBuilding ICP-based lead listsnnnnud83euddea Example API Bodynjson[ n { n "location": "New York", n "keyword": "Marketing Manager", n "country": "US", n "time_range": "Past 24 hours", n "job_type": "Part-time", n "experience_level": "", n "remote": "", n "company": "" n } n]nud83dudcc4 Template & Resourcesnnud83dudccb Google Sheet Template (Make a Copy)nud83dudcd8 Bright Data API Referencennud83dudee0ufe0f Customize ItnnAdd filters to HTTP Body (remote, experience_level, etc.)nChange polling interval if Bright Data is slownAdd custom logic to score/prioritize listingsnSend filtered lists to CRM, Slack, etc.nnThis gives you a live stream of hiring signals u2014 whether you're finding a job or pitching a service. One form. One click. Fully automated."
},
"typeVersion": 1
},
{
"id": "0fa9d0fe-b3ba-48be-99b9-2bc3aeb18b43",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-60
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "=======================================n WORKFLOW ASSISTANCEn=======================================nFor any questions or support, please contact:n Yaron@nofluff.onlinennExplore more tips and tutorials here:n - YouTube: https://www.youtube.com/@YaronBeen/videosn - LinkedIn: https://www.linkedin.com/in/yaronbeen/n=======================================n"
},
"typeVersion": 1
},
{
"id": "33cb416e-a7ff-4b55-9701-9b9e95d76f12",
"name": "Snapshot Progress",
"type": "n8n-nodes-base.httpRequest",
"position": [
2840,
360
],
"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 "
}
]
}
},
"typeVersion": 4.2
},
{
"id": "6b8c9405-8f8c-4a24-85ca-343d33e06141",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
3680,
140
],
"parameters": {
"width": 195,
"height": 646,
"content": "In this workflow, I use Google Sheets to store the results. nnYou can use my template to get started faster:nn1. [Click on this link to get the template](https://docs.google.com/spreadsheets/d/1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4/edit?usp=sharing)n2. Make a copy of the Sheetsn3. Add the URL to this node nnn"
},
"typeVersion": 1
},
{
"id": "3d3cd92a-9ea7-4a4f-a9b5-aae689f719e5",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
-60
],
"parameters": {
"width": 480,
"height": 2240,
"content": "# ud83dudd0d LinkedIn Jobs API u2013 Parameter GuidennUse this object to query LinkedIn job listings. nEach field lets you filter results based on different criteria.nn```jsonn{n "location": "{{ $json.Location }}",n "keyword": "{{ $json.Keyword }}",n "country": "{{ $json.Country }}",n "time_range": "Past 24 hours",n "job_type": "Part-time",n "experience_level": "",n "remote": "",n "company": ""n}n```nn## ud83euddfe Field Explanations & Valid Optionsnn### ud83duddfaufe0f locationnCity or region where the job is located.nUse a city or region name.nu2705 Example: "Berlin", "New York"nn### ud83eudde0 keywordnJob title or search keywords.nUse terms like role names or skills.nu2705 Example: "Data Scientist", "Growth Marketing"nn### ud83cudf0d countrynCountry code in ISO 3166-1 alpha-2 format.nu2705 Example: "US", "DE", "IL"nn### u23f1ufe0f time_rangenPosting date filter.nLimits results based on how recently jobs were posted.nAccepted values:n- Any Timen- Past 24 hoursn- Past Weekn- Past Monthnu2705 Example: "Past Week"nn### ud83dudcbc job_typenType of employment.nUse a single value or comma-separated list.nAccepted values:n- Full-timen- Part-timen- Contractn- Temporaryn- Internshipn- Volunteern- Othernu2705 Example: "Full-time,Contract"nn### ud83cudfaf experience_levelnSeniority level of the job.nAccepted values:n- Internshipn- Entry leveln- Associaten- Mid-Senior leveln- Directorn- Executivenu2705 Example: "Mid-Senior level"nn### ud83cudf10 remotenWorkplace type.nAccepted values:n- Remoten- On-siten- Hybridn- (leave blank for no preference)nu2705 Example: "Remote"nn### ud83cudfe2 companynFilter by company name.nOptional. Use plain text.nu2705 Example: "Google", "Spotify"nn## u2705 Full Examplenn```jsonn{n "location": "New York",n "keyword": "UI Designer",n "country": "US",n "time_range": "Past Week",n "job_type": "Full-time,Contract",n "experience_level": "Mid-Senior level",n "remote": "Hybrid",n "company": "Spotify"n}n```nn"
},
"typeVersion": 1
},
{
"id": "1d7a7bb0-1531-4516-9373-5e85a090b143",
"name": "On form submission - Discover Jobs",
"type": "n8n-nodes-base.formTrigger",
"position": [
1700,
580
],
"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:nnLocation (city or region)nnJob title or keywordsnnCountry codennFilters like posting date, job type, experience level, and remote optionsnnYou can also optionally narrow results by company name.nnud83eudde0 Tip: Leave fields blank if you want broader results."
},
"typeVersion": 2.2
},
{
"id": "aea569df-eedd-441f-aba5-c3c26a50fa87",
"name": "HTTP Request- Post API call to Bright Data",
"type": "n8n-nodes-base.httpRequest",
"position": [
2260,
620
],
"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 "time_range": "Past 24 hours",n "job_type": "Part-time",n "experience_level": "",n "remote": "",n "company": ""n }n] ",
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "dataset_id",
"value": "gd_lpfll7v5hcqtkxl6l"
},
{
"name": "endpoint",
"value": "https://yaron-nofluff.app.n8n.cloud/webhook-test/8c42463d-a631-4a17-a084-4bcbbb3bfc68"
},
{
"name": "notify",
"value": "https://yaron-nofluff.app.n8n.cloud/webhook-test/8c42463d-a631-4a17-a084-4bcbbb3bfc68"
},
{
"name": "format",
"value": "json"
},
{
"name": "uncompressed_webhook",
"value": "true"
},
{
"name": "type",
"value": "discover_new"
},
{
"name": "discover_by",
"value": "=keyword"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer "
}
]
}
},
"typeVersion": 4.2
},
{
"id": "8837f055-7243-44b6-87a2-e679d75839d0",
"name": "Wait - Polling Bright Data",
"type": "n8n-nodes-base.wait",
"position": [
2600,
360
],
"webhookId": "8005a2b3-2195-479e-badb-d90e4240e699",
"parameters": {
"unit": "minutes"
},
"executeOnce": false,
"typeVersion": 1.1
},
{
"id": "1f0ebefa-42a1-450c-b30a-64edabdaedaf",
"name": "If - Checking status of Snapshot - if data is ready or not",
"type": "n8n-nodes-base.if",
"position": [
3040,
360
],
"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": "e17b4da0-3f9c-45d5-acdf-ab634acfef97",
"name": "HTTP Request - Getting data from Bright Data",
"type": "n8n-nodes-base.httpRequest",
"position": [
3320,
380
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }}",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "format",
"value": "json"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer "
}
]
}
},
"typeVersion": 4.2
},
{
"id": "b5bd6a55-f80d-46f9-a59a-beff28de9da7",
"name": "Code - Cleaning Up",
"type": "n8n-nodes-base.code",
"position": [
3600,
400
],
"parameters": {
"jsCode": "// Helper function to strip HTML tagsnfunction stripHtml(html) {n return htmln .replace(/]+>/g, '') // remove all HTML tagsn .replace(/ /g, ' ') // decode HTML entitiesn .replace(/&[a-z]+;/g, '') // remove other HTML entitiesn .replace(/\s+/g, ' ') // normalize whitespacen .trim();n}nnreturn items.map(item => {n const data = item.json;nn // Flatten job_postern if (data.job_poster) {n data.job_poster_name = data.job_poster.name || '';n data.job_poster_title = data.job_poster.title || '';n data.job_poster_url = data.job_poster.url || '';n delete data.job_poster;n }nn // Flatten base_salaryn if (data.base_salary) {n data.salary_min = data.base_salary.min_amount || '';n data.salary_max = data.base_salary.max_amount || '';n data.salary_currency = data.base_salary.currency || '';n data.salary_period = data.base_salary.payment_period || '';n delete data.base_salary;n }nn // Clean up job description HTMLn if (data.job_description_formatted) {n data.job_description_plain = stripHtml(data.job_description_formatted);n }nn return { json: data };n});n"
},
"typeVersion": 2
},
{
"id": "70f4a4a0-b9ce-4b7a-b232-86014a7f8a3f",
"name": "Google Sheets - Adding All Job Posts",
"type": "n8n-nodes-base.googleSheets",
"position": [
3940,
440
],
"parameters": {
"columns": {
"value": {
"country_code": "={{ $json.country_code }}"
},
"schema": [
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"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": "job_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_description_plain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_description_plain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_poster_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_poster_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_poster_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_poster_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_poster_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_poster_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "salary_min",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "salary_min",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "salary_max",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "salary_max",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "salary_currency",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "salary_currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "salary_period",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "salary_period",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "application_availability",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "application_availability",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_posted_date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_posted_date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_logo",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_logo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country_code",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "country_code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timestamp",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_posted_time",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_posted_time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_num_applicants",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_num_applicants",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "discovery_input",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "discovery_input",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "apply_link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apply_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "title_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_description_formatted",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_description_formatted",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "input",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "input",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_seniority_level",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_seniority_level",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_function",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_function",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_employment_type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_employment_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_industries",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_industries",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_base_pay_range",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_base_pay_range",
"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": "1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4/edit?usp=drivesdk",
"cachedResultName": "NoFluff-N8N-Sheet-Template-Job Scraping WIth Bright Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "4RJOMlGAcB9ZoYfm",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.3,
"alwaysOutputData": true
},
{
"id": "297d778f-afa5-4d2d-baea-3b1fb199f77c",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1940,
-40
],
"parameters": {
"width": 300,
"height": 880,
"content": "ud83eudde0 Bright Data Trigger u2013 Customize Your Job QuerynnThis HTTP Request sends a POST call to Bright Data to start a new dataset snapshot based on your filters.nnud83dudc4b If you donu2019t want to use the Form Trigger,nyou can directly adjust the filters here in this node.nnYou can customize:nn"location" u2192 city, region, or keyword (e.g. "New York", "Remote")nn"keyword" u2192 job title or role (e.g. "CMO", "AI Engineer")nn"country" u2192 2-letter country code (e.g. "US", "UK")nn"time_range" u2192 "Past 24 hours", "Last 7 days", etc.nn"job_type", "experience_level", "remote", "company" u2192 optional filtersnnud83dudccc Tip:nUse "Past 24 hours" or "Last 7 days" for the freshest results."
},
"typeVersion": 1
},
{
"id": "54303791-b269-4930-85b5-33e50ae08f33",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2320,
220
],
"parameters": {
"color": 4,
"width": 940,
"height": 360,
"content": "Bright Data Getting Jobsn"
},
"typeVersion": 1
},
{
"id": "cccb03cb-0432-43ff-9c3a-233de510a775",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
1920,
580
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "12067869-0249-4cd2-b9e2-8e4055a0d917",
"name": "",
"type": "string",
"value": ""
}
]
}
},
"typeVersion": 3.4
}
],
"pinData": {},
"connections": {
"Edit Fields": {
"main": [
[
{
"node": "HTTP Request- Post API call to Bright Data",
"type": "main",
"index": 0
}
]
]
},
"Snapshot Progress": {
"main": [
[
{
"node": "If - Checking status of Snapshot - if data is ready or not",
"type": "main",
"index": 0
}
]
]
},
"Code - Cleaning Up": {
"main": [
[
{
"node": "Google Sheets - Adding All Job Posts",
"type": "main",
"index": 0
}
]
]
},
"Wait - Polling Bright Data": {
"main": [
[
{
"node": "Snapshot Progress",
"type": "main",
"index": 0
}
]
]
},
"On form submission - Discover Jobs": {
"main": [
[
{
"node": "Edit Fields",
"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": "Code - Cleaning Up",
"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
}
]
]
}
}
}