Surveiller les sorties de produits concurrents

• •Compte Google et informations d'identification Gmail API
• •Informations d'identification Google Sheets API
• •Clé API OpenAI

{
  "id": "uYgR0foKaUfC5jnc",
  "meta": {
    "instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
    "templateCredsSetupCompleted": true
  },
  "name": "26 Monitor Competitor Product Launches",
  "tags": [],
  "nodes": [
    {
      "id": "4a5fffa9-521c-493a-83b1-0dce9f21ad07",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        400,
        260
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8sEyPDkC5p4w4Jha",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "811e3e3e-27b0-4a2c-b1ee-423e4945b2a9",
      "name": "Client MCP",
      "type": "n8n-nodes-mcp.mcpClientTool",
      "position": [
        580,
        260
      ],
      "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": "1caf6cda-6cdc-4a2a-88be-a19d4ee3db62",
      "name": "⏰ Vérification quotidienne (7h)",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -40,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 7
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "8cca72fa-6a09-42b5-93a7-3a5cd166fd5c",
      "name": "🛠 Définir la cible de scraping (Verge Reviews)",
      "type": "n8n-nodes-base.set",
      "position": [
        160,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "1b2cc621-f0c5-43e1-bcd4-72850ac2bc57",
              "name": "url",
              "type": "string",
              "value": "https://www.theverge.com/reviews"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "fa11746e-f206-4053-9709-863aa79f968c",
      "name": "🤖 Agent de scraping Bright Data",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        440,
        0
      ],
      "parameters": {
        "text": "=Use Bright Data Web Unlocker to scrape the latest product titles, release dates, and brief summaries from the following url.\n\nURL: {{ $json.url }}",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2
    },
    {
      "id": "db8d08ef-9521-4fc1-a8c9-96a1f848e7db",
      "name": "🧾 Séparer et formater chaque avis",
      "type": "n8n-nodes-base.code",
      "position": [
        900,
        0
      ],
      "parameters": {
        "jsCode": "// Sample input data from previous node\nconst items = $json[\"output\"];\n\n// Emit each review as a single item\nreturn items.map(review => {\n  return {\n    json: {\n      title: review.title,\n      url: \"https://www.theverge.com\" + review.url,\n      release_date: review.release_date,\n      summary: review.summary\n    }\n  };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "7d8d4349-8f85-42ce-9bf4-bf44da983838",
      "name": "📤 E-mail R&D : Alertes produits",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1200,
        0
      ],
      "webhookId": "f47cb615-dd7d-47f1-900e-f069ef22e344",
      "parameters": {
        "sendTo": "shahkar.genai@gmail.com",
        "message": "=🚀 New Product Launch Spotted!\n\n📦 Product: {{ $json.title }}\n🗓 Release Date: {{ $json.release_date }}\n📝 Summary: {{ $json.summary }}\n🔗 Read Full Review → {{ $json.url }}",
        "options": {},
        "subject": "=🆕 New Product Review: {{ $json.title }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "AQDSl75AdzK3vmqJ",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "886e4fd7-d455-4ff8-a1d2-599b36b1de84",
      "name": "📊 Journaliser dans Google Sheet (Historique des avis)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1400,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "URL": "={{ $('🧾 Split & Format Each Review').item.json.url }}",
            "TItle": "={{ $('🧾 Split & Format Each Review').item.json.title }}",
            "Summary": "={{ $('🧾 Split & Format Each Review').item.json.summary }}",
            "Release date": "={{ $('🧾 Split & Format Each Review').item.json.release_date }}"
          },
          "schema": [
            {
              "id": "TItle",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "TItle",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Release date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Release date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "URL",
              "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/1Q6QXNKq7hFBQ18oiJwbhaOGxZqI22-rlL-Wahtxprf4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Q6QXNKq7hFBQ18oiJwbhaOGxZqI22-rlL-Wahtxprf4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Q6QXNKq7hFBQ18oiJwbhaOGxZqI22-rlL-Wahtxprf4/edit?usp=drivesdk",
          "cachedResultName": "Product Launches"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "r2mDaisH6e9VkwHl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "49d63a3e-ba19-4832-a3e0-804b0b7cda1f",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -1020
      ],
      "parameters": {
        "color": 2,
        "width": 380,
        "height": 1200,
        "content": "## 🔶 **SECTION 1: Schedule & Scrape Target Configuration**\n\n🧩 **Nodes:**\n\n* ⏰ `Daily Check (7AM)`\n* 🛠 `Set Scrape Target (Verge Reviews)`\n\n---\n\n### 🧠 What’s Happening:\n\nThis section controls **when** and **what** to scrape.\n\n#### ⏰ `Schedule Trigger`\n\n* Automatically runs the workflow **every morning at 7AM**.\n* No manual checking needed!\n\n#### 🛠 `Edit Fields`\n\n* Sets the target scraping page:\n  `https://www.theverge.com/reviews`\n* You can easily switch this to other competitor sites (like TechCrunch or Wired) later.\n\n---\n\n### 💡 Why it matters:\n\nThis is where you **customize your intelligence source**. Just change the URL or keyword once — no coding needed.\n\n---\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "538873a8-6b8c-4d4c-8f18-76f06608766f",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -1260
      ],
      "parameters": {
        "color": 3,
        "width": 340,
        "height": 1440,
        "content": "## 🤖 **SECTION 2: Agent-Powered Scraping with Bright Data**\n\n🧩 **Node:**\n\n* 🤖 `Bright Data Scraper Agent`\n  🔗 Sub-nodes:\n* 🔮 OpenAI Chat Model\n* 🧩 MCP Client (Bright Data Tool)\n* 📦 Structured Output Parser\n\n---\n\n### 🧠 What’s Happening:\n\nThis is the **heart of the automation** — using a powerful AI agent connected to Bright Data’s scraping infrastructure.\n\n#### 🤖 `AI Agent`\n\n* Uses an **OpenAI agent** that understands your instructions.\n* Connects to **Bright Data MCP** to bypass anti-bot systems and extract clean product data.\n* Scrapes:\n\n  * 📦 Product Title\n  * 📅 Release Date\n  * 📝 Short Summary\n  * 🔗 URL (relative, so we'll fix that later)\n\n#### 📦 `Structured Output Parser`\n\n* Parses the AI agent’s response into structured JSON — ready for automation.\n\n---\n\n### 💡 Why it matters:\n\nEven a beginner can now use **AI + Bright Data** to scrape dynamic sites that normally block scrapers.\n\n---\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "4d739fed-0ccb-4d24-ab57-a15a98cbfcdc",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        820,
        -1280
      ],
      "parameters": {
        "color": 6,
        "width": 260,
        "height": 1460,
        "content": "## 🧾 **SECTION 3: Split & Format Each Review**\n\n🧩 **Node:**\n\n* 🧾 `Split & Format Each Review`\n\n---\n\n### 🧠 What’s Happening:\n\nThis Code Node takes the array of product reviews and **splits them into one item each**.\n\n#### Code Features:\n\n* Converts relative URLs to full links (e.g., `/xyz` → `https://www.theverge.com/xyz`)\n* Outputs 10 clean JSON objects, one per review.\n\n```javascript\nreturn items.map(review => {\n  return {\n    json: {\n      title: review.title,\n      url: \"https://www.theverge.com\" + review.url,\n      release_date: review.release_date,\n      summary: review.summary\n    }\n  };\n});\n```\n\n---\n\n### 💡 Why it matters:\n\nThis lets you send **individual emails** and store **individual entries** — great for reporting, filtering, and team alerts.\n\n---\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "1f97d84b-4459-4ad2-985f-41cf54736d88",
      "name": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1160,
        -1260
      ],
      "parameters": {
        "color": 5,
        "width": 380,
        "height": 1440,
        "content": "## ✉️📊 **SECTION 4: Notify & Log the Insights**\n\n🧩 **Nodes:**\n\n* ✉️ `Email R&D: Product Alerts`\n* 📄 `Log to Google Sheet (Review History)`\n\n---\n\n### 🧠 What’s Happening:\n\nNow that the data is cleaned and structured, we act on it:\n\n#### ✉️ Gmail Node\n\n* Sends **one beautiful email per product** to the R\\&D team.\n* Contains:\n\n  * Product title\n  * Release date\n  * Summary\n  * Link to full article\n* Uses HTML formatting for clarity.\n\n#### 📄 Google Sheets Node\n\n* Appends each product to a sheet.\n* Serves as a **history log** to:\n\n  * Track past launches\n  * Prevent duplicate alerts\n  * Enable analysis later\n\n---\n\n### 💡 Why it matters:\n\nYour R\\&D team gets **instant alerts** about what competitors are launching — and you get a **central record** to refer to anytime.\n\n---\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "63166a87-d9a0-48bf-8e93-e36530596a68",
      "name": "Note adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1620,
        -1260
      ],
      "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": "16610325-42f6-4838-83f0-82226303a119",
      "name": "Note adhésive9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1780,
        -1020
      ],
      "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": "4dc735bf-5798-429b-904a-9819457ce281",
      "name": "Note adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1780,
        -680
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 3978,
        "content": "# 🛠️ Monitor Competitor Product Launches (The Verge)\n\n> 🔄 Automated n8n workflow using Bright Data MCP to scrape reviews & notify R\\&D team\n\n---\n\n## 🔶 **SECTION 1: Schedule & Scrape Target Configuration**\n\n🧩 **Nodes:**\n\n* ⏰ `Daily Check (7AM)`\n* 🛠 `Set Scrape Target (Verge Reviews)`\n\n---\n\n### 🧠 What’s Happening:\n\nThis section controls **when** and **what** to scrape.\n\n#### ⏰ `Schedule Trigger`\n\n* Automatically runs the workflow **every morning at 7AM**.\n* No manual checking needed!\n\n#### 🛠 `Edit Fields`\n\n* Sets the target scraping page:\n  `https://www.theverge.com/reviews`\n* You can easily switch this to other competitor sites (like TechCrunch or Wired) later.\n\n---\n\n### 💡 Why it matters:\n\nThis is where you **customize your intelligence source**. Just change the URL or keyword once — no coding needed.\n\n---\n\n## 🤖 **SECTION 2: Agent-Powered Scraping with Bright Data**\n\n🧩 **Node:**\n\n* 🤖 `Bright Data Scraper Agent`\n  🔗 Sub-nodes:\n* 🔮 OpenAI Chat Model\n* 🧩 MCP Client (Bright Data Tool)\n* 📦 Structured Output Parser\n\n---\n\n### 🧠 What’s Happening:\n\nThis is the **heart of the automation** — using a powerful AI agent connected to Bright Data’s scraping infrastructure.\n\n#### 🤖 `AI Agent`\n\n* Uses an **OpenAI agent** that understands your instructions.\n* Connects to **Bright Data MCP** to bypass anti-bot systems and extract clean product data.\n* Scrapes:\n\n  * 📦 Product Title\n  * 📅 Release Date\n  * 📝 Short Summary\n  * 🔗 URL (relative, so we'll fix that later)\n\n#### 📦 `Structured Output Parser`\n\n* Parses the AI agent’s response into structured JSON — ready for automation.\n\n---\n\n### 💡 Why it matters:\n\nEven a beginner can now use **AI + Bright Data** to scrape dynamic sites that normally block scrapers.\n\n---\n\n## 🧾 **SECTION 3: Split & Format Each Review**\n\n🧩 **Node:**\n\n* 🧾 `Split & Format Each Review`\n\n---\n\n### 🧠 What’s Happening:\n\nThis Code Node takes the array of product reviews and **splits them into one item each**.\n\n#### Code Features:\n\n* Converts relative URLs to full links (e.g., `/xyz` → `https://www.theverge.com/xyz`)\n* Outputs 10 clean JSON objects, one per review.\n\n```javascript\nreturn items.map(review => {\n  return {\n    json: {\n      title: review.title,\n      url: \"https://www.theverge.com\" + review.url,\n      release_date: review.release_date,\n      summary: review.summary\n    }\n  };\n});\n```\n\n---\n\n### 💡 Why it matters:\n\nThis lets you send **individual emails** and store **individual entries** — great for reporting, filtering, and team alerts.\n\n---\n\n## ✉️📊 **SECTION 4: Notify & Log the Insights**\n\n🧩 **Nodes:**\n\n* ✉️ `Email R&D: Product Alerts`\n* 📄 `Log to Google Sheet (Review History)`\n\n---\n\n### 🧠 What’s Happening:\n\nNow that the data is cleaned and structured, we act on it:\n\n#### ✉️ Gmail Node\n\n* Sends **one beautiful email per product** to the R\\&D team.\n* Contains:\n\n  * Product title\n  * Release date\n  * Summary\n  * Link to full article\n* Uses HTML formatting for clarity.\n\n#### 📄 Google Sheets Node\n\n* Appends each product to a sheet.\n* Serves as a **history log** to:\n\n  * Track past launches\n  * Prevent duplicate alerts\n  * Enable analysis later\n\n---\n\n### 💡 Why it matters:\n\nYour R\\&D team gets **instant alerts** about what competitors are launching — and you get a **central record** to refer to anytime.\n\n---\n\n## 🎯 Final Thoughts\n\nEven if you’re a complete beginner:\n\n* You don’t need to write code (just paste small pieces).\n* You’re scraping dynamic sites legally & cleanly via Bright Data.\n* You’re using AI + n8n to automate competitive intelligence.\n\n---\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "b734d682-96ea-4a55-8bfd-1ee0a54fee25",
      "name": "Analyseur de sortie auto-corrigeant",
      "type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
      "position": [
        720,
        260
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "12810685-db1c-41b4-a45b-75eb17e62837",
      "name": "OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        700,
        480
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8sEyPDkC5p4w4Jha",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "76e60d57-1853-45ab-809c-457d8f425765",
      "name": "Analyseur de sortie structurée1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        860,
        480
      ],
      "parameters": {
        "jsonSchemaExample": "[\n  {\n    \"title\": \"The best earbuds we’ve tested for 2025\",\n    \"url\": \"https://www.theverge.com/21309820/best-wireless-earbuds\",\n    \"release_date\": \"2025-07-04\",\n    \"summary\": \"This review highlights the best earbuds from brands like Apple, Bose, Samsung, and Sony, suited for various preferences.\"\n  },\n  {\n    \"title\": \"The Loop Micro is my new favorite bicycle phone mount\",\n    \"url\": \"https://www.theverge.com/reviews/697356/loop-micro-best-bike-mount-review\",\n    \"release_date\": \"2025-07-04\",\n    \"summary\": \"The Loop Micro is praised for its design and functionality, ideally suited for cyclists wanting to mount their phones securely.\"\n  },\n  {\n    \"title\": \"The best robot vacuum and mop to buy right now\",\n    \"url\": \"https://www.theverge.com/tech/625409/best-robot-vacuum-mops\",\n    \"release_date\": \"2025-07-03\",\n    \"summary\": \"A comparison of the top robot vacuum and mop combos available, offering insights on their cleaning capabilities.\"\n  },\n  {\n    \"title\": \"Whoop MG review: a big whoop for a small crowd\",\n    \"url\": \"https://www.theverge.com/fitness-tracker-review/696156/whoop-mg-review-wearables-fitness-tracker-health\",\n    \"release_date\": \"2025-07-03\",\n    \"summary\": \"The Whoop MG wearable is evaluated, targeting athletes specifically, and the review discusses its features and effectiveness.\"\n  },\n  {\n    \"title\": \"Nothing Headphone 1 review: head-turning\",\n    \"url\": \"https://www.theverge.com/headphone-review/695609/nothing-headphone-1-review\",\n    \"release_date\": \"2025-07-01\",\n    \"summary\": \"This review assesses the Nothing Headphone 1, exploring its design and tech, and notes its distinctive style among Bluetooth headphones.\"\n  }\n]\n"
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "2c5d01ae-eba8-436c-9982-8c1af7540427",
  "connections": {
    "811e3e3e-27b0-4a2c-b1ee-423e4945b2a9": {
      "ai_tool": [
        [
          {
            "node": "fa11746e-f206-4053-9709-863aa79f968c",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "4a5fffa9-521c-493a-83b1-0dce9f21ad07": {
      "ai_languageModel": [
        [
          {
            "node": "fa11746e-f206-4053-9709-863aa79f968c",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "12810685-db1c-41b4-a45b-75eb17e62837": {
      "ai_languageModel": [
        [
          {
            "node": "b734d682-96ea-4a55-8bfd-1ee0a54fee25",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "1caf6cda-6cdc-4a2a-88be-a19d4ee3db62": {
      "main": [
        [
          {
            "node": "8cca72fa-6a09-42b5-93a7-3a5cd166fd5c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b734d682-96ea-4a55-8bfd-1ee0a54fee25": {
      "ai_outputParser": [
        [
          {
            "node": "fa11746e-f206-4053-9709-863aa79f968c",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "76e60d57-1853-45ab-809c-457d8f425765": {
      "ai_outputParser": [
        [
          {
            "node": "b734d682-96ea-4a55-8bfd-1ee0a54fee25",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "7d8d4349-8f85-42ce-9bf4-bf44da983838": {
      "main": [
        [
          {
            "node": "886e4fd7-d455-4ff8-a1d2-599b36b1de84",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fa11746e-f206-4053-9709-863aa79f968c": {
      "main": [
        [
          {
            "node": "db8d08ef-9521-4fc1-a8c9-96a1f848e7db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "db8d08ef-9521-4fc1-a8c9-96a1f848e7db": {
      "main": [
        [
          {
            "node": "7d8d4349-8f85-42ce-9bf4-bf44da983838",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8cca72fa-6a09-42b5-93a7-3a5cd166fd5c": {
      "main": [
        [
          {
            "node": "fa11746e-f206-4053-9709-863aa79f968c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}