n8n Workflow: Monitor Competitor Funding (Apify, Gemini, Slack)

Get alerted when competitors raise new funding—automatically

This n8n workflow checks your competitor funding every Monday, pulls the latest Crunchbase data via Apify, detects new funding rounds, summarizes the strategic impact with Google Gemini, and posts updates to Slack while keeping your Google Sheets record current.

What this workflow does

• Runs on a schedule: Executes every Monday at 8AM using an n8n scheduled trigger.
• Loads competitors from Google Sheets: Reads your competitor list from a specified Google Sheets tab and prepares active Crunchbase profile URLs.
• Scrapes latest Crunchbase data: Calls an Apify Crunchbase scraper actor (via HTTP request using Apify token + actor endpoint) to fetch the most recent company data.
• Detects new total funding: Calculates each competitor’s new total funding by evaluating funding rounds, then compares it to the value in “Total Funding (Last Checked)” stored in Google Sheets.
• Generates strategic analysis (only on increase): If funding increased, Google Gemini produces a three-sentence strategic impact summary based on the funding change and investor context.
• Sends Slack alerts + updates the sheet: Posts the funding update and Gemini analysis to a Slack channel, then updates the matching Google Sheets row with funding, investors, tech stack, analysis, and a “Last Alert Sent” flag.
• Logs checks when no change occurs: If no funding increase is detected, it updates Google Sheets with the latest check date and notes that no alert was sent.

Use cases

• SaaS operators tracking funding-driven competitive shifts
• Founders and product teams monitoring investor activity among specific companies
• Automation engineers building a repeatable Google Sheets + Slack alerting pipeline for market intelligence

Technical details

• Google Sheets (read/write via Google Sheets node)
• HTTP Request with Apify API token for the Crunchbase scraper actor
• Google Gemini (Google PaLM) for three-sentence strategic analysis
• Slack node to post alerts
• Logic handled with nodes including if and code
• Includes a sticky note for workflow documentation