Open any Google Sheets™ spreadsheet, go to Extensions → Add-ons → Get add-ons, and search for "GovCon Tracker." Click Install and authorize the requested permissions. Once installed, a new ⚡ GovCon Tracker menu will appear in your menu bar automatically.
Click ⚡ GovCon Tracker → Open Sidebar from the menu bar. The sidebar opens on the right side of your spreadsheet and gives you access to all 6 modules — Opportunities Search, Entity Intelligence, Award History, Exclusion Monitor, Teaming Partners, and Registration Health.
Type any of the 9 formulas directly into a cell. For example:
=GOVCON_ENTITY("J8K4N2M5P7Q1R") — pulls a full entity profile by UEI =GOVCON_OPPS("541512","WOSB","ARMY") — searches live opportunities =GOVCON_EXCLUDED(A2) — checks if the UEI in cell A2 is excluded =GOVCON_EXPIRY(A2) — returns days until SAM.gov registration expires
Results populate across multiple columns automatically. All formulas cache for 6 hours for fast re-calculation.
Go to ⚡ GovCon Tracker → Insert Template and choose from the 6 templates: Opportunities, Pipeline Tracker, Entity Intel, Award History, Exclusion Monitor, or Teaming Partners. Each template inserts a new tab into your spreadsheet with pre-configured headers, column widths, and conditional formatting already applied.
Data freshness varies by module:
• Opportunities — always live from SAM.gov with a 1-hour cache
• Entity profiles — refreshed from SAM.gov's monthly extract daily, with a 48-hour staleness threshold
• Exclusions — updated from SAM.gov's daily exclusion extract
• Award history — refreshed every 4 hours
To force a refresh, go to ⚡ GovCon Tracker → Refresh All Data, then press Ctrl+Shift+F9 to recalculate all formulas.
Place a list of UEIs (12-character identifiers) anywhere in your spreadsheet. Then go to ⚡ GovCon Tracker → Bulk Exclusion Check. The add-on scans the active sheet, finds all valid UEIs, and checks each one against the SAM.gov exclusion database. Results are shown immediately in a summary dialog. You can also use =GOVCON_EXCLUDED(A2) to check individual UEIs inline.
GovCon Tracker checks SAM.gov registration expiry dates daily for entities on your watchlist. When an entity's registration is within 90, 60, or 30 days of expiring — or has already expired — you will receive an email alert at the Gmail™ address associated with your Google account. No setup is required beyond adding entities to your watchlist via the sidebar.
The data you write into your spreadsheet lives in your Google Sheets™ file — under your own Google account and Google's security. GovCon Tracker's backend caches publicly available SAM.gov data in Google Cloud Firestore (U.S. region only) to serve it quickly and reduce API calls. We do not store the contents of your spreadsheet on our servers. See our Privacy Policy for full details.
Subscriptions are managed entirely through the Google Workspace™ Marketplace. To cancel, go to Google Workspace™ Marketplace → Manage Apps → GovCon Tracker → Cancel Subscription. Cancellation takes effect at the end of your current billing period and you retain full access until then.
Try these steps in order:
1. Refresh formulas — press Ctrl+Shift+F9
2. Clear the cache — go to ⚡ GovCon Tracker → Refresh All Data
3. Reload the sidebar — close and reopen it from the menu
4. Reinstall the add-on — uninstall from Google Workspace™ Marketplace and reinstall
5. Contact support — if the issue persists, email us at nealm682@gmail.com with a description of the problem and your Google account email
Still need help?
Our support team typically responds within 1–2 business days. Include your Google account email and a description of the issue for the fastest resolution.