planeta ai logo
Darmowy szablon automatyzacji

Automatyzacja badań nad finansowaniem startupów z Claude, Perplexity AI i Airtable

3432
2 mies. temu
51
bloków

Jak działa automatyzacja badania finansowania startupów

Ten inteligentny przepływ pracy automatycznie odkrywa i analizuje niedawno finansowane startupy poprzez:

  • Monitorowanie wielu źródeł informacji (TechCrunch i VentureBeat) pod kątem ogłoszeń o finansowaniu
  • Wykorzystanie AI do wyodrębnienia kluczowych szczegółów finansowania (nazwa firmy, pozyskana kwota, inwestorzy)
  • Przeprowadzanie automatycznych pogłębionych badań nad każdą firmą za pomocą Perplexity Deep Research lub Jina Deep Search
  • Organizowanie wszystkich wyników w uporządkowanej bazie danych Airtable dla łatwego dostępu i analizy

Kroki konfiguracji (10-15 minut)

  1. Połącz źródła kanałów informacyjnych (TechCrunch i VentureBeat)
  2. Skonfiguruj dane uwierzytelniające usług AI (Claude i Perplexity lub Jina)
  3. Połącz swoje konto Airtable i utwórz bazę z odpowiednimi polami

Struktura bazy Funding Round Base

Nazwa polaTyp danychOpis
website_urlStringURL strony internetowej firmy
company_nameStringNazwa firmy
funding_roundStringEtap finansowania (np. Seria A, Seed)
funding_amountNumberKwota pozyskanego finansowania
lead_investorStringGłówny inwestor prowadzący rundę finansowania
marketStringRynek lub sektor działalności firmy

Przykłady zastosowań

Ta automatyzacja może być wykorzystana w różnych scenariuszach biznesowych i badawczych:

  • Śledzenie trendów inwestycyjnych w określonych sektorach
  • Identyfikacja potencjalnych partnerów biznesowych lub akwizycji
  • Badanie konkurencji i analiza rynku
  • Tworzenie listy leadów dla usług finansowych
  • Monitorowanie aktywności funduszy VC i aniołów biznesu
  • Badanie skuteczności różnych strategii fundraisingowych
  • Analiza geograficznego rozkładu inwestycji

Wartościowe informacje

  • Perplexity przez Open Router nie przechowuje źródeł w tym samym miejscu co raport
  • Do użycia Perplexity i Jina wymagana jest konfiguracja autoryzacji nagłówkowej
  • Można importować strukturę bazy z gotowego szablonu

Czego możesz się nauczyć

  • Jak zbierać dane przy użyciu map witryn
  • Jak wyodrębniać ustrukturyzowane dane z nieustrukturyzowanego tekstu
  • Jak wykonywać części przepływu pracy jako podprzepływy
  • Jak wykorzystać głębokie badania w praktycznym scenariuszu
  • Jak definiować bardziej złożone schematy JSON

   Skopiuj kod szablonu   
{"meta":{"instanceId":"d4d7965840e96e50a3e02959a8487c692901dfa8d5cc294134442c67ce1622d3","templateCredsSetupCompleted":true},"nodes":[{"id":"5d02237f-151b-4bb4-9341-b11149925309","name":"When clicking ‘Test workflow’","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]*?<\/think>/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 ‘Test workflow’":{"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}]]}}}
  • API
  • Request
  • URL
  • Build
  • cURL
  • extract
  • template
  • table
  • LangChain
  • claude
  • sonnet
  • opus
  • json
  • zod
  • NER
  • parse
  • parsing
  • JSON
  • data extraction
  • structured
Planeta AI 2025 
magic-wandmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram