Mon workflow 11

Intermédiaire

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

Prérequis
  • Peut nécessiter les informations d'identification d'authentification de l'API cible
  • Informations d'identification Google Sheets API
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

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.

Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds7
Catégorie1
Types de nœuds4
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34