8
n8n Françaisamn8n.com

Analyser les startups Crunchbase par mots-clés avec Bright Data, Gemini AI et Google Sheets

Intermédiaire

Ceci est unAI, Marketingworkflow d'automatisation du domainecontenant 13 nœuds.Utilise principalement des nœuds comme If, Code, Wait, Merge, FormTrigger, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Analyser les startups Crunchbase par mots-clés avec Bright Data, Gemini AI et Google Sheets

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

Nœuds utilisés (13)

If
Code
Wait
Merge
StickyNote
FormTrigger
HttpRequest
GoogleSheets
ChainLlm
LmChatGoogleGemini

Catégorie

Intelligence Artificielle
Marketing
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
{
  "meta": {
    "instanceId": "71eb5622cf8abac565805540c0900dbae437dddbda45bf1b87bf3bfeea26393c"
  },
  "nodes": [
    {
      "id": "03a69683-ae41-4457-a067-f8eb3070e6cc",
      "name": "Progression de l'instantané",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -120,
        -220
      ],
      "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_API_KEY"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "042743bc-4a3a-4be7-87d2-5a0d7327b2aa",
      "name": "HTTP Requête - Appel POST API à Bright Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -620,
        40
      ],
      "parameters": {
        "url": "https://api.brightdata.com/datasets/v3/trigger",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "sendQuery": true,
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "keyword",
              "value": "={{ $json[\"Keyword\"] }}"
            }
          ]
        },
        "queryParameters": {
          "parameters": [
            {
              "name": "dataset_id",
              "value": "gd_l1vijqt9jfj7olije"
            },
            {
              "name": "type",
              "value": "discover_new"
            },
            {
              "name": "discover_by",
              "value": "keyword"
            },
            {
              "name": "include_errors",
              "value": "true"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer YOUR_API_KEY"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "4ae4d5a0-b266-4620-ae74-1230a1622437",
      "name": "Attente - Interrogation de Bright Data",
      "type": "n8n-nodes-base.wait",
      "position": [
        -340,
        -220
      ],
      "webhookId": "8005a2b3-2195-479e-badb-d90e4240e699",
      "parameters": {
        "amount": 15
      },
      "executeOnce": false,
      "typeVersion": 1.1
    },
    {
      "id": "fdd36a29-ee46-4737-892c-a8095db01233",
      "name": "Si - Vérification du statut de l'instantané - si les données sont prêtes ou non",
      "type": "n8n-nodes-base.if",
      "position": [
        100,
        -220
      ],
      "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": "6ef4e903-ef2d-4b0d-921b-30e848ad7590",
      "name": "HTTP Requête - Récupération des données de Bright Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        320,
        -220
      ],
      "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 YOUR_API_KEY"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "5686b066-2f14-4aa9-bfd0-834f02e514c7",
      "name": "Code - Analyser et nettoyer les données JSON",
      "type": "n8n-nodes-base.code",
      "position": [
        540,
        -220
      ],
      "parameters": {
        "language": "python",
        "pythonCode": "from datetime import datetime\n\nall_companies = _input.all()\n\nvalid_companies = []\nfor item in all_companies:\n    company = item.json\n    date_str = company.get(\"founded_date\")\n    try:\n        date = datetime.strptime(date_str, \"%Y-%m-%d\")\n        valid_companies.append((date, company))\n    except (TypeError, ValueError):\n        continue\n\nsorted_companies = sorted(valid_companies, key=lambda x: x[0], reverse=True)\n\ncleaned = []\nfor _, c in sorted_companies[:10]:\n    founders = c.get(\"founders\") or []\n    products = c.get(\"products_and_services\") or []\n    financials = c.get(\"financials_highlights\") or {}\n\n    cleaned.append({\n        \"name\": c.get(\"name\"),\n        \"founded\": c.get(\"founded_date\"),\n        \"about\": c.get(\"about\"),\n        \"num_employees\": c.get(\"num_employees\"),\n        \"type\": c.get(\"type\"),\n        \"ipo_status\": c.get(\"ipo_status\"),\n        \"full_description\": c.get(\"full_description\", \"\"),\n        \"monthly_visits\": c.get(\"monthly_visits\"),\n        \"social_media_links\": c.get(\"social_media_links\", []),\n        \"website\": c.get(\"website\"),\n        \"address\": c.get(\"address\"),\n        \"funding_total\": financials.get(\"funding_total\"),\n        \"num_investors\": c.get(\"num_investors\") or financials.get(\"num_investors\"),\n        \"lead_investors\": financials.get(\"num_lead_investors\"),\n        \"founders\": \", \".join([p.get(\"value\") for p in founders if p.get(\"value\")]),\n        \"products_and_services\": \", \".join([p.get(\"product_name\") for p in products if p.get(\"product_name\")]),\n        \"crunchbase_link\": c.get(\"url\"),\n        \"ai_analysis\": \"\"\n    })\n\nreturn [{\n    \"json\": {\n        \"companies\": cleaned\n    }\n}]\n"
      },
      "typeVersion": 2,
      "alwaysOutputData": true
    },
    {
      "id": "29f39c43-e688-43de-b249-5407abd3ff50",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        -400
      ],
      "parameters": {
        "content": "## Note \nModify the JSON keys in the code to include only the fields you want. The current structure is a sample template"
      },
      "typeVersion": 1
    },
    {
      "id": "29b00dad-9e5d-45fd-87ad-0c1a6659bfcd",
      "name": "Google Modèle de chat Gemini",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        340,
        220
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.0-flash"
      },
      "typeVersion": 1
    },
    {
      "id": "92076574-6e30-4436-81b0-a016c47d707e",
      "name": "Google Gemini - Analyse comparative",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        340,
        40
      ],
      "parameters": {
        "text": "={{$json}}",
        "messages": {
          "messageValues": [
            {
              "message": "=You will be provided with data for companies from Crunchbase, operating in the sector (or field of interests) that user requested by [keyword].\n\nPlease perform a comparative analysis of these companies. Highlight key similarities, differences, perspectives, and any notable outliers. The [keyword] user requested initially: {{ $('When User Completes Form').first().json['Keyword']}}.\nDon't start your answer with 'Okay'."
            }
          ]
        },
        "promptType": "define"
      },
      "typeVersion": 1.6
    },
    {
      "id": "10dacf61-006d-4821-aced-72beb4de1cf0",
      "name": "Lorsque l'utilisateur remplit le formulaire",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -840,
        40
      ],
      "webhookId": "41d0bffa-f5ca-4df7-b757-ca5a1e472b8a",
      "parameters": {
        "options": {
          "ignoreBots": true
        },
        "formTitle": "Search from Crunchbase by keyword",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Keyword",
              "placeholder": "e.g. \"AI in healthcare\"",
              "requiredField": true
            }
          ]
        },
        "responseMode": "lastNode",
        "formDescription": "Please provide a keyword to search and compare relevant startups"
      },
      "typeVersion": 2.2
    },
    {
      "id": "28aa3e45-bbaa-40a1-b0ec-33c81e8a1a7a",
      "name": "Fusionner",
      "type": "n8n-nodes-base.merge",
      "position": [
        780,
        -80
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "e7da127a-864c-4957-8be9-a48229885c78",
      "name": "Code - Combinaison des sorties JSON et IA",
      "type": "n8n-nodes-base.code",
      "position": [
        1000,
        -80
      ],
      "parameters": {
        "language": "python",
        "pythonCode": "input_0 = _input.all(0)\ninput_1 = _input.all(1) \n\nif not input_0 or not input_1:\n    raise ValueError(\"Missing input data on one of the inputs.\")\n\ncompanies = input_0[0].json.get(\"companies\")\nanalysis_text = input_1[1].json.get(\"text\")\n\nif companies:\n    companies[0][\"ai_analysis\"] = analysis_text\n\nreturn [{ \"json\": company } for company in companies]\n"
      },
      "typeVersion": 2
    },
    {
      "id": "60268912-b8e8-4fd9-ac86-ad5e4494e013",
      "name": "Google Sheets - Exporter les résultats",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        -80
      ],
      "parameters": {
        "columns": {
          "value": {
            "name": "={{ $json.companies[0].name }}"
          },
          "schema": [
            {
              "id": "name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "founded",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "founded",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "about",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "about",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "num_employees",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "num_employees",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "type",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ipo_status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "ipo_status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "full_description",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "full_description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "social_media_links",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "social_media_links",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "website",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "funding_total",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "funding_total",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "num_investors",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "num_investors",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "lead_investors",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "lead_investors",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "founders",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "founders",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "products_and_services",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "products_and_services",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "crunchbase_link",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "crunchbase_link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "text",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "text",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "companies",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "companies",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [
            "name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/134y4U1gc8DvM4bPhSfOUtZhjoBvx62dTsff2P8niGAg/edit#gid=0",
          "cachedResultName": "results"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "134y4U1gc8DvM4bPhSfOUtZhjoBvx62dTsff2P8niGAg",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/134y4U1gc8DvM4bPhSfOUtZhjoBvx62dTsff2P8niGAg/edit?usp=drivesdk",
          "cachedResultName": "Crunchbase Output"
        }
      },
      "typeVersion": 4.3,
      "alwaysOutputData": true
    }
  ],
  "pinData": {},
  "connections": {
    "28aa3e45-bbaa-40a1-b0ec-33c81e8a1a7a": {
      "main": [
        [
          {
            "node": "e7da127a-864c-4957-8be9-a48229885c78",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "03a69683-ae41-4457-a067-f8eb3070e6cc": {
      "main": [
        [
          {
            "node": "fdd36a29-ee46-4737-892c-a8095db01233",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "29b00dad-9e5d-45fd-87ad-0c1a6659bfcd": {
      "ai_languageModel": [
        [
          {
            "node": "92076574-6e30-4436-81b0-a016c47d707e",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "10dacf61-006d-4821-aced-72beb4de1cf0": {
      "main": [
        [
          {
            "node": "042743bc-4a3a-4be7-87d2-5a0d7327b2aa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4ae4d5a0-b266-4620-ae74-1230a1622437": {
      "main": [
        [
          {
            "node": "03a69683-ae41-4457-a067-f8eb3070e6cc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "60268912-b8e8-4fd9-ac86-ad5e4494e013": {
      "main": [
        []
      ]
    },
    "5686b066-2f14-4aa9-bfd0-834f02e514c7": {
      "main": [
        [
          {
            "node": "92076574-6e30-4436-81b0-a016c47d707e",
            "type": "main",
            "index": 0
          },
          {
            "node": "28aa3e45-bbaa-40a1-b0ec-33c81e8a1a7a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e7da127a-864c-4957-8be9-a48229885c78": {
      "main": [
        [
          {
            "node": "60268912-b8e8-4fd9-ac86-ad5e4494e013",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "92076574-6e30-4436-81b0-a016c47d707e": {
      "main": [
        [
          {
            "node": "28aa3e45-bbaa-40a1-b0ec-33c81e8a1a7a",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "042743bc-4a3a-4be7-87d2-5a0d7327b2aa": {
      "main": [
        [
          {
            "node": "4ae4d5a0-b266-4620-ae74-1230a1622437",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6ef4e903-ef2d-4b0d-921b-30e848ad7590": {
      "main": [
        [
          {
            "node": "5686b066-2f14-4aa9-bfd0-834f02e514c7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fdd36a29-ee46-4737-892c-a8095db01233": {
      "main": [
        [
          {
            "node": "4ae4d5a0-b266-4620-ae74-1230a1622437",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "6ef4e903-ef2d-4b0d-921b-30e848ad7590",
            "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, Marketing

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

Bulletin d'actualités par mots-clés Bright Data avec résumé IA
Bulletin de nouvelles par mots-clés et résumé IA pour les courriels avec Bright Data
If
Code
Wait
+
If
Code
Wait
13 NœudsGleb D
Intelligence Artificielle
Générateur de requêtes et de rapports de prix des concurrents
Générateur de requêtes de prix et de rapports concurrentiels basé sur Bright Data
If
Set
Code
+
If
Set
Code
19 NœudsGleb D
Intelligence Artificielle
Rechercher des profils Twitter par nom, scraper les publications, analyser le contenu avec IA et enregistrer dans Google Sheets
Trouver, scraper et analyser les tweets par nom avec Bright Data et Gemini
If
Set
Code
+
If
Set
Code
22 NœudsGleb D
Intelligence Artificielle
Créer et approuver des vidéos POV en utilisant l'IA, ElevenLabs et une publication multiplateforme
Créer et approuver des vidéos POV (TikTok/IG/YT) avec IA, ElevenLabs et publication multiplateforme
If
Set
Code
+
If
Set
Code
60 NœudsImmanuel
Design
Découverte des lacunes en matière de recherche de marché et de référencement (SEO) par analyse du contenu concurrent
utilisation InfraNodus GraphRAG analyse竞争对手网站contenu空白，助力 SEO
If
Code
Wait
+
If
Code
Wait
37 NœudsInfraNodus
Intelligence Artificielle
Agent d'automatisation de publication TikTok V3.1
🚀 Conversion de podcasts en extraits virals TikTok avec Gemini AI et publication automatique ✅
If
Set
Code
+
If
Set
Code
54 NœudsMateo Fiorito Rocha
Design
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds13
Catégorie2
Types de nœuds10
Description de la difficulté

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

Auteur
Gleb D

Gleb D

@glebd
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