Describe the problem/error/question: I setup a workflow with multiple nodes. The entire flow works, except for the openai get node.
What is the error message (if any)?Problem in node ‘Get Recent/Growth/Milestones.‘
The service is receiving too many requests from you
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
{
"nodes": [
{
"parameters": {
"url": "={{ $json.URL }}",
"options": {}
},
"id": "3183b1b7-4f3d-42af-90a8-9d06cd65a04c",
"name": "Scrape Company Website",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
608,
0
],
"onError": "continueRegularOutput",
"notes": "https://{{ $('Extract Company URL').item.json.text }}"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gpt-5",
"mode": "list",
"cachedResultName": "GPT-5"
},
"messages": {
"values": [
{
"content": "You are an expert in extracting and analyzing business information from website data. Your role is to interpret the scraped content from a company’s homepage to identify key elements such as testimonials, recent growth, and success stories. Your responses must be concise, structured, and fully aligned with the provided input, avoiding assumptions or unsupported details. Deliver actionable and professional insights that directly address the requested categories, ensuring clarity and relevance in your output.",
"role": "system"
},
{
"content": "=Analyze the following data scraped from a company's homepage. \n\nExtract and organize the following information:\n\nTestimonials: Identify any customer reviews, client quotes, or feedback, and present them as a list.\n\nRecent Growth: Highlight any mentions of company milestones, achievements, or performance metrics (e.g., revenue growth, customer acquisition numbers, product launches).\n\nSuccess Stories: Extract examples or case studies of how the company has helped its clients, showcasing measurable results or significant impacts.\n\nEnsure the output is structured clearly under the headings Testimonials, Recent Growth, and Success Stories, and only include relevant content. \n\nIf no information for a category is found, leave that section empty."
},
{
"content": "={{ $json.plainText }}"
}
]
},
"options": {}
},
"id": "8524779f-5b49-491b-9355-030fe29c18c1",
"name": "Get Recent/Growth/Milestones.",
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 1.7,
"position": [
1184,
0
],
"credentials": {
"openAiApi": {
"id": "uKrBjCb0BtztFkSD",
"name": "OpenAi account"
}
}
},
{
"parameters": {
"promptType": "define",
"text": "=\nResult: {{ $json.message.content }}",
"hasOutputParser": true,
"messages": {
"messageValues": [
{
"message": "=You are my cold email expert. Your task is to create a personalized line that we can use in the cold email. Use the results we have found for this. You can find them here: {{ $json.message.content }}\n\nOutput ONLY the full cold email.\n\nStart the line with something like: \"Great to see that...\"\n\nIf no results are found, use {{ $('Remove HTML,2').item.json.plainText }} to create a short sentence about the company itself.\n\nThen, incorporate this personalized line into the following cold email template:\n\nSubject: Quick question\n\nHi {{ $('Google Sheets1').item.json.Firstname }},\n\n[Personalized line]\n\nI noticed [something relevant about their company or role]. We help companies like yours [achieve a specific result / solve a specific problem] using [your solution].\n\nWould you be open to a 15-minute chat next week to see if this could be a fit?\n\nBest regards,\n[Your Name]\n[Your Company]\n[Contact Info]\n\n"
}
]
}
},
"id": "6d31a26c-6756-4a5e-83d9-83be7108fb89",
"name": "Write Cold Email",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"typeVersion": 1.4,
"position": [
1648,
0
]
},
{
"parameters": {
"model": "anthropic/claude-3.5-sonnet-20240620",
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"typeVersion": 1,
"position": [
1584,
208
],
"id": "18845132-2e9b-40df-86b1-5836e15765af",
"name": "OpenRouter Chat Model",
"credentials": {
"openRouterApi": {
"id": "8wgZRHePAqb2g3J4",
"name": "OpenRouter account"
}
}
},
{
"parameters": {
"jsCode": "const htmlContent = $node[\"Scrape Company Website\"].json[\"data\"]; // Replace this with the field containing your HTML content\n\n// Function to strip HTML tags and clean the text\nconst extractPlainText = (html) => {\n if (!html) return \"\";\n\n // Remove script and style tags along with their content\n const withoutScriptsAndStyles = html.replace(/<script[\\s\\S]*?>[\\s\\S]*?<\\/script>/gi, \"\")\n .replace(/<style[\\s\\S]*?>[\\s\\S]*?<\\/style>/gi, \"\");\n\n // Remove all remaining HTML tags\n const strippedText = withoutScriptsAndStyles.replace(/<\\/?[^>]+(>|$)/g, \"\");\n\n // Replace HTML entities with their plain-text equivalents\n const decodedText = strippedText.replace(/ /gi, \" \")\n .replace(/&/gi, \"&\")\n .replace(/</gi, \"<\")\n .replace(/>/gi, \">\")\n .replace(/"/gi, \"\\\"\")\n .replace(/'/gi, \"'\");\n\n // Replace multiple spaces, tabs, and newlines with a single space\n const cleanedText = decodedText.replace(/\\s+/g, \" \").trim();\n\n return cleanedText;\n};\n\n// Call the function to process the HTML content\nconst plainText = extractPlainText(htmlContent);\n\n// Return the plain text as the output of this node\nreturn {\n plainText: plainText,\n};"
},
"id": "fc1d2422-81a8-45c4-84ca-2cb64395232f",
"name": "Remove HTML,2",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
896,
0
]
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "198eMjCkLg2_ASMIl278HTGQeo3y52Je3PhhQIV6Oj_g",
"mode": "list",
"cachedResultName": "n8n Leads",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/198eMjCkLg2_ASMIl278HTGQeo3y52Je3PhhQIV6Oj_g/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/198eMjCkLg2_ASMIl278HTGQeo3y52Je3PhhQIV6Oj_g/edit#gid=0"
},
"filtersUI": {
"values": [
{
"lookupColumn": "Cold email"
}
]
},
"options": {
"returnFirstMatch": true
}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
256,
0
],
"id": "ac2308a6-e2d1-4277-a99b-26bfa45cad79",
"name": "Google Sheets1",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "xisOpBQ8sxw2yDrb",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1XSjmvbYrf7j4i6gV6iZC31Z6jLjNTrxnde8wwhYLEGY",
"mode": "list",
"cachedResultName": "Leads",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XSjmvbYrf7j4i6gV6iZC31Z6jLjNTrxnde8wwhYLEGY/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Blad1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XSjmvbYrf7j4i6gV6iZC31Z6jLjNTrxnde8wwhYLEGY/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Email": "={{ $('Google Sheets1').item.json.Email }}",
"Cold email": "={{ $json.text }}"
},
"matchingColumns": [
"Email"
],
"schema": [
{
"id": "Firstname",
"displayName": "Firstname",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Lastname",
"displayName": "Lastname",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Email",
"displayName": "Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Company name",
"displayName": "Company name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "URL",
"displayName": "URL",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Cold email",
"displayName": "Cold email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
2048,
0
],
"id": "867133b4-2a22-4c8a-8027-63d19e2ea168",
"name": "Google Sheets2",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "xisOpBQ8sxw2yDrb",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "seconds",
"secondsInterval": 15
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
0,
0
],
"id": "01bad4cf-e314-4c1b-a52e-da1f9ff3d31b",
"name": "Schedule Trigger"
}
],
"connections": {
"Scrape Company Website": {
"main": [
[
{
"node": "Remove HTML,2",
"type": "main",
"index": 0
}
]
]
},
"Get Recent/Growth/Milestones.": {
"main": [
[
{
"node": "Write Cold Email",
"type": "main",
"index": 0
}
]
]
},
"Write Cold Email": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
},
"OpenRouter Chat Model": {
"ai_languageModel": [
[
{
"node": "Write Cold Email",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Remove HTML,2": {
"main": [
[
{
"node": "Get Recent/Growth/Milestones.",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Scrape Company Website",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"meta": {
"instanceId": "740ea2b53311400412819714ee98892fa758d60e2eb16326765c18cdea046a78"
}
}
Share the output returned by the last node
Information on your n8n setup
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
- Operating system: Windows 11 home