SEC Form D Funding Tracker (Apify) → Google Sheets + Slack

Get fresh SEC Form D funding signals—automatically, with deduping and Slack alerts

This n8n workflow pulls recent SEC Form D funding-round matches using Apify, deduplicates them against your Google Sheets, appends only new filings, and posts a clear Slack summary (including explicit alerts when no new results are found or when the source run is degraded).

What this workflow does

• Runs on demand: you manually execute the workflow in n8n.
• Loads your settings: search queries, lookback window, result limit, and your target Google Sheets + Slack configuration.
• Reads existing filings from Google Sheets to collect previously stored SEC accession numbers.
• Fetches new matches by calling the Apify zinin/funding-round-tracker Actor for recent SEC Form D filings.
• Normalizes and filters results: allowlists only https://sec.gov and https://www.sec.gov URLs, detects partial/budget-degraded outcomes, and removes filings whose accessionNumber already exists in the sheet.
• Appends only new rows: if new filings are found, it appends them to Google Sheets.
• Posts to Slack: sends a summary of up to 10 new results; if there are no new filings or the source is degraded, it posts a corresponding status message and skips the Sheets update.

Use cases

• Track startup funding activity by monitoring SEC Form D filings for lead-generation.
• Keep an always-current pipeline sheet for analysts—without duplicates.
• Alert your team in Slack when new Form D matches arrive (or when the Apify source run underperforms).

Technical details

• Apify: uses an Apify API token via HTTP Request (HTTP Header Auth) to call zinin/funding-round-tracker.
• Google Sheets: OAuth + configured sheet ID/name; expected headers include sourceQuery, company, filedAt, form, accessionNumber, url, matched, summary, checkedAt.
• Slack: posts outcome status and a results summary.
• n8n nodes/workflow logic: uses nodes such as if, set, code, slack, plus a sticky note for documentation.