Monitor competitor funding with Apify, Google Gemini, Google Sheets and Slack
Ready for 3.0What this workflow does
This AI workflow has 13 nodes and runs on a schedule (cron 0 8 * * 1). Along the way it connects Google Sheets, Slack and Google Gemini Chat Model. It also calls api.apify.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 8 * * 1).
- Read Competitors from Sheets (Google Sheets): uses Google Sheets
- Prepare Scraper Input (Code): runs custom JavaScript code
- Post to Apify Scraper API (HTTP Request): calls api.apify.com (POST)
- Calculate Funding Baseline (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Strategic Analysis Agent (AI Agent): runs an AI agent, with model: Google Gemini Model; output parser: Parse Structured AI Output
- Update Sheet for No Changes (Google Sheets): update
- Parse AI Analysis Output (Code): runs custom JavaScript code
- Send Slack Alert Message (Slack): uses Slack
- Update Sheet on Funding Change (Google Sheets): update
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
Quick Overview This workflow runs every Monday at 8AM to pull a competitor list from Google Sheets, scrape the latest Crunchbase data via Apify, detect new funding, generate a strategic impact summary with Google Gemini, send an alert to Slack, and update the…