Automated SEC Form D filings tracker with Google Sheets integration

Description

This workflow automatically monitors and tracks SEC Form D filings (private placement offerings) by fetching data from the SEC EDGAR database every 10 minutes during business hours and saving new filings to Google Sheets for analysis and tracking.

Who's it for - Venture capitalists tracking private funding rounds and market activity - Investment analysts researching private placement trends and opportunities - Financial researchers collecting data on private securities offerings - Business development teams identifying potential partnership or acquisition targets - Compliance professionals monitoring regulatory filings in their industry

How it works The workflow connects to the SEC EDGAR RSS feed to fetch the latest Form D filings, parses the XML data, extracts key information including CIK numbers and filing links, filters out duplicates from previous runs, and automatically saves new filings to a Google Sheets document for easy analysis and tracking.

What it does 1. Automated scheduling - Runs every 10 minutes during business hours (6 AM - 9 PM, Monday-Friday) 2. Fetches SEC data - Retrieves the 40 most recent Form D filings from SEC EDGAR RSS feed 3. Parses filing data - Converts XML to structured data and extracts CIK numbers, titles, and links 4. Filters duplicates - Only processes new filings that haven't been seen in previous executions 5. Saves to sheets - Appends new filing data to Google Sheets with proper formatting

Requirements - Google Sheets API access with OAuth2 credentials configured - Google Sheets document - Make a copy of [this template sheet](https://docs.google.com/spreadsheets/d/1VoGfVpk1mMrqKIc5hsO7peYuLx0SwhsbW7uUeYJCmrU/edit?usp=sharing) - n8n instance running continuously for scheduled execution

How to set up 1. Copy the template Google Sheet from the link above to your Google Drive 2. Configure Google Sheets OAuth2 authentication in n8n credentials 3. Update the Google Sheets document ID in the "Save to SEC Data Sheet" node to point to your copied sheet 4. Customize the User-Agent header in the HTTP Request node with your contact information (required by SEC) 5. Activate the workflow - The schedule trigger will start monitoring automatically 6. Test manually by replacing the Schedule Trigger with a Manual Trigger for initial testing

How to customize the workflow - Schedule frequency: Modify the cron expression in the Schedule Trigger (default: every 10 minutes) - Business hours: Adjust the time range (default: 6 AM - 9 PM EST) - Working days: Change from Monday-Friday to include weekends if needed - Filing count: Modify the SEC URL to fetch more than 40 filings (change count=40 parameter) - Form types: Update the URL to track different SEC forms (change type=D to other form types) - Output format: Customize the Google Sheets column mapping to include additional fields - Notifications: Add Slack, email, or webhook nodes to get alerts for new filings