Crunchbase Startup Activity Alerts with OpenAI and Gmail

🧠 Automating Crunchbase Insights with n8n ### 📈 Get Daily Company Updates → 🤖 Summarize → 📧 Email Digest This workflow helps you stay informed on the latest company activity (from Crunchbase) by automating the entire process — fetching updates, summarizing them with AI, and emailing them to you daily. --- ## 🔹 SECTION 1: Data Collection & Preprocessing ### 📍 Nodes Involved: * ✅ Trigger Manual Test * 🌐 Fetch Crunchbase Updates * ✏️ Extract Company Details --- ### 🧩 1. Trigger Manual Test 🖱️ Purpose: This node is just for testing. It lets you manually start your workflow with a click. > 💡 In production, replace this with a cron node ⏰ if you want this workflow to run automatically every day. --- ### 🌐 2. Fetch Crunchbase Updates (HTTP Request) Purpose: This node sends a request to the Crunchbase API to fetch companies updated in the last 24 hours. 🔧 Here's what it does: * Makes a GET request to: https://api.crunchbase.com/api/v4/entities/organizations * Adds parameters: * user_key: Your Crunchbase API key 🔐 * updated_since: Yesterday’s date 📅 > ✅ It returns a list of updated companies including names, descriptions, locations, and industries. --- ### ✏️ 3. Extract Company Details Purpose: Crunchbase API data can be complex. This node simplifies things. 🛠 It: * Extracts essential fields only like: * Name 🏢 * Description 📖 * Location 📍 * Industry 🏭 * Last Updated Date 🗓️ * Prepares this data for the AI summarizer in a clean format. > 💡 This step ensures only the relevant information is passed forward, saving processing time and cost. --- ## 🧠 SECTION 2: AI Summary + Email Delivery ### 🤖 Nodes Involved: * 🧠 Summarize Company Updates * 💬 OpenAI Chat (GPT-4 or GPT-3.5) * 🔎 Parse JSON Email Summary * 📬 Send Email with Summary --- ### 🤖 4. Summarize Company Updates (AI Agent) Purpose: This is where the magic happens. It takes the company data and feeds it to an AI to generate a plain-English summary. 🛠 It connects with: * OpenAI Chat Model (GPT-4 / 3.5): Generates clear, readable summaries. * Structured Output Parser: Forces the AI to return a valid JSON object with: * subject: for the email subject line * body: the plain text of the email 📜 System Prompt Used: txt You are a helpful assistant that summarizes Crunchbase company updates. Output your response strictly as valid JSON with two properties: - "subject":