Extract Seed-Funded Startup Data with RSS, GPT-4 (Mini), and BrightData to Excel

This n8n workflow automates the process of identifying newly seed-funded startups from RSS feeds, enriching their data using an AI model, and preparing it for export or further analysis. It's designed to help you quickly discover and gather information on promising new companies.

What it does

This workflow performs the following key steps:

1. Monitors RSS Feeds: It acts as a trigger, listening for new items in a configured RSS feed.
2. Enriches Data with AI: For each new RSS item, it uses an OpenAI (GPT-4 mini) model to process the content. This step likely extracts specific details about the startup, such as its name, funding amount, investors, and a brief description, based on the prompt provided to the AI.
3. Formats Output: The extracted data is then formatted into a structured output, potentially cleaning up fields or combining information.
4. Generates Markdown Summary: A Markdown summary of the extracted startup information is generated, which could be used for reporting or display purposes.
5. Prepares for Further Action: The final output is ready to be used by subsequent nodes, such as sending to a spreadsheet (e.g., Excel), a database, or a notification service.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• RSS Feed URL: The URL of an RSS feed that publishes news about seed-funded startups (e.g., tech news sites, venture capital blogs).
• OpenAI API Key: An API key for OpenAI to utilize its language model (GPT-4 mini in this case) for data extraction and enrichment.
• (Potentially) BrightData Account: While not explicitly present in the provided JSON, the directory name suggests an integration with BrightData might be intended for web scraping or proxy services. If you plan to extend this workflow to scrape data from startup websites, a BrightData account might be necessary.
• (Potentially) Excel/Google Sheets/Database: A destination for the extracted data, such as an Excel file (manual export or via another n8n node), Google Sheet, or a database.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure RSS Feed Trigger:
   • Open the "RSS Feed Trigger" node.
   • Enter the URL of the RSS feed you wish to monitor for startup funding news.
   • Set the desired interval for checking the feed (e.g., every hour, daily).
3. Configure OpenAI Credentials:
   • Locate the "OpenAI" node.
   • Add your OpenAI API Key as a credential.
   • Review the prompt within the OpenAI node to ensure it aligns with the type of information you want to extract from the RSS feed content. Adjust as needed.
4. Review and Customize "Edit Fields" and "Code" Nodes:
   • The "Edit Fields (Set)" node likely renames or structures the data extracted by OpenAI. Review its configuration to ensure the fields are named as desired.
   • The "Code" node may contain custom JavaScript logic for further data manipulation. Examine and modify it if specific transformations are required.
5. Review "Markdown" Node: This node generates a Markdown summary. You can customize its content to include specific details from the extracted startup data.
6. Add Output Node (Optional): To send the extracted data to Excel or another service, you will need to add an additional n8n node. For example:
   • Google Sheets Node: To append data to a Google Sheet.
   • Write Binary File Node: To create a CSV or JSON file that can be opened in Excel.
   • HTTP Request Node: To send data to an external API (e.g., a custom endpoint for Excel integration).
7. Activate the Workflow: Once configured, activate the workflow to start monitoring the RSS feed and processing new startup funding announcements.