Track SEC Form D filings and send issuer and investor data to Google Sheets

Who's it for This workflow is designed for venture capitalists, private equity professionals, investment analysts, and financial researchers who need to track private securities offerings and fundraising activities in real-time. It's particularly valuable for firms building deal flow pipelines, monitoring competitor fundraising, or conducting private market research. What it does This automation continuously monitors the SEC's EDGAR database for new Form D filings, which companies file when raising capital through private placements. Every 10 minutes during business hours (Monday-Friday, 6 AM - 9 PM), it checks for new filings, downloads the complete documents, and extracts critical information into a structured Google Sheets database. The workflow captures comprehensive details including company name and contact information, key executives and their roles, fund classification, target offering amount, current capital raised, total investor count, sale status, filing dates, and regulatory exemptions being utilized (such as Rule 506(b) or 3(c)(7)). How it works The workflow operates in five main stages: Stage 1 - Feed Monitoring: A scheduled trigger activates every 10 minutes during business hours, fetching the latest Form D filing feed from the SEC EDGAR system in XML format. Stage 2 - Initial Processing: The XML feed is parsed to extract basic filing metadata including CIK numbers, company names, form types, and document URLs. The system then filters out any previously processed filings using deduplication logic and adds only new filings to your Google Sheet tracking database. Stage 3 - Selective Processing: The workflow identifies unprocessed Form D and Form D/A (amendment) filings that need detailed extraction, filtering out other form types and already-processed entries. Stage 4 - Deep Data Extraction: For each unprocessed filing, the workflow downloads the complete Form D text document, parses the embedded XML structure, and systematically extracts four categories of information: issuer details (company name, address, CIK, jurisdiction, entity type, industry classification), key personnel (executives, directors, promoters with their specific roles), offering information (total offering amount, amount already sold, remaining amount, investor count, accredited investor status), and regulatory details (exemptions claimed, sale status, offering duration). Stage 5 - Database Update: All extracted data is consolidated into a summary format and used to update the corresponding row in your Google Sheet, marking the filing as "processed". A wait node introduces a brief delay between document retrievals to comply with SEC rate limiting policies. Requirements To use this workflow, you'll need: - A Google Sheet configured with these specific columns: cikNumber, title, formType, filingLinkHtml, filingLinkTxt, updated, companyName, keyExecutive, executiveRole, fundType, targetAmount, amountRaised, investorCount, salesStatus, filingDate, exemptions, status, and comment - Google Sheets OAuth2 credentials connected in n8n to enable read/write access - Compliance with SEC EDGAR requirements: you must update the User-Agent headers in both HTTP Request nodes (replacing the placeholder email with your own valid email address as required by SEC's fair access policy) Setup instructions Step 1: Create or prepare your Google Sheet with the exact column structure listed in the requirements section. Note your Google Sheet ID from the browser URL. Step 2: In n8n, configure your Google Sheets OAuth2 credentials through the credentials panel. Test the connection to ensure it's working properly. Step 3: Open both Google Sheets nodes in the workflow ("Add New Filing to Tracking Sheet" and "Update Filing Status in Sheet"). Update the Document ID field with your Google Sheet ID. Step 4: Critical compliance step - Open both HTTP Request nodes ("Fetch SEC Form D Feed" and "Retrieve Form D Document"). In the headers section, replace [email protected]