Automated procurement opportunity tracking that scrapes state and federal contract sites into a unified deal pipeline.
Tech Stack
- Apify
- n8n
- Google Sheets
- Airtable
- Slack API
Gallery
🔍 Click to enlarge
The Challenge
Finding relevant government contracts meant manually checking dozens of procurement portals daily. Opportunities were scattered across federal, state, and local sites with no unified search. Hours wasted, deals missed.
The Solution
Built an Apify actor that:
- Scrapes state and federal procurement websites automatically
- De-duplicates opportunities across multiple sources
- Filters contracts by industry, size, and priority
- Aggregates 100+ opportunities weekly into one feed
- Flags high-priority listings based on custom criteria
- Eliminates manual hunting across scattered portals
The Tech
The pipeline connects:
- Apify actor scrapes government contract sites on schedule
- n8n workflow processes and enriches the data
- Google Sheets serves as the initial staging area
- Airtable becomes the single source of truth with filtering
- Slack API sends priority alerts to the team
- Automated weekly reports summarize new opportunities
Results
Aggregates 100+ opportunities per week, eliminates hours of manual portal checking, and creates a single filterable database for partnerships and deal tracking.