Résumé de site web

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

{
  "id": "4CnUOZExvXMQTGEB",
  "meta": {
    "instanceId": "159ec2e1d690fe685084d28de8ca73848642bf563457a19b94cfc00f23a0d9a9",
    "templateCredsSetupCompleted": true
  },
  "name": "Website Summary",
  "tags": [],
  "nodes": [
    {
      "id": "6791eccd-206f-46db-b2a0-fd22eddcbaab",
      "name": "Déclencheur Manuel",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -992,
        -80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "de262216-3632-44fa-8095-51b2890a2bff",
      "name": "Sortie de forme (Modifier les champs)",
      "type": "n8n-nodes-base.set",
      "position": [
        272,
        -80
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "message",
              "name": "Personalized Message",
              "type": "string",
              "value": "={{ $json.message.content }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "13509a29-9641-4cb7-a100-322dbcf18efc",
      "name": "Attendre 2s",
      "type": "n8n-nodes-base.wait",
      "position": [
        512,
        -16
      ],
      "webhookId": "53b8c837-5c7a-4b3b-af33-708f7dacda47",
      "parameters": {
        "unit": "seconds",
        "amount": 2
      },
      "typeVersion": 1
    },
    {
      "id": "14b1b895-6a33-4f82-8222-5375bbafbe89",
      "name": "Terminé",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -400,
        128
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0aba365a-c78e-4746-b486-3d82247f3bde",
      "name": "Personnaliser le message",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -96,
        -80
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "chatgpt-4o-latest",
          "cachedResultName": "CHATGPT-4O-LATEST"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=You analyze an organization’s website content here: {{ $json.data.markdown }}\n\nand produce concise, credible sales intelligence for pitching AI services.\n\nRequirements:\n- Be specific and grounded in the supplied content (title, meta, H1s, text snippet). Do not invent facts.\n- No buzzwords (avoid: leverage, synergies, cutting-edge, game-changing, etc.).\n- Tone: consultative, earnest, respectful; no hype; no exclamation points.\n- If a contact name is provided, greet or reference them by first name in the pitch once, naturally.\n- If content is thin, infer cautiously from title/meta/H1s and acknowledge limits.\n\nOutput format (plain text, exactly this structure):\nContext:\n• 2–4 bullets on what they do, who they serve, and any pain/initiative AI could help with (explicit, concrete).\nPitch:\nOne paragraph (70–110 words) proposing how AI/automation could help them, referencing 1–2 specifics from the site, ending with a single next-step question. "
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "qiPWoGhtEMQi7AWs",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "f8c9563f-4095-43d6-af90-31ed79b2e57e",
      "name": "Mettre à jour la feuille avec le message personnalisé",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        704,
        176
      ],
      "parameters": {
        "columns": {
          "value": {
            "Personalized Message": "={{ $('Shape output (Edit Fields)').item.json['Personalized Message'] }}"
          },
          "schema": [
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Personalized Message",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Personalized Message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Personalized Message"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04/edit?usp=drivesdk",
          "cachedResultName": "Websites"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "sUuiWu6oknUOYMCR",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "5dd11818-b2ec-4d17-b3af-7c3640f10b4d",
      "name": "Récupérer l'URL du site web depuis la feuille",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -784,
        -80
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04/edit?usp=drivesdk",
          "cachedResultName": "Websites"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "sUuiWu6oknUOYMCR",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "a491869d-1446-40bf-b997-db77a5898534",
      "name": "Boucler sur les URLs",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -512,
        -80
      ],
      "parameters": {
        "options": {},
        "batchSize": 1
      },
      "typeVersion": 2
    },
    {
      "id": "d0ee57fd-c057-4cfb-af2f-91d6fbb0fc74",
      "name": "Extraire le site web et obtenir son contenu",
      "type": "@mendable/n8n-nodes-firecrawl.firecrawl",
      "position": [
        -288,
        -80
      ],
      "parameters": {
        "url": "={{ $json.Website }}",
        "operation": "scrape",
        "scrapeOptions": {
          "options": {
            "formats": [
              "markdown",
              "screenshot"
            ],
            "headers": {}
          }
        },
        "requestOptions": {}
      },
      "credentials": {
        "firecrawlApi": {
          "id": "6t52jAuk3BVEroC5",
          "name": "Firecrawl account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "b8aed690-0f39-4886-a80a-4ad918a5c835",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -896,
        -400
      ],
      "parameters": {
        "width": 352,
        "height": 304,
        "content": "Upon being triggered, this first step is going to fetch all URLs from your spreadsheet. Each URL should be in a  new row.\n\nSpreadsheet setup:\n- column 1 = website\n- column 2 = personalized message\n\nPre-requisites:\n- Create your spreadsheet in your Google Drive with the appropriate columns\n- Add your Google credentials to n8n: "
      },
      "typeVersion": 1
    },
    {
      "id": "3c22c785-ac6c-4ec7-aa13-8d6e65474bfa",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -224,
        -416
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 304,
        "content": "This is where the meat of things happens. The automation will loop over each website, using Firecrawl to perform the scrape. It will pass that content into your LLM (chatGPT in this case) to perform the personalization. Adjust the prompt as needed for your organization's context and what will be helpful for your personalized outreach\n\nPre-requisites:\n- Firecrawl account and API key\n- OpenAI credentials\n"
      },
      "typeVersion": 1
    },
    {
      "id": "59b808d0-d10f-4c96-9215-6da972cdb09c",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        384
      ],
      "parameters": {
        "color": 5,
        "width": 272,
        "height": 80,
        "content": "Your message will get mapped to the appropriate column in the spreadsheet"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "7a55ee84-18ab-4a3b-a18b-49c4aeff424e",
  "connections": {
    "13509a29-9641-4cb7-a100-322dbcf18efc": {
      "main": [
        [
          {
            "node": "f8c9563f-4095-43d6-af90-31ed79b2e57e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a491869d-1446-40bf-b997-db77a5898534": {
      "main": [
        [
          {
            "node": "d0ee57fd-c057-4cfb-af2f-91d6fbb0fc74",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "14b1b895-6a33-4f82-8222-5375bbafbe89",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6791eccd-206f-46db-b2a0-fd22eddcbaab": {
      "main": [
        [
          {
            "node": "5dd11818-b2ec-4d17-b3af-7c3640f10b4d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0aba365a-c78e-4746-b486-3d82247f3bde": {
      "main": [
        [
          {
            "node": "de262216-3632-44fa-8095-51b2890a2bff",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de262216-3632-44fa-8095-51b2890a2bff": {
      "main": [
        [
          {
            "node": "13509a29-9641-4cb7-a100-322dbcf18efc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5dd11818-b2ec-4d17-b3af-7c3640f10b4d": {
      "main": [
        [
          {
            "node": "a491869d-1446-40bf-b997-db77a5898534",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d0ee57fd-c057-4cfb-af2f-91d6fbb0fc74": {
      "main": [
        [
          {
            "node": "0aba365a-c78e-4746-b486-3d82247f3bde",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f8c9563f-4095-43d6-af90-31ed79b2e57e": {
      "main": [
        [
          {
            "node": "a491869d-1446-40bf-b997-db77a5898534",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}