AZ
Back to Use Cases

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

vcmarket-researchcompliancesec-edgargoogle-sheetsdeal-flow•
SEC EDGAR
Google Sheets

Run every 10 minutes

SEC EDGAR

Fetch filings feed

Parse XML

Google Sheets

Append new filings

SEC EDGAR

Download Form D doc

Extract issuer/investor fields

Google Sheets

Update filing row + status

Overview

This workflow builds a deal-flow monitoring feed from SEC Form D filings. It supports deep extraction beyond the RSS feed and stores structured results for analysis.

Product Specs

  • Runs every 10 minutes during business hours
  • Fetches SEC EDGAR Form D feed and parses filing metadata
  • Deduplicates filings and tracks processing status in Google Sheets
  • Downloads the full Form D document and extracts issuer, personnel, offering, and regulatory fields
  • Updates the corresponding Google Sheets row and marks as processed

Pipeline Description

A scheduled trigger fetches the SEC EDGAR Form D feed, parses the XML, and appends new filings to a Google Sheet. For unprocessed filings, it downloads the full document, extracts structured fields, then updates the sheet and sets processing status.