Resumen de sitio web

• •Credenciales de API de Google Sheets
• •Clave de API de OpenAI

{
  "id": "4CnUOZExvXMQTGEB",
  "meta": {
    "instanceId": "159ec2e1d690fe685084d28de8ca73848642bf563457a19b94cfc00f23a0d9a9",
    "templateCredsSetupCompleted": true
  },
  "name": "Website Summary",
  "tags": [],
  "nodes": [
    {
      "id": "6791eccd-206f-46db-b2a0-fd22eddcbaab",
      "name": "Activador Manual",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -992,
        -80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "de262216-3632-44fa-8095-51b2890a2bff",
      "name": "Dar forma a la salida (Editar Campos)",
      "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": "Esperar 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": "Finalizado",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -400,
        128
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0aba365a-c78e-4746-b486-3d82247f3bde",
      "name": "Personalizar Mensaje",
      "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": "Actualizar hoja con mensaje personalizado",
      "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": "Obtener URL del sitio web desde la hoja",
      "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": "Bucle sobre URLs",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -512,
        -80
      ],
      "parameters": {
        "options": {},
        "batchSize": 1
      },
      "typeVersion": 2
    },
    {
      "id": "d0ee57fd-c057-4cfb-af2f-91d6fbb0fc74",
      "name": "Rastrear sitio web y obtener su contenido",
      "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": "Nota Adhesiva",
      "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": "Nota Adhesiva1",
      "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": "Nota Adhesiva2",
      "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
          }
        ]
      ]
    }
  }
}