Build a runZero software inventory report with end-of-life dates
Build a scheduled workflow that retrieves the software inventory from runZero. For each product/version, look up end-of-life dates from an EOL data source (e.g., endoflife.date) and attach them. Compile the enriched inventory into a Google Sheet, highlighting items past or near EOL. Handle products with no EOL match, paginate inventory, and cache lookups. Output the link to the generated Google Sheet report.
What this prompt builds
Pull software inventory from runZero, enrich it with EOL dates, and output a Google Sheet.
The problem
Teams don't know which software in their estate is past or nearing end of life until it becomes an unpatched liability. Stitching inventory to EOL data by hand is impractical at scale.
Solution and impact
This workflow exports runZero's software inventory, enriches each product with end-of-life dates, and writes a Google Sheet report. Lifecycle risk becomes visible and prioritizable in one place.