Turn tech funding news into a clean Airtable list without manual research. The flow finds fresh articles about funding, pulls key facts, and adds company details your team can act on. It is great for marketing and sales teams that build target lists of newly funded companies.

Here is how it works. The workflow reads news sitemaps from major tech sites, converts XML to JSON, splits each article, and filters items that mention raised. It then downloads each article page and parses the HTML to get the title and full text. An AI step extracts company name, round, and amount into a structured format. A second AI step searches for the official website and uses a parser to guarantee a clean URL. Results from both sources are merged and written to Airtable. An optional branch runs deeper research using Perplexity and Jina to enrich the record.

You will need API keys for Airtable, Anthropic, OpenRouter, Perplexity, and Jina. Expect to cut daily research from hours to minutes and reduce errors from copy paste. Use this for ABM lists, partner scouting, or investor updates. Run it on demand or call it from a parent scheduled flow in n8n.

• Fetches Tech news sitemaps and converts XML to JSON for easy parsing.
• Splits feeds into individual articles and filters by funding keywords such as raised.
• Downloads each article page and extracts clean text and title with CSS selectors.
• Merges content from multiple sources into one dataset for review.
• Uses AI to pull company name, funding round, and amount as structured fields.
• Runs a two step website search with an output parser to return a valid URL.
• Optional deep research branch with Perplexity and Jina to enrich records.
• Writes final results to Airtable using mapped columns.
• Supports manual test runs or execution by another workflow.

• Reduce manual research from 3 hours to 10 minutes per day
• Automate 80% of data entry for funding updates
• Improve data quality by enforcing structured fields
• Unify two news sources into one Airtable view
• Scale to hundreds of articles per run without extra effort
• Capture official website URLs with fewer copy paste errors

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Airtable, Anthropic, OpenRouter, Perplexity and Jina AI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an Airtable Personal Access Token. Double click the Airtable node, choose Create new credential, paste your token, then select your base and table.
4. Create an Anthropic API key in your Anthropic account. In n8n, open the Claude nodes, choose Create new credential, and paste the key. Keep the default model set by the template.
5. Get an OpenRouter API key. In n8n, open the Perplexity via OpenRouter node, choose Create new credential for OpenRouter, and paste the key. Confirm the model is set to the Perplexity sonar model.
6. For Deep Research, add a Perplexity HTTP Header credential. Open the Deep Research HTTP node, click Create new credential, and add the required header with your Perplexity key.
7. Create a Jina AI API key. Open the JINA Deep Search node, choose Create new credential, and add the header with your Jina key.
8. Check the HTTP Request nodes for Tech news sitemaps and confirm the URLs are correct. Leave them as is unless the sites change their sitemap paths.
9. Open the Filter nodes and adjust the keyword list if you want to track other signals besides raised.
10. Review the HTML Parser nodes and confirm the CSS selectors match current site layouts. Update selectors if the site markup changes.
11. Open the Collect Data and Airtable nodes to confirm field mappings for company name, funding round, funding amount, website URL, and notes.
12. Run a manual test with the Manual Trigger. Check the execution, then verify new rows in Airtable. If no rows appear, review the filter results and the parser outputs.
13. For ongoing use, call this workflow from a scheduled parent workflow with Execute Workflow, or trigger it from your existing n8n orchestration flow.