Mon workflow 11
Ceci est unAIworkflow d'automatisation du domainecontenant 7 nœuds.Utilise principalement des nœuds comme HttpRequest, GoogleSheets, ManualTrigger, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Enrichissement des profils LinkedIn (sans compte requis) en utilisant Ghost Genius et Google Sheets
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
Nœuds utilisés (7)
Catégorie
{
"id": "aYhTrpk2bbP6PzC7",
"meta": {
"instanceId": "95a1299fb2b16eb2219cb044f54e72c2d00dcd2c72efe717b3c308d200f29927"
},
"name": "My workflow 11",
"tags": [],
"nodes": [
{
"id": "8332ef6d-626b-4fa8-888c-e41284154d73",
"name": "Start",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-400,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e24a9fbf-2812-4386-bee9-857df3ba4924",
"name": "Obtenir les infos du profil",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
40,
440
],
"parameters": {
"url": "https://api.ghostgenius.fr/v2/profile",
"options": {
"batching": {
"batch": {
"batchSize": 1,
"batchInterval": 2000
}
}
},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $json.url }}"
}
]
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "c6c53ff4-5c54-48ac-940f-05faf4f335cc",
"name": "Récupérer les profils",
"type": "n8n-nodes-base.googleSheets",
"position": [
-180,
440
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI/edit?usp=drivesdk",
"cachedResultName": "Copy of List of profiles"
}
},
"typeVersion": 4.5
},
{
"id": "ebc0382a-3d69-43bc-a64d-409647649e49",
"name": "Mettre à jour",
"type": "n8n-nodes-base.googleSheets",
"position": [
260,
440
],
"parameters": {
"columns": {
"value": {
"url": "={{ $('Recover Profiles').item.json.url }}",
"Skills": "={{ ($json.skills?.length > 0) ? $json.skills.join(', ') : '' }}",
"Hiring?": "={{ $json.is_hiring.toString() }}",
"Summary": "={{ $json.summary }}",
"Tagline": "={{ $json.headline }}",
"Lastname": "={{ $json.last_name }}",
"Location": "={{ [$json.geo?.location?.name, $json.geo?.country?.name].filter(Boolean).join(', ') }}",
"Firstname": "={{ $json.first_name }}",
"Followers": "={{ $json.followers }}",
"Languages": "={{ $json.languages?.map(lang => lang.name + ' (' + lang.level + ')').join(', ') ?? '' }}",
"Connections": "={{ $json.connections }}",
"Education 1": "={{ $json.educations?.[0]?.school?.full_name ?? '' }}\n{{ $json.educations?.[0]?.school?.url ?? '' }}\n{{ [$json.educations?.[0]?.start, $json.educations?.[0]?.end].filter(Boolean).join(' - ') }}\n{{ $json.educations?.[0]?.description ?? '' }}\n{{ [$json.educations?.[0]?.grade, $json.educations?.[0]?.major, $json.educations?.[0]?.degree].filter(Boolean).join(' - ') }}",
"Education 2": "={{ $json.educations?.[1]?.school?.full_name ?? '' }}\n{{ $json.educations?.[1]?.school?.url ?? '' }}\n{{ [$json.educations?.[1]?.start, $json.educations?.[1]?.end].filter(Boolean).join(' - ') }}\n{{ $json.educations?.[1]?.description ?? '' }}\n{{ [$json.educations?.[1]?.grade, $json.educations?.[1]?.major, $json.educations?.[1]?.degree].filter(Boolean).join(' - ') }}",
"Education 3": "={{ $json.educations?.[2]?.school?.full_name ?? '' }}\n{{ $json.educations?.[2]?.school?.url ?? '' }}\n{{ [$json.educations?.[2]?.start, $json.educations?.[2]?.end].filter(Boolean).join(' - ') }}\n{{ $json.educations?.[2]?.description ?? '' }}\n{{ [$json.educations?.[2]?.grade, $json.educations?.[2]?.major, $json.educations?.[2]?.degree].filter(Boolean).join(' - ') }}",
"Experience 1": "={{ $json.experiences?.[0]?.company?.name ?? '' }}\n{{ $json.experiences?.[0]?.company?.url ?? '' }}\n{{ ($json.experiences?.[0]?.start ?? '') + (($json.experiences?.[0]?.start && $json.experiences?.[0]?.end) ? ' - ' : '') + ($json.experiences?.[0]?.end ?? '') }}\n{{ $json.experiences?.[0]?.position ?? '' }}\n{{ $json.experiences?.[0]?.location ?? '' }}",
"Experience 2": "={{ $json.experiences?.[1]?.company?.name ?? '' }}\n{{ $json.experiences?.[1]?.company?.url ?? '' }}\n{{ ($json.experiences?.[1]?.start ?? '') + (($json.experiences?.[1]?.start && $json.experiences?.[1]?.end) ? ' - ' : '') + ($json.experiences?.[1]?.end ?? '') }}\n{{ $json.experiences?.[1]?.position ?? '' }}\n{{ $json.experiences?.[1]?.location ?? '' }}",
"Experience 3": "={{ $json.experiences?.[2]?.company?.name ?? '' }}\n{{ $json.experiences?.[2]?.company?.url ?? '' }}\n{{ ($json.experiences?.[2]?.start ?? '') + (($json.experiences?.[2]?.start && $json.experiences?.[2]?.end) ? ' - ' : '') + ($json.experiences?.[2]?.end ?? '') }}\n{{ $json.experiences?.[2]?.position ?? '' }}\n{{ $json.experiences?.[2]?.location ?? '' }}",
"Experience 4": "={{ $json.experiences?.[3]?.company?.name ?? '' }}\n{{ $json.experiences?.[3]?.company?.url ?? '' }}\n{{ ($json.experiences?.[3]?.start ?? '') + (($json.experiences?.[3]?.start && $json.experiences?.[3]?.end) ? ' - ' : '') + ($json.experiences?.[3]?.end ?? '') }}\n{{ $json.experiences?.[3]?.position ?? '' }}\n{{ $json.experiences?.[3]?.location ?? '' }}",
"Experience 5": "={{ $json.experiences?.[4]?.company?.name ?? '' }}\n{{ $json.experiences?.[4]?.company?.url ?? '' }}\n{{ ($json.experiences?.[4]?.start ?? '') + (($json.experiences?.[4]?.start && $json.experiences?.[4]?.end) ? ' - ' : '') + ($json.experiences?.[4]?.end ?? '') }}\n{{ $json.experiences?.[4]?.position ?? '' }}\n{{ $json.experiences?.[4]?.location ?? '' }}",
"Open to work?": "={{ $json.is_open_to_work.toString() }}"
},
"schema": [
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Firstname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lastname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tagline",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Tagline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Connections",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Connections",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Followers",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Followers",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Hiring?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Hiring?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Open to work?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Open to work?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Languages",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Languages",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skills",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Skills",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 4",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 4",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 5",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 5",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Education 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Education 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Education 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skills",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Skills",
"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": [
"url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oiV25COrTMP20nMgNvbtMo2LHcm7ehkqOxbAB-s6PhA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI/edit?usp=drivesdk",
"cachedResultName": "Copy of List of profiles"
}
},
"typeVersion": 4.5
},
{
"id": "91c969bc-dd32-45a3-a8e7-f69ce94fe365",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
280
],
"parameters": {
"color": 5,
"width": 1040,
"height": 420,
"content": "## Enrich a LinkedIn profile list"
},
"typeVersion": 1
},
{
"id": "62815f2f-a917-4f39-987a-2e0ce9046134",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"width": 420,
"height": 220,
"content": "## Resources\n[Video Setup](https://youtu.be/kIOJeMoCfp4)\n\nGoogle Sheet: [Make a copy here](https://docs.google.com/spreadsheets/d/1oiV25COrTMP20nMgNvbtMo2LHcm7ehkqOxbAB-s6PhA/edit?usp=sharing)\n\nAPI LinkedIn (cookieless): [Ghost Genius](https://ghostgenius.fr)\n\nGoogle Sheet Credential Setup: [Video Tutorial](https://www.youtube.com/watch?v=pWGXlZBGu4k)"
},
"typeVersion": 1
},
{
"id": "f477d4bc-9e67-4b93-a8aa-12bdf2807daa",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
80
],
"parameters": {
"color": 7,
"height": 80,
"content": "# [Setup Video](https://youtu.be/kIOJeMoCfp4)"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "2474bd40-54d9-4582-a58d-2a085b82ab64",
"connections": {
"8332ef6d-626b-4fa8-888c-e41284154d73": {
"main": [
[
{
"node": "c6c53ff4-5c54-48ac-940f-05faf4f335cc",
"type": "main",
"index": 0
}
]
]
},
"e24a9fbf-2812-4386-bee9-857df3ba4924": {
"main": [
[
{
"node": "ebc0382a-3d69-43bc-a64d-409647649e49",
"type": "main",
"index": 0
}
]
]
},
"c6c53ff4-5c54-48ac-940f-05faf4f335cc": {
"main": [
[
{
"node": "e24a9fbf-2812-4386-bee9-857df3ba4924",
"type": "main",
"index": 0
}
]
]
}
}
}Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Intermédiaire - Intelligence Artificielle
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Matthieu
@yaznowPartager ce workflow