📊 Track expiring federal contracts and recompetes with Apify and Google Sheets
⚡ 0 views · 📊 Market Research & Insights
💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.
Description
Quick overview
Who it’s for: GovCon capture managers, BD leads and small federal contractors who plan bids around contracts that are about to expire (recompetes).
How it works
- Every Monday a Schedule trigger runs the Expiring Federal Contracts – Recompete Radar Actor on Apify through a plain HTTP Request node.
- The Actor finds federal contracts whose period of performance ends in 3–18 months, from official USAspending.gov data, and checks each one against open SAM.gov notices with a match confidence (high, medium, low or none).
- With the monitor name set in the body, only new or changed contracts come back (changed = new end date, award amount or incumbent UEI, or a new high- or medium-confidence SAM.gov notice), so the sheet stays clean.
- An IF node stops on empty weeks, and a Set node keeps 22 columns (incumbent, UEI, value, end date, agency, NAICS/PSC, SAM.gov match and links).
- Google Sheets appends or updates rows matched on id.
Setup
- Copy your Apify API token (Apify Console → Settings → API & Integrations).
- On “Run GovCon Recompete Radar”, create a Header Auth credential: name Authorization, value Bearer .
- Connect Google Sheets, paste your spreadsheet ID, and put the 22 column names from “Pick columns” in row 1.
- Edit the JSON body (naicsCodes, awardingAgencies, minAwardAmount, monthsFrom/monthsTo). Keep monitorName set and the same between runs: it’s what makes each run return only new or changed contracts. Without it, every run returns the 25 soonest-ending contracts again (up to maxItems), all charged.
- Run once, check the output, then activate.
Requirements
- An Apify account (pay per result: $0.01 per run + $0.01 per contract row) and Google Sheets. No USAspending or SAM.gov API key is needed.
Customization
- Add a Slack alert for high-confidence SAM.gov matches, watch competitors by putting their names or UEIs in incumbents, or switch the schedule to daily.
🔗 Nodes Used
Google Sheets, HTTP Request, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File