L’automatisation des campagnes marketing permet la segmentation, la diffusion ciblée, l’analyse des résultats et l’ajustement en temps réel, augmentant le ROI et la notoriété de la marque.
L’automatisation des campagnes marketing permet la segmentation, la diffusion ciblée, l’analyse des résultats et l’ajustement en temps réel, augmentant le ROI et la notoriété de la marque.
{
"meta": {
"instanceId": "d4d7965840e96e50a3e02959a8487c692901dfa8d5cc294134442c67ce1622d3",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "5d02237f-151b-4bb4-9341-b11149925309",
"name": "When clicking u2018Test workflowu2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-980,
-40
],
"parameters": {},
"typeVersion": 1
},
{
"id": "dc60bffa-b6f8-432d-85ed-0d08f092a454",
"name": "Filter",
"type": "n8n-nodes-base.filter",
"position": [
-20,
-220
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3b4c2e25-862d-4b4e-aa66-38c5f0e5a7b2",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json['urlset.url']['news:news']['news:title'] }}",
"rightValue": "raise"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "f779a004-57f6-451b-984b-3fd9517e4842",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1900,
100
],
"parameters": {
"jsonSchemaExample": "{nt"website_url": "https://example.com"n}"
},
"typeVersion": 1.2
},
{
"id": "adcffd7e-943e-488f-a11b-0b64e45c6ff6",
"name": "Perplexity",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
1380,
100
],
"parameters": {
"model": "perplexity/llama-3.1-sonar-small-128k-online",
"options": {}
},
"credentials": {
"openRouterApi": {
"id": "Wz9uIFEMzOmhbt1D",
"name": "OpenRouter account"
}
},
"typeVersion": 1
},
{
"id": "0c90db72-bbd0-4f8c-bf9e-6005dc99344f",
"name": "Filter1",
"type": "n8n-nodes-base.filter",
"position": [
-20,
120
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3b4c2e25-862d-4b4e-aa66-38c5f0e5a7b2",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.loc }}",
"rightValue": "raise"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "f770791d-a987-4509-b8fc-648f31deda88",
"name": "Extract Structured Data ",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
960,
-60
],
"parameters": {
"text": "=Article Title: {{ $json.title }}nArticle Text:{{ $json.text }}",
"options": {},
"attributes": {
"attributes": [
{
"name": "company_name",
"description": "What is the company called"
},
{
"name": "funding_round",
"description": "Seed, Series A,B,C,D etc."
},
{
"name": "funding_amount",
"type": "number",
"description": "How much is the amount of the funding round - full numbers please"
},
{
"name": "lead_investor",
"description": "Who is leading the funding round"
},
{
"name": "market",
"description": "In which market is the company operating"
},
{
"name": "participating_investors",
"description": "Comma separated list of other participating investors"
},
{
"name": "press_release_url",
"description": "The URL to the original press release "
},
{
"name": "evaluation",
"type": "number",
"description": "How high is the evaluation of the company - full numbers please"
}
]
}
},
"typeVersion": 1
},
{
"id": "370e4875-a95b-4736-b500-7427dd6b9e57",
"name": "Research URL",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1300,
-60
],
"parameters": {
"text": "=Find the website for this company: {{ $json.output.company_name }}",
"promptType": "define"
},
"typeVersion": 1.5
},
{
"id": "6d0cd072-f97f-466b-8e11-c2affad19a3f",
"name": "Extract URL",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1680,
-60
],
"parameters": {
"text": "={{ $json.text }}",
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.5
},
{
"id": "196cca20-66f0-4732-a36b-235606700bd4",
"name": "Merge Extracted Data",
"type": "n8n-nodes-base.merge",
"position": [
720,
-60
],
"parameters": {},
"typeVersion": 3
},
{
"id": "a7063f58-6eaa-4248-b9e9-6f6cc3551d24",
"name": "Split TC Articles",
"type": "n8n-nodes-base.splitOut",
"position": [
-160,
-220
],
"parameters": {
"include": "=",
"options": {},
"fieldToSplitOut": "urlset.url"
},
"typeVersion": 1
},
{
"id": "2bfebd7a-3f63-4206-9de0-1053b8e760da",
"name": "TC HTML Parser",
"type": "n8n-nodes-base.html",
"position": [
440,
-220
],
"parameters": {
"options": {
"cleanUpText": true
},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "text",
"cssSelector": ".wp-block-post-content"
},
{
"key": "title",
"cssSelector": ".wp-block-post-title"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "2c52fc2d-42bc-4f62-8157-ff0cece23d48",
"name": "Split VB Articles",
"type": "n8n-nodes-base.splitOut",
"position": [
-160,
120
],
"parameters": {
"options": {},
"fieldToSplitOut": "urlset.url"
},
"typeVersion": 1
},
{
"id": "b9fd414c-70a8-40b0-bb1a-b499b7be5ff5",
"name": "VB HTML Parser",
"type": "n8n-nodes-base.html",
"position": [
440,
120
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "text",
"cssSelector": "#content"
},
{
"key": "title",
"cssSelector": ".article-title"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "67825bec-b689-4257-a421-0446884b918e",
"name": "Venturebeat (VB)",
"type": "n8n-nodes-base.httpRequest",
"position": [
-640,
120
],
"parameters": {
"url": "https://venturebeat.com/news-sitemap.xml",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "68d1f94b-89c1-4d00-8400-475722ff8a0f",
"name": "Techcrunch (TC)",
"type": "n8n-nodes-base.httpRequest",
"position": [
-640,
-220
],
"parameters": {
"url": "https://techcrunch.com/news-sitemap.xml",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "30a62f02-089b-4d10-ae6f-6f19119934c2",
"name": "Claude 3.5 Sonnet",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
1060,
100
],
"parameters": {
"model": "claude-3-5-sonnet-20241022",
"options": {}
},
"credentials": {
"anthropicApi": {
"id": "IuDNko14nN79w51k",
"name": "Anthropic account 2"
}
},
"typeVersion": 1.2
},
{
"id": "6e8453ba-ac37-4e10-bb50-df92d3d342a1",
"name": "Claude 3.5 Haiku",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
1740,
100
],
"parameters": {
"model": "claude-3-5-haiku-20241022",
"options": {}
},
"credentials": {
"anthropicApi": {
"id": "IuDNko14nN79w51k",
"name": "Anthropic account 2"
}
},
"typeVersion": 1.2
},
{
"id": "2bb5b903-c08d-4231-962b-7c56616b4f1e",
"name": "Collect Data",
"type": "n8n-nodes-base.set",
"position": [
2060,
-60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "379c7461-0ede-413a-9976-02c1351caf9b",
"name": "website_url",
"type": "string",
"value": "={{ $json.output.website_url }}"
},
{
"id": "1e638aa9-bbc6-4869-8aa3-9ebb102cf290",
"name": "company_name",
"type": "string",
"value": "={{ $('Extract Structured Data ').item.json.output.company_name }}"
},
{
"id": "8047a593-0aa0-4ef5-89c1-1e1f3c42ee23",
"name": "funding_round",
"type": "string",
"value": "={{ $('Extract Structured Data ').item.json.output.funding_round }}"
},
{
"id": "fb324383-fe81-4964-bc18-a5992e1005a8",
"name": "funding_amount",
"type": "number",
"value": "={{ $('Extract Structured Data ').item.json.output.funding_amount }}"
},
{
"id": "75c1c919-0249-468d-8c08-ce818a8260b9",
"name": "lead_investor",
"type": "string",
"value": "={{ $('Extract Structured Data ').item.json.output.lead_investor }}"
},
{
"id": "1b938b68-68ad-4b59-a372-d141b3fa188a",
"name": "market",
"type": "string",
"value": "={{ $('Extract Structured Data ').item.json.output.market }}"
},
{
"id": "0b2efd2b-ef69-4e59-ac2b-7ef47e288965",
"name": "participating_investors",
"type": "string",
"value": "={{ $('Extract Structured Data ').item.json.output.participating_investors }}"
},
{
"id": "f49e6523-f000-4c8b-bdec-7e436ead6359",
"name": "press_release_url",
"type": "string",
"value": "={{ $('Extract Structured Data ').item.json.output.press_release_url }}"
},
{
"id": "270451dc-2f26-41f0-8b6a-2afe4e498652",
"name": "evaluation",
"type": "number",
"value": "={{ $('Extract Structured Data ').item.json.output.evaluation }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "29a49e31-22dd-4f33-89ca-d12bbf217c76",
"name": "Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
2320,
-160
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appYwSYZShjr8TN5r",
"cachedResultUrl": "https://airtable.com/appYwSYZShjr8TN5r",
"cachedResultName": "Funding Rounds"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblQTIWUC8FBMF16F",
"cachedResultUrl": "https://airtable.com/appYwSYZShjr8TN5r/tblQTIWUC8FBMF16F",
"cachedResultName": "Funding Round Base"
},
"columns": {
"value": {},
"schema": [
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website_url",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "website_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_round",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "funding_round",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_amount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "funding_amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lead_investor",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "lead_investor",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "participating_investors",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "participating_investors",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "market",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "market",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "press_release_url",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "press_release_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "evaluation",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "evaluation",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "JwUch1mrw0pUVtnE",
"name": "Airtable Personal Access Token account 2"
}
},
"typeVersion": 2.1
},
{
"id": "497815af-12ea-4d1e-94aa-c403bcc55f7b",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1420,
400
],
"parameters": {
"color": 4,
"width": 300,
"content": "## Company ResearchnUsing Perplexity Deep Research we can find more information about the company."
},
"typeVersion": 1
},
{
"id": "13a156e5-d3e0-46b8-9ad6-0a1c3de775b0",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-700,
-440
],
"parameters": {
"color": 6,
"content": "## TechCrunch & VentureBeatnHTTP GET requests to fetch the latest articles from tech news sitemap feeds."
},
"typeVersion": 1
},
{
"id": "0f202470-8506-4e01-a5fb-f3519ede91a8",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-440,
-440
],
"parameters": {
"content": "## Parse XMLnConverts XML data to structured JSON for easier processing of article metadata."
},
"typeVersion": 1
},
{
"id": "dd485685-9962-47b0-9876-f8ebdb434040",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-180,
-440
],
"parameters": {
"width": 280,
"content": "## Split Articles & Filter:nSeparates individual articles and filters to keep only the most relevant ones based on keywords (raised)"
},
"typeVersion": 1
},
{
"id": "fda62c36-cb3e-45a9-8c8c-42d2a3b13ea6",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
120,
-440
],
"parameters": {
"content": "## Get ArticlenFetches the full article content for each relevant article in the feed."
},
"typeVersion": 1
},
{
"id": "caca7808-997d-48a1-8869-edcbd2dce2dd",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
-440
],
"parameters": {
"content": "## HTML ParsernExtracts clean text content from the HTML articles for analysis."
},
"typeVersion": 1
},
{
"id": "97cbd997-6f42-4454-a33a-81737ea8bd9f",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
-440
],
"parameters": {
"width": 260,
"content": "## Merge Extracted DatanCombines articles from multiple sources into a unified dataset for comprehensive analysis."
},
"typeVersion": 1
},
{
"id": "d9b84d9e-7718-419a-9d81-6403e3273f36",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
-440
],
"parameters": {
"width": 300,
"content": "## Extract Structured DatanIdentifies and structures key information from article text such as company names, funding details, and tech trends."
},
"typeVersion": 1
},
{
"id": "060e8914-c025-4594-a99a-539c5c5cfec4",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
-440
],
"parameters": {
"width": 360,
"content": "## Research company websitenUses perplexity to find the company website with search"
},
"typeVersion": 1
},
{
"id": "7f1dc67d-7c2d-4b6a-83b2-c2775bc91085",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
1620,
-440
],
"parameters": {
"width": 360,
"content": "## Extract URLnSince perplexity uses Llama which is not great at structured output - 2 step approach for a more reliable run"
},
"typeVersion": 1
},
{
"id": "fa7d5737-7970-478d-aa4d-24db31c6ac2e",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
2000,
-440
],
"parameters": {
"width": 420,
"content": "## Collect data & write to airtablenCollecting all data to pass on to detailed company research and store information in airtable"
},
"typeVersion": 1
},
{
"id": "1ce484cc-d22c-44b7-8de3-421904307353",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2040,
400
],
"parameters": {
"color": 4,
"width": 440,
"content": "## Extract structured data from reportnDeep Research produces long text output. We use a parser here to make the information available in structured format. As the json structure is quite complex I am using a strong model and the Auto-fixing Output Parsern"
},
"typeVersion": 1
},
{
"id": "50fbc465-a6ab-4fc7-af1e-f91bd2f40e5d",
"name": "Auto-fixing Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
2280,
780
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "3eb9aa59-9b57-4375-ac39-4e1fd900365e",
"name": "Extract Structured JSON ",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2440,
920
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{n "type": "object",n "properties": {n "company_name": {n "type": "string",n "description": "Official name of the company receiving funding"n },n "funding_round": {n "type": "string",n "description": "Type of funding round (Seed, Series A, B, C, etc.)",n "enum": ["Pre-Seed", "Seed", "Series A", "Series B", "Series C", "Series D", "Series E+", "Growth Equity", "Late Stage", "Venture Round", "Convertible Note", "Debt Financing", "Grant", "Private Equity", "Other"]n },n "funding_amount": {n "type": "object",n "properties": {n "value": {n "type": "number",n "description": "Numerical value of the funding amount"n },n "currency": {n "type": "string",n "description": "Currency of the funding amount",n "default": "USD"n }n }n },n "announcement_date": {n "type": "string",n "format": "date",n "description": "Date when the funding was publicly announced (YYYY-MM-DD)"n },n "lead_investor": {n "type": ["string", "array"],n "description": "Primary investor(s) leading the round. Can be single string or array for multiple leads."n },n "participating_investors": {n "type": "array",n "items": {n "type": "string"n },n "description": "Other firms or angels who participated in the round"n },n "industry": {n "type": "array",n "items": {n "type": "string"n },n "description": "Primary industry categories or verticals"n },n "company_description": {n "type": "string",n "description": "Brief explanation of what the company does"n },n "hq_location": {n "type": "object",n "properties": {n "city": {n "type": "string"n },n "country": {n "type": "string"n }n },n "description": "Company headquarters location"n },n "website_url": {n "type": "string",n "format": "uri",n "description": "Company's official website"n },n "founding_year": {n "type": "integer",n "description": "Year the company was founded"n },n "founder_names": {n "type": "array",n "items": {n "type": "string"n },n "description": "Names of company founders"n },n "ceo_name": {n "type": "string",n "description": "Name of current CEO"n },n "employee_count": {n "type": ["integer", "string"],n "description": "Current number of employees (exact or range)"n },n "total_funding": {n "type": "object",n "properties": {n "value": {n "type": "number"n },n "currency": {n "type": "string",n "default": "USD"n }n },n "description": "Total funding raised to date including this round"n },n "funding_purpose": {n "type": "array",n "items": {n "type": "string"n },n "description": "Stated use of funds (e.g., expansion, R&D, marketing)"n },n "business_model": {n "type": "array",n "items": {n "type": "string",n "enum": ["B2B", "B2C", "B2B2C", "D2C", "Marketplace", "SaaS", "Hardware", "Hybrid", "Other"]n },n "description": "Company's business model categories"n },n "valuation": {n "type": "object",n "properties": {n "pre_money": {n "type": "object",n "properties": {n "value": {n "type": "number"n },n "currency": {n "type": "string",n "default": "USD"n }n }n },n "post_money": {n "type": "object",n "properties": {n "value": {n "type": "number"n },n "currency": {n "type": "string",n "default": "USD"n }n }n }n },n "description": "Company valuation information (if disclosed)"n },n "previous_rounds": {n "type": "array",n "items": {n "type": "object",n "properties": {n "date": {n "type": "string",n "format": "date"n },n "round": {n "type": "string"n },n "amount": {n "type": "object",n "properties": {n "value": {n "type": "number"n },n "currency": {n "type": "string"n }n }n },n "investors": {n "type": "array",n "items": {n "type": "string"n }n }n }n },n "description": "Information about previous funding rounds"n }n }n}"
},
"typeVersion": 1.2
},
{
"id": "fde5dc11-c264-4f82-982b-23398de84888",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
400
],
"parameters": {
"color": 4,
"content": "## Exectuted as a subworkflown"
},
"typeVersion": 1
},
{
"id": "618170f3-eacd-4c9f-bd0f-1530408ff50d",
"name": "Prompts",
"type": "n8n-nodes-base.set",
"position": [
1280,
600
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "6751c31d-b5d5-4c87-bc36-5b7f5e317062",
"name": "user_prompt",
"type": "string",
"value": "=I need comprehensive information about {{ $json.company_name }} that recently announced a {{ $json.funding_round }} funding round of {{ $json.funding_amount }}. nnPlease research and compile the following: nn## Company Background n- Year founded and founding story n- Founder backgrounds and previous ventures n- Current executive team composition n- Total funding raised to date (including all previous rounds) n- Previous investors before this round nn## Business Analysis n- Detailed description of products/services n- Primary revenue model (subscription, freemium, transaction fees, etc.) n- Target customer segments n- Current estimated customer/user count n- Estimated annual revenue (if available) nn## Market Position n- Primary competitors in their space n- Unique selling proposition/competitive advantage n- Recent partnerships or major client announcements n- Market size and growth rate of their industry n- Their estimated market share Growth Trajectory n- Employee growth rate over past 1-2 years n- Geographic expansion plans n- Recent product launches or roadmap information n- Any stated plans for the funding (expansion, R&D, etc.) nn## Additional Context n- Any recent news about the company beyond funding n- Relevant industry trends affecting their business n- Notable advisors or board members n- Any regulatory considerations for their marketn"
},
{
"id": "362a60c8-8c48-44c6-819e-217d361a4c4d",
"name": "system_prompt",
"type": "string",
"value": "=You are a company research assistant.nPlease include sources for all information gathered so I can verify and explore further."
}
]
}
},
"typeVersion": 3.4
},
{
"id": "170f4ffb-ebeb-4277-8d72-b5bd553b5a3e",
"name": "Deep Research",
"type": "n8n-nodes-base.httpRequest",
"position": [
1520,
600
],
"parameters": {
"url": "https://api.perplexity.ai/chat/completions",
"method": "POST",
"options": {},
"jsonBody": "={n "model": "sonar-deep-research",n "messages": [n {n "role": "system",n "content": "{{ $json.system_prompt.replace(/\n/g, " ").replace(/\s+/g, " ").trim() }}"n },n {n "role": "user",n "content": "{{ $json.user_prompt.replace(/\n/g, " ").replace(/\s+/g, " ").trim() }}"n }n ]n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"headerParameters": {
"parameters": [
{}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "zeTmfLMIZb16l3SX",
"name": "Perplexity Auth"
}
},
"typeVersion": 4.2
},
{
"id": "a6a227b1-7590-408f-b4e4-8ea3eeef871e",
"name": "Pick data (Perplexity)",
"type": "n8n-nodes-base.set",
"position": [
1800,
600
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d99c7dc9-5d1a-4cb8-b391-62df3e905530",
"name": "report",
"type": "string",
"value": "={{ $json.choices[0].message.content }}"
},
{
"id": "7f2ff728-a4f6-4422-bd65-34a09e5b6fab",
"name": "links",
"type": "array",
"value": "={{ $json.citations }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "b836050a-9cab-4cbc-bd4c-b53730e8df06",
"name": "Pick data (jina)",
"type": "n8n-nodes-base.set",
"position": [
1800,
840
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "93201e0b-ad34-421a-92f0-bf7e78a81743",
"name": "report",
"type": "string",
"value": "={{ $json.choices[0].message.content }}"
},
{
"id": "39133a41-16fb-4008-8e60-8994f2158963",
"name": "links",
"type": "array",
"value": "={{ $json.visitedURLs }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "925c6359-de4f-409f-b872-d12180d3a957",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
1500,
1000
],
"parameters": {
"color": 4,
"width": 420,
"height": 140,
"content": "## Optional: Use jina Deep Searchnhttps://jina.ai/news/a-practical-guide-to-implementing-deepsearch-deepresearchnn"
},
"typeVersion": 1
},
{
"id": "fd00e4d5-dffd-4ecb-a722-7f37d6dc5b9f",
"name": "When Executed by Another Workflow",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
1020,
600
],
"parameters": {
"workflowInputs": {
"values": [
{
"name": "company_name"
},
{
"name": "funding_amount",
"type": "number"
},
{
"name": "funding_round"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "859ed482-0670-4023-92cf-aec4d688193d",
"name": "JINA Deep Search",
"type": "n8n-nodes-base.httpRequest",
"position": [
1520,
840
],
"parameters": {
"url": "https://deepsearch.jina.ai/v1/chat/completions",
"method": "POST",
"options": {},
"jsonBody": "={n "model": false,n "messages": [n {n "role": "user",n "content": "{{ $json.system_prompt.replace(/\n/g, " ").replace(/\s+/g, " ").trim() }}"n },n {n "role": "user",n "content": "{{ $json.user_prompt.replace(/\n/g, " ").replace(/\s+/g, " ").trim() }}"n }n ],n "stream": false,n "reasoning_effort": falsen}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "30Y0DulqMzqn5psh",
"name": "Jina Auth"
}
},
"typeVersion": 4.2
},
{
"id": "9b3f8bc7-72b4-4010-8427-5fd6a9706e50",
"name": "Write Results to Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
2720,
600
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appYwSYZShjr8TN5r",
"cachedResultUrl": "https://airtable.com/appYwSYZShjr8TN5r",
"cachedResultName": "Funding Rounds"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbltUvIthISpEbgUp",
"cachedResultUrl": "https://airtable.com/appYwSYZShjr8TN5r/tbltUvIthISpEbgUp",
"cachedResultName": "Company Deep Research"
},
"columns": {
"value": {
"ceo_name": "={{ $json.output.ceo_name }}",
"currency": "={{ $json.output.funding_amount.currency }}",
"industry": "={{ Array.isArray($json.output.industry) ? $json.output.industry.join(', ') : $json.output.industry }}",
"valuation": "={{ JSON.stringify($json.output.valuation) }}",
"hq_location": "={{ $json.output.hq_location.city }}, {{ $json.output.hq_location.country }}",
"source_urls": "={{ $('Pick data (Perplexity)').item.json.links.map((item, idx) => `${idx + 1}: ${item}`).join('\n') }}",
"company_name": "={{ $json.output.company_name }}",
"founder_names": "={{ Array.isArray($json.output.founder_names) ? $json.output.founder_names.join(', ') : $json.output.founder_names }}",
"founding_year": "={{ $json.output.founding_year }}",
"funding_round": "={{ $json.output.funding_round }}",
"lead_investor": "={{ Array.isArray($json.output.lead_investor) ? $json.output.lead_investor.join(', ') : $json.output.lead_investor }}",
"total_funding": "={{ $json.output.total_funding.value }}",
"business_model": "={{ Array.isArray($json.output.business_model) ? $json.output.business_model.join(', ') : $json.output.business_model }}",
"employee_count": "={{ $json.output.employee_count }}",
"funding_amount": "={{ $json.output.funding_amount.value }}",
"funding_purpose": "={{ Array.isArray($json.output.funding_purpose) ? $json.output.funding_purpose.join(', ') : $json.output.funding_purpose }}n",
"original_report": "={{ $('Pick data (Perplexity)').item.json.report }}",
"previous_rounds": "={{ JSON.stringify($json.output.previous_rounds) }}",
"announcement_date": "={{ $json.output.announcement_date }}",
"company_description": "={{ $json.output.company_description }}",
"total_funding_currency": "={{ $json.output.total_funding.currency }}",
"participating_investors": "={{ Array.isArray($json.output.participating_investors) ? $json.output.participating_investors.join(', ') : $json.output.participating_investors }}"
},
"schema": [
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_round",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "funding_round",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_amount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "funding_amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "currency",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "announcement_date",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "announcement_date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lead_investor",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "lead_investor",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "participating_investors",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "participating_investors",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "industry",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_description",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "company_description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "hq_location",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "hq_location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website_url",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "website_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "founding_year",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "founding_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "founder_names",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "founder_names",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ceo_name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "ceo_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "employee_count",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "employee_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "total_funding",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "total_funding",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "total_funding_currency",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "total_funding_currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_purpose",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "funding_purpose",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "business_model",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "business_model",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "valuation",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "valuation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "previous_rounds",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "previous_rounds",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "source_urls",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "source_urls",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "original_report",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "original_report",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "JwUch1mrw0pUVtnE",
"name": "Airtable Personal Access Token account 2"
}
},
"typeVersion": 2.1
},
{
"id": "703707ad-8bb4-4d86-9531-90866a400e39",
"name": "Extract Structured Data",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
2120,
600
],
"parameters": {
"text": "=nSources Urls: n{{ $json.links.map((item, idx) => `${idx + 1}: ${item}`).join('\n') }}nnReport: {{ $json.report.replace(/[\s\S]*?/g, ''); }}",
"messages": {
"messageValues": [
{
"message": "Only extract available information. Do not fill in information that cant be backed with the provided document."
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.5
},
{
"id": "8475db8d-9d57-4476-bdac-beee857f50df",
"name": "Sticky Note14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1140,
-440
],
"parameters": {
"color": 6,
"width": 420,
"content": "## Identify companies that just raised fundsnnIncludes deep research of the Company Background, Market Position and Business Analysis "
},
"typeVersion": 1
},
{
"id": "330e38c4-9941-4c27-ac88-243ef032dd5d",
"name": "Route to Deep Research",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
2320,
40
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "id",
"value": "TtsCaYjVToaUEE6V"
},
"workflowInputs": {
"value": {
"company_name": "={{ $json.company_name }}",
"funding_round": "={{ $json.funding_round }}",
"funding_amount": "={{ $json.funding_amount }}"
},
"schema": [
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_amount",
"type": "number",
"display": true,
"removed": false,
"required": false,
"displayName": "funding_amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_round",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "funding_round",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "d4061dc5-5849-487b-ae2c-a0cf60b8ed12",
"name": "Parse TC XML",
"type": "n8n-nodes-base.xml",
"position": [
-380,
-220
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "3c8a9ac6-8f7b-4b21-91d3-7d8cf25670f7",
"name": "Parse VB XML",
"type": "n8n-nodes-base.xml",
"position": [
-380,
120
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "3b61cc4d-dc62-4266-8f59-740a23cd8a1c",
"name": "Sticky Note15",
"type": "n8n-nodes-base.stickyNote",
"position": [
2560,
-160
],
"parameters": {
"color": 6,
"width": 400,
"height": 120,
"content": "## Airtable Base nhttps://airtable.com/appYwSYZShjr8TN5r/shryOEdmJmZE5ROce"
},
"typeVersion": 1
},
{
"id": "02c13204-1e3e-4f1a-be15-5ee842696340",
"name": "Claude 3.5 Sonnet",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
2120,
920
],
"parameters": {
"model": "claude-3-5-sonnet-20241022",
"options": {}
},
"credentials": {
"anthropicApi": {
"id": "IuDNko14nN79w51k",
"name": "Anthropic account 2"
}
},
"typeVersion": 1.2
},
{
"id": "77df4556-e5da-4bd6-9df2-bb4993256258",
"name": "Get Funding Article HTML for scraping (TC)",
"type": "n8n-nodes-base.httpRequest",
"position": [
180,
-220
],
"parameters": {
"url": "={{ $json['urlset.url'].loc }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "c6082aa7-84ce-40ce-8372-a73163439a8f",
"name": "Get Funding Article HTML for scraping (VB)",
"type": "n8n-nodes-base.httpRequest",
"position": [
180,
120
],
"parameters": {
"url": "={{ $json.loc }}",
"options": {}
},
"typeVersion": 4.2
}
],
"pinData": {},
"connections": {
"Filter": {
"main": [
[
{
"node": "Get Funding Article HTML for scraping (TC)",
"type": "main",
"index": 0
}
]
]
},
"Filter1": {
"main": [
[
{
"node": "Get Funding Article HTML for scraping (VB)",
"type": "main",
"index": 0
}
]
]
},
"Prompts": {
"main": [
[
{
"node": "Deep Research",
"type": "main",
"index": 0
}
]
]
},
"Perplexity": {
"ai_languageModel": [
[
{
"node": "Research URL",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Extract URL": {
"main": [
[
{
"node": "Collect Data",
"type": "main",
"index": 0
}
]
]
},
"Collect Data": {
"main": [
[
{
"node": "Route to Deep Research",
"type": "main",
"index": 0
},
{
"node": "Airtable",
"type": "main",
"index": 0
}
]
]
},
"Parse TC XML": {
"main": [
[
{
"node": "Split TC Articles",
"type": "main",
"index": 0
}
]
]
},
"Parse VB XML": {
"main": [
[
{
"node": "Split VB Articles",
"type": "main",
"index": 0
}
]
]
},
"Research URL": {
"main": [
[
{
"node": "Extract URL",
"type": "main",
"index": 0
}
]
]
},
"Deep Research": {
"main": [
[
{
"node": "Pick data (Perplexity)",
"type": "main",
"index": 0
}
]
]
},
"TC HTML Parser": {
"main": [
[
{
"node": "Merge Extracted Data",
"type": "main",
"index": 0
}
]
]
},
"VB HTML Parser": {
"main": [
[
{
"node": "Merge Extracted Data",
"type": "main",
"index": 1
}
]
]
},
"Techcrunch (TC)": {
"main": [
[
{
"node": "Parse TC XML",
"type": "main",
"index": 0
}
]
]
},
"Claude 3.5 Haiku": {
"ai_languageModel": [
[
{
"node": "Extract URL",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"JINA Deep Search": {
"main": [
[
{
"node": "Pick data (jina)",
"type": "main",
"index": 0
}
]
]
},
"Pick data (jina)": {
"main": [
[]
]
},
"Venturebeat (VB)": {
"main": [
[
{
"node": "Parse VB XML",
"type": "main",
"index": 0
}
]
]
},
"Claude 3.5 Sonnet": {
"ai_languageModel": [
[
{
"node": "Extract Structured Data ",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Split TC Articles": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Split VB Articles": {
"main": [
[
{
"node": "Filter1",
"type": "main",
"index": 0
}
]
]
},
"Claude 3.5 Sonnet": {
"ai_languageModel": [
[
{
"node": "Extract Structured Data",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Merge Extracted Data": {
"main": [
[
{
"node": "Extract Structured Data ",
"type": "main",
"index": 0
}
]
]
},
"Pick data (Perplexity)": {
"main": [
[
{
"node": "Extract Structured Data",
"type": "main",
"index": 0
}
]
]
},
"Extract Structured Data": {
"main": [
[
{
"node": "Write Results to Airtable",
"type": "main",
"index": 0
}
]
]
},
"Extract Structured Data ": {
"main": [
[
{
"node": "Research URL",
"type": "main",
"index": 0
}
]
]
},
"Extract Structured JSON ": {
"ai_outputParser": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Extract URL",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "Extract Structured Data",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Write Results to Airtable": {
"main": [
[]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "Prompts",
"type": "main",
"index": 0
}
]
]
},
"When clicking u2018Test workflowu2019": {
"main": [
[
{
"node": "Techcrunch (TC)",
"type": "main",
"index": 0
},
{
"node": "Venturebeat (VB)",
"type": "main",
"index": 0
}
]
]
},
"Get Funding Article HTML for scraping (TC)": {
"main": [
[
{
"node": "TC HTML Parser",
"type": "main",
"index": 0
}
]
]
},
"Get Funding Article HTML for scraping (VB)": {
"main": [
[
{
"node": "VB HTML Parser",
"type": "main",
"index": 0
}
]
]
}
}
}