27 Analyser les lacunes du marché

• •Informations d'identification Google Sheets API
• •Clé API OpenAI

{
  "id": "vrH9xsqMNkN1dmSN",
  "meta": {
    "instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
    "templateCredsSetupCompleted": true
  },
  "name": "27 Analyze Market Gaps",
  "tags": [],
  "nodes": [
    {
      "id": "149811e9-798b-413b-a159-5e07bb541fd0",
      "name": "Trigger : Exécuter la Vérification Hebdomadaire",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "weeks",
              "triggerAtDay": [
                1
              ],
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "d175072a-abba-4e05-8262-0a7991d1fc66",
      "name": "Set : Sujet ou URL Cible",
      "type": "n8n-nodes-base.set",
      "position": [
        200,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "f4de0d45-1ec2-4582-afa8-0f10fea9dd57",
              "name": "url",
              "type": "string",
              "value": "https://medium.com/@moneytent/how-i-generate-100-saas-ideas-from-market-gap-to-product-market-fit-f05ee5d539ee"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "4a88bcd9-e0ab-4fe1-a84b-29e6276d9812",
      "name": "Agent IA : Analyser la Lacune du Marché",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        440,
        0
      ],
      "parameters": {
        "text": "=Screpe the url below and look market gaps to build a product on.\n\nURL: {{ $json.url }}",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2
    },
    {
      "id": "589342ae-282d-47e9-9ec4-7df88812952e",
      "name": "Code : Diviser les Opportunités",
      "type": "n8n-nodes-base.code",
      "position": [
        880,
        0
      ],
      "parameters": {
        "jsCode": "// Sample input data from previous node\nconst items = $json[\"output\"][\"productOpportunities\"];\n\n// Emit each opportunity as a single item\nreturn items.map(opportunity => {\n  return {\n    json: {\n      name: opportunity.name,\n      description: opportunity.description\n    }\n  };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "3e349bd0-3e28-4a09-b1df-4bac44406ede",
      "name": "Google Sheets : Enregistrer les Idées SaaS",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1080,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $json.name }}",
            "Description": "={{ $json.description }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1I2tG3DCCcMyoKtMIW6ALkp9KAgyndiik0YfWRaSWb2w/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1I2tG3DCCcMyoKtMIW6ALkp9KAgyndiik0YfWRaSWb2w",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1I2tG3DCCcMyoKtMIW6ALkp9KAgyndiik0YfWRaSWb2w/edit?usp=drivesdk",
          "cachedResultName": "Market Gaps"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "r2mDaisH6e9VkwHl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "bfb80b71-c78b-46f5-a5a2-24911e747519",
      "name": "LLM : Générateur d'Insights",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        400,
        280
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8sEyPDkC5p4w4Jha",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "630647dc-c0de-4165-a776-603de4c2aee3",
      "name": "Bright Data : Agent de Scraping",
      "type": "n8n-nodes-mcp.mcpClientTool",
      "position": [
        560,
        280
      ],
      "parameters": {
        "toolName": "scrape_as_markdown",
        "operation": "executeTool",
        "toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}"
      },
      "credentials": {
        "mcpClientApi": {
          "id": "eqq94k789oJCd6jU",
          "name": "MCP Client (STDIO) account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5aac989c-f503-4e72-b2da-a3db5e9be6a0",
      "name": "Note Adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -20,
        -680
      ],
      "parameters": {
        "color": 6,
        "width": 360,
        "height": 860,
        "content": "## 🟩 **SECTION 1: Define What to Analyze**\n\n### 🔁 Nodes: `Schedule Trigger` + `Edit Fields`\n\n| 🔧 Node              | Name                          | Purpose                                                                                                                      |\n| -------------------- | ----------------------------- | ---------------------------------------------------------------------------------------------------------------------------- |\n| ⏰ `Schedule Trigger` | **Trigger: Run Weekly Check** | Starts this automation on a schedule (e.g., every Monday at 9 AM).                                                           |\n| 📝 `Edit Fields`     | **Set: Target Topic or URL**  | Manually input the industry, keyword, or trend you want to explore (like *\"AI in Healthcare\"* or *\"Sustainable Packaging\"*). |\n\n### 🧠 Beginner Tip:\n\n> This section is where **you control the topic**. You don’t need to write code — just input a keyword, and the system will go fetch all the useful insights for you later.\n\n---\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8a861a96-f34b-4e40-8804-04477a94f858",
      "name": "Note Adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        -1120
      ],
      "parameters": {
        "color": 3,
        "width": 300,
        "height": 1300,
        "content": "## 🟦 **SECTION 2: Discover Market Gaps with AI Agent**\n\n### 🧠 Node: `AI Agent`\n\nSub-nodes: `OpenAI Chat Model`, `MCP Client (Bright Data)`, `Structured Output Parser`\n\n| 🤖 Node                       | Name                             | Purpose                                                                                              |\n| ----------------------------- | -------------------------------- | ---------------------------------------------------------------------------------------------------- |\n| 🧠 `AI Agent`                 | **AI Agent: Analyze Market Gap** | Main node that coordinates the scraping and insight generation.                                      |\n| 🌐 `MCP Client`               | **Bright Data: Scraper Agent**   | Scrapes websites like Statista, Reddit, G2, etc., to find pain points, trends, and missing products. |\n| 🧠 `OpenAI Chat Model`        | **LLM: Insight Generator**       | Summarizes scraped data and identifies potential product opportunities using GPT.                    |\n| 🧾 `Structured Output Parser` | **Parser: JSON Output Builder**  | Converts messy AI output into clean, structured JSON (with product names and descriptions).          |\n\n### 🧠 Beginner Tip:\n\n> This is the **brain** of the workflow. It does the heavy lifting — finding real problems from real users, and then generating SaaS product ideas you can build. You don’t need to write the ideas — the AI will suggest them based on actual market gaps.\n\n---\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "54b0dda6-7e85-4476-98d7-e9da30ee98b3",
      "name": "Note Adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        840,
        -620
      ],
      "parameters": {
        "color": 5,
        "width": 400,
        "height": 800,
        "content": "## 🟨 **SECTION 3: Break Into Pieces & Save to Google Sheets**\n\n### 🔧 Nodes: `Code` + `Google Sheets`\n\n| ⚙️ Node            | Name                              | Purpose                                                                                                        |\n| ------------------ | --------------------------------- | -------------------------------------------------------------------------------------------------------------- |\n| 🧩 `Code`          | **Code: Split Opportunities**     | Takes the structured list of SaaS ideas and splits it into individual items (so they can be saved one by one). |\n| 📄 `Google Sheets` | **Google Sheets: Log SaaS Ideas** | Automatically saves each product idea (name + description) into your connected spreadsheet.                    |\n\n### 🧠 Beginner Tip:\n\n> This is where all your hard work **gets stored**. Every week, your sheet grows with new SaaS ideas automatically — perfect for product research, newsletters, or startup launches.\n\n---\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8c7e64de-a10b-4b9e-b3fa-fa48201322d2",
      "name": "Note Adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1320,
        -620
      ],
      "parameters": {
        "color": 7,
        "width": 380,
        "height": 240,
        "content": "## I’ll receive a tiny commission if you join Bright Data through this link—thanks for fueling more free content!\n\n### https://get.brightdata.com/1tndi4600b25"
      },
      "typeVersion": 1
    },
    {
      "id": "40cd0845-d3a7-4d31-b812-7a3c05b023f5",
      "name": "Note Adhésive9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1720,
        -680
      ],
      "parameters": {
        "color": 4,
        "width": 1300,
        "height": 320,
        "content": "=======================================\n            WORKFLOW ASSISTANCE\n=======================================\nFor any questions or support, please contact:\n    Yaron@nofluff.online\n\nExplore more tips and tutorials here:\n   - YouTube: https://www.youtube.com/@YaronBeen/videos\n   - LinkedIn: https://www.linkedin.com/in/yaronbeen/\n=======================================\n"
      },
      "typeVersion": 1
    },
    {
      "id": "685fe958-0080-4d51-84bf-7679e6b85925",
      "name": "Note Adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1720,
        -340
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 1798,
        "content": "## 🌟 **Workflow: Market Gaps → SaaS Product Ideas → Google Sheet**\n\nThis n8n automation scrapes industry insights and converts them into real SaaS product ideas using AI — and then logs them in Google Sheets. It's fully automated, smart, and scalable.\n\n---\n\n## 🟩 **SECTION 1: Define What to Analyze**\n\n### 🔁 Nodes: `Schedule Trigger` + `Edit Fields`\n\n| 🔧 Node              | Name                          | Purpose                                                                                                                      |\n| -------------------- | ----------------------------- | ---------------------------------------------------------------------------------------------------------------------------- |\n| ⏰ `Schedule Trigger` | **Trigger: Run Weekly Check** | Starts this automation on a schedule (e.g., every Monday at 9 AM).                                                           |\n| 📝 `Edit Fields`     | **Set: Target Topic or URL**  | Manually input the industry, keyword, or trend you want to explore (like *\"AI in Healthcare\"* or *\"Sustainable Packaging\"*). |\n\n### 🧠 Beginner Tip:\n\n> This section is where **you control the topic**. You don’t need to write code — just input a keyword, and the system will go fetch all the useful insights for you later.\n\n---\n\n## 🟦 **SECTION 2: Discover Market Gaps with AI Agent**\n\n### 🧠 Node: `AI Agent`\n\nSub-nodes: `OpenAI Chat Model`, `MCP Client (Bright Data)`, `Structured Output Parser`\n\n| 🤖 Node                       | Name                             | Purpose                                                                                              |\n| ----------------------------- | -------------------------------- | ---------------------------------------------------------------------------------------------------- |\n| 🧠 `AI Agent`                 | **AI Agent: Analyze Market Gap** | Main node that coordinates the scraping and insight generation.                                      |\n| 🌐 `MCP Client`               | **Bright Data: Scraper Agent**   | Scrapes websites like Statista, Reddit, G2, etc., to find pain points, trends, and missing products. |\n| 🧠 `OpenAI Chat Model`        | **LLM: Insight Generator**       | Summarizes scraped data and identifies potential product opportunities using GPT.                    |\n| 🧾 `Structured Output Parser` | **Parser: JSON Output Builder**  | Converts messy AI output into clean, structured JSON (with product names and descriptions).          |\n\n### 🧠 Beginner Tip:\n\n> This is the **brain** of the workflow. It does the heavy lifting — finding real problems from real users, and then generating SaaS product ideas you can build. You don’t need to write the ideas — the AI will suggest them based on actual market gaps.\n\n---\n\n## 🟨 **SECTION 3: Break Into Pieces & Save to Google Sheets**\n\n### 🔧 Nodes: `Code` + `Google Sheets`\n\n| ⚙️ Node            | Name                              | Purpose                                                                                                        |\n| ------------------ | --------------------------------- | -------------------------------------------------------------------------------------------------------------- |\n| 🧩 `Code`          | **Code: Split Opportunities**     | Takes the structured list of SaaS ideas and splits it into individual items (so they can be saved one by one). |\n| 📄 `Google Sheets` | **Google Sheets: Log SaaS Ideas** | Automatically saves each product idea (name + description) into your connected spreadsheet.                    |\n\n### 🧠 Beginner Tip:\n\n> This is where all your hard work **gets stored**. Every week, your sheet grows with new SaaS ideas automatically — perfect for product research, newsletters, or startup launches.\n\n---\n\n## ✅ **End Result**\n\nAt the end of the workflow:\n\n* You get a list of *validated SaaS product ideas*.\n* Based on real-world gaps found in forums, review sites, and industry reports.\n* Neatly logged into Google Sheets without touching code.\n\n---\n\n### 💡 Bonus Ideas to Extend This:\n\n* 📧 **Send a weekly summary email** using the Email node.\n* 🔔 **Post ideas to Telegram or Slack** automatically.\n* 🧠 **Send ideas to Airtable or Notion** for team-wide collaboration.\n\n---\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "49e29106-4db0-4092-acc7-45b89c09925f",
      "name": "Analyseur de Sortie Auto-corrigeant",
      "type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
      "position": [
        700,
        280
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "fdd453af-d136-481f-8f36-df4ee81cee32",
      "name": "OpenAI Modèle de Chat",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        680,
        500
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8sEyPDkC5p4w4Jha",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cf5d6b3f-afeb-4eb4-b8a0-4b171c41418c",
      "name": "Analyseur de Sortie Structurée",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        840,
        500
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"productOpportunities\": [\n    {\n      \"name\": \"User Feedback Aggregation Tool\",\n      \"description\": \"Aggregates reviews from multiple platforms and provides actionable insights for startups.\"\n    },\n    {\n      \"name\": \"Community-Driven Ideation Platform\",\n      \"description\": \"A space for users to submit ideas and feature requests, forming a feedback loop for product teams.\"\n    },\n    {\n      \"name\": \"AI-Powered Market Research Tool\",\n      \"description\": \"Synthesizes forum posts, reviews, and social media feedback to identify emerging SaaS opportunities.\"\n    },\n    {\n      \"name\": \"SaaS Idea Validation Service\",\n      \"description\": \"Offers surveys and expert guidance to help entrepreneurs validate SaaS concepts before development.\"\n    },\n    {\n      \"name\": \"SaaS Development Accelerator\",\n      \"description\": \"An incubator offering mentorship, tools, and funding to help build and scale multiple SaaS projects.\"\n    },\n    {\n      \"name\": \"SaaS Maintenance and Refinement Tool\",\n      \"description\": \"Continuously analyzes live user feedback to help existing SaaS products evolve and remain competitive.\"\n    }\n  ]\n}"
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "2f546a0c-fb6b-44a7-a9ca-5be56e11973d",
  "connections": {
    "fdd453af-d136-481f-8f36-df4ee81cee32": {
      "ai_languageModel": [
        [
          {
            "node": "49e29106-4db0-4092-acc7-45b89c09925f",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "bfb80b71-c78b-46f5-a5a2-24911e747519": {
      "ai_languageModel": [
        [
          {
            "node": "4a88bcd9-e0ab-4fe1-a84b-29e6276d9812",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "d175072a-abba-4e05-8262-0a7991d1fc66": {
      "main": [
        [
          {
            "node": "4a88bcd9-e0ab-4fe1-a84b-29e6276d9812",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cf5d6b3f-afeb-4eb4-b8a0-4b171c41418c": {
      "ai_outputParser": [
        [
          {
            "node": "49e29106-4db0-4092-acc7-45b89c09925f",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "49e29106-4db0-4092-acc7-45b89c09925f": {
      "ai_outputParser": [
        [
          {
            "node": "4a88bcd9-e0ab-4fe1-a84b-29e6276d9812",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "589342ae-282d-47e9-9ec4-7df88812952e": {
      "main": [
        [
          {
            "node": "3e349bd0-3e28-4a09-b1df-4bac44406ede",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "149811e9-798b-413b-a159-5e07bb541fd0": {
      "main": [
        [
          {
            "node": "d175072a-abba-4e05-8262-0a7991d1fc66",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "630647dc-c0de-4165-a776-603de4c2aee3": {
      "ai_tool": [
        [
          {
            "node": "4a88bcd9-e0ab-4fe1-a84b-29e6276d9812",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "4a88bcd9-e0ab-4fe1-a84b-29e6276d9812": {
      "main": [
        [
          {
            "node": "589342ae-282d-47e9-9ec4-7df88812952e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}