8
n8n Françaisamn8n.com

Générateur d'aimants pour prospects

Intermédiaire

Ceci est unContent Creation, Multimodal AIworkflow d'automatisation du domainecontenant 15 nœuds.Utilise principalement des nœuds comme If, Wait, HttpRequest, GoogleSheets, SplitInBatches. Générer des idées de aimants à prospects avec RapidAPI AI à partir de Google Sheets

Prérequis
  • •Peut nécessiter les informations d'identification d'authentification de l'API cible
  • •Informations d'identification Google Sheets API
  • •Informations d'identification Google Drive API

Nœuds utilisés (15)

If
Wait
StickyNote
HttpRequest
GoogleSheets
SplitInBatches
GoogleDriveTrigger

Catégorie

Création de contenu
IA Multimodale
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "id": "XbA6Q2NrTmh3RvvK",
  "meta": {
    "instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
    "templateCredsSetupCompleted": true
  },
  "name": "Lead Magnet Generation",
  "tags": [],
  "nodes": [
    {
      "id": "0e3082c1-cb3d-4b6e-9367-c3da75a02da5",
      "name": "Requête HTTP",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1060,
        160
      ],
      "parameters": {
        "url": "https://lead-magnet-idea-generator-ai.p.rapidapi.com/index.php",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "multipart-form-data",
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "topic",
              "value": "={{ $json.Topic }}"
            },
            {
              "name": "website",
              "value": "={{ $json['Website Url'] }}"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "x-rapidapi-host",
              "value": "lead-magnet-idea-generator-ai.p.rapidapi.com"
            },
            {
              "name": "x-rapidapi-key"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "5dd91b00-0670-430f-aeed-365cee02225b",
      "name": "Boucler sur les éléments",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        480,
        0
      ],
      "parameters": {
        "options": {
          "reset": false
        }
      },
      "typeVersion": 3
    },
    {
      "id": "2e99095a-b29f-428c-990d-b6fffd40adcb",
      "name": "Attendre",
      "type": "n8n-nodes-base.wait",
      "position": [
        1640,
        140
      ],
      "webhookId": "74ac1ccb-f843-41b8-97c4-b8d32892a5ea",
      "parameters": {
        "amount": 10
      },
      "typeVersion": 1.1
    },
    {
      "id": "952b9061-9f2c-41b4-9f0a-1567160f3540",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        800,
        20
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "e0b7b7c8-3a7a-466d-bae7-269282b49d34",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Topic }}",
              "rightValue": ""
            },
            {
              "id": "64dde394-0e49-4306-a24a-de2bf448fc95",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Content }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "9a000b36-5933-4891-9b1d-e31ef6092ed8",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        180,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": ""
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "qUtlCnYpk7bXXaYp",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "64b72bb3-a25a-4cc7-843a-79f25486afd8",
      "name": "Google Drive Trigger",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -80,
        0
      ],
      "parameters": {
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFile",
        "fileToWatch": {
          "__rl": true,
          "mode": "url",
          "value": ""
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "qUtlCnYpk7bXXaYp",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2d1d2710-ea6a-4953-bdd7-8f6341177066",
      "name": "Google Sheets2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1360,
        140
      ],
      "parameters": {
        "columns": {
          "value": {
            "Topic": "={{ $('If').item.json.Topic }}",
            "Content": "={{ $json.data }}",
            "Website Url": "={{ $('If').item.json['Website Url'] }}",
            "Generated Date": "={{ new Date().toLocaleString() }}"
          },
          "schema": [
            {
              "id": "Topic",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Topic",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website Url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Website Url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Content",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Content",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Generated Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Generated Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Topic"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": ""
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "qUtlCnYpk7bXXaYp",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "831e52d3-07f3-4f33-b820-9e33b13d5506",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        -480
      ],
      "parameters": {
        "width": 660,
        "height": 940,
        "content": "# 🚀 Lead Magnet Idea Generation Workflow\n\n## 🧩 Purpose\nAutomatically generates **lead magnet content ideas** based on a Google Sheet containing topics and website URLs. It checks for rows where content is missing and fills it using an AI API.\n\n---\n\n## ✅ Problem Solved\n\n| ❌ Problem                            | ✅ Solution                                                                 |\n|--------------------------------------|-----------------------------------------------------------------------------|\n| Manual content idea generation       | Automatically generates using a Lead Magnet AI API                          |\n| Missing content in sheet rows        | Detects missing \"Content\" and fills it intelligently                        |\n| No record of when ideas were created | Appends current date/time on content creation                               |\n| Repeated manual checks               | Uses Google Drive Trigger to monitor changes every minute                   |\n\n---\n\n## 🔄 Workflow Overview\n\n```mermaid\ngraph TD\n    A[Google Drive Trigger] --> B[Google Sheets1 (Read Data)]\n    B --> C[Loop Over Items]\n    C --> D{If: Topic not empty AND Content empty?}\n    D -->|Yes| E[HTTP Request (Generate Content)]\n    E --> F[Google Sheets2 (Write Data)]\n    F --> G[Wait (10s)]\n    G --> C\n    D -->|No| C\n"
      },
      "typeVersion": 1
    },
    {
      "id": "0c29124c-3409-4682-8dda-a4319e8844a8",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -420
      ],
      "parameters": {
        "height": 640,
        "content": "### 📌 Node: Google Drive Trigger\n\n- **Type:** Trigger (n8n-nodes-base.googleDriveTrigger)\n- **Function:** Watches a specific Google Sheet file for changes.\n- **Trigger Mode:** Every minute (`pollTimes`)\n- **Why it's used:** To detect changes in the spreadsheet and initiate the automation workflow.\n- **Authentication:** Google Service Account\n- **Watched File:** \n"
      },
      "typeVersion": 1
    },
    {
      "id": "731e5f13-05c1-43bb-9810-a41955f2ecf5",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        120,
        -420
      ],
      "parameters": {
        "height": 640,
        "content": "### 📌 Node: Google Sheets1\n\n- **Type:** Google Sheets (Read)\n- **Function:** Reads all data from the specified sheet.\n- **Why it's used:** Fetches rows to process for lead magnet generation.\n- **Sheet Name:** Sheet1 (gid=0)\n- **Authentication:** Google Service Account\n"
      },
      "typeVersion": 1
    },
    {
      "id": "9fbf2aed-8272-47b0-8a89-5b0abcf02e79",
      "name": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        -420
      ],
      "parameters": {
        "height": 640,
        "content": "### 📌 Node: Loop Over Items\n\n- **Type:** Split In Batches (n8n-nodes-base.splitInBatches)\n- **Function:** Processes each row one at a time.\n- **Why it's used:** Ensures efficient row-by-row processing to control API load.\n- **Options:**\n  - `reset: false`\n"
      },
      "typeVersion": 1
    },
    {
      "id": "52a1ecbe-9942-4f6f-9d32-a44a0e3e3a1f",
      "name": "Note adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        700,
        -420
      ],
      "parameters": {
        "height": 640,
        "content": "### 📌 Node: If\n\n- **Type:** Conditional Check\n- **Function:** Filters rows where:\n  - `Topic` is **not empty**\n  - `Content` is **empty**\n- **Why it's used:** To skip rows that already have generated content or are missing topics.\n- **Condition Logic:**\n  - `Topic` → `notEmpty`\n  - `Content` → `empty`\n- **Combinator:** `AND`\n"
      },
      "typeVersion": 1
    },
    {
      "id": "86e47d98-d052-4203-b056-9442f20b0fa4",
      "name": "Note adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        980,
        -420
      ],
      "parameters": {
        "width": 280,
        "height": 820,
        "content": "### 📌 Node: HTTP Request\n\n- **Type:** HTTP Request (POST)\n- **Function:** Sends topic and website to an external AI API to generate lead magnet ideas.\n- **URL:** `https://lead-magnet-idea-generator-ai.p.rapidapi.com/index.php`\n- **Headers:**\n  - `x-rapidapi-host: lead-magnet-idea-generator-ai.p.rapidapi.com`\n  - `x-rapidapi-key: <your-api-key>`\n- **Body Content-Type:** `multipart/form-data`\n- **Body Parameters:**\n  - `topic`: `={{ $json.Topic }}`\n  - `website`: `={{ $json['Website Url'] }}`\n- **Why it's used:** Automates lead magnet idea generation via third-party API.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "866680d1-8d17-45ab-81eb-b7a1cb9448d0",
      "name": "Note adhésive6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1280,
        -420
      ],
      "parameters": {
        "height": 700,
        "content": "### 📌 Node: Google Sheets2\n\n- **Type:** Google Sheets (Append or Update)\n- **Function:** Updates the same row with generated content and timestamp.\n- **Why it's used:** Writes the result back into the Google Sheet.\n- **Columns Mapping:**\n  - `Topic`: `={{ $('If').item.json.Topic }}`\n  - `Website Url`: `={{ $('If').item.json['Website Url'] }}`\n  - `Content`: `={{ $json.data }}`\n  - `Generated Date`: `={{ new Date().toLocaleString() }}`\n- **Matching Column:** Topic\n- **Authentication:** Google Service Account\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "0d382187-48dc-45cc-bc27-cba36049bd6b",
      "name": "Note adhésive7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1560,
        -420
      ],
      "parameters": {
        "height": 680,
        "content": "### 📌 Node: Wait\n\n- **Type:** Wait Node\n- **Function:** Pauses the workflow for 10 seconds after writing data.\n- **Why it's used:** Prevents rapid API hits and allows smooth looping.\n- **Wait Time:** 10 seconds\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "4caf167f-472a-4c9e-aef3-4b77c3fa4b93",
  "connections": {
    "952b9061-9f2c-41b4-9f0a-1567160f3540": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "2d1d2710-ea6a-4953-bdd7-8f6341177066",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9a000b36-5933-4891-9b1d-e31ef6092ed8": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2d1d2710-ea6a-4953-bdd7-8f6341177066": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "952b9061-9f2c-41b4-9f0a-1567160f3540",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "64b72bb3-a25a-4cc7-843a-79f25486afd8": {
      "main": [
        [
          {
            "node": "9a000b36-5933-4891-9b1d-e31ef6092ed8",
            "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 - Création de contenu, IA Multimodale

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

Transcription de texte TikTok
Automatiser la transcription de vidéos TikTok avec RapidAPI et Google Sheets
If
Code
Wait
+
If
Code
Wait
21 NœudsEvoort Solutions
Création de contenu
Générer et téléverser des images avec Image-to-Image GPT, Google Sheets et Drive
Générer et téléverser des images avec GPT de texte en image, Google Sheets et Drive
If
Code
Wait
+
If
Code
Wait
23 NœudsEvoort Solutions
Création de contenu
Téléchargement de vidéos TikTok sans filigrane vers Google Drive et enregistrement automatique dans une feuille de calcul
Télécharger des vidéos TikTok sans filigrane sur Google Drive et enregistrer automatiquement les logs dans une feuille de données
If
Wait
Form Trigger
+
If
Wait
Form Trigger
19 NœudsEvoort Solutions
Création de contenu
Automatisation de la recherche d'emploi avec Job Search Global API et Google Sheets
Automatisation de la recherche d'offres d'emploi avec Job Search Global API et Google Sheets
If
Set
Code
+
If
Set
Code
15 NœudsEvoort Solutions
Création de contenu
Optimiser la clarté des titres avec Google Sheets et des notifications par e-mail
Optimiser la clarté des titres avec Google Sheets et notifications par e-mail
If
Code
Email Send
+
If
Code
Email Send
14 NœudsEvoort Solutions
Création de contenu
Envoi automatique de messages de remerciements WhatsApp et de coupons de fidélité sur Shopify (en utilisant l'API Rapiwa)
Envoi automatique de messages de remerciement et de coupons de fidélité WhatsApp depuis Shopify avec Rapiwa
If
Code
Wait
+
If
Code
Wait
17 NœudsSpaGreen Creative
Création de contenu
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds15
Catégorie2
Types de nœuds7
Description de la difficulté

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

Auteur
Evoort Solutions

Evoort Solutions

@evoortsolutions
Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34