Manage vulnerabilities end-to-end with GPT-4, Jira, Slack and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 25 nodes and runs on a schedule (cron 0 7 * * 1) (plus 2 other triggers). Along the way it connects OpenAI Chat Model and Google Sheets. It also calls qualysapi.qualys.com and hooks.slack.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 7 * * 1) (plus 2 other triggers).
- Fetch Weekly Vuln Data for Report (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Build Weekly Executive Report (Code): runs custom JavaScript code
- Build Scan Context (Code): runs custom JavaScript code
- Send CISO Weekly Executive Report (Send Email): sends an email over SMTP
- Fetch Nessus Scan Results (HTTP Request): calls an HTTP API
- Fetch Qualys Scan Results (HTTP Request): calls qualysapi.qualys.com (POST)
- Fetch Custom Scanner Results (HTTP Request): calls an HTTP API
- Normalize and Deduplicate Findings (Code): runs custom JavaScript code
- GPT-4 AI Risk Prioritization (AI Agent): runs an AI agent, with model: GPT-4o Model
…plus 11 more steps. See the full node list below.
Services it uses
HTTP calls to: qualysapi.qualys.com, hooks.slack.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in GPT-4 AI Risk Prioritization (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) GPT-4 AI Risk Prioritization (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Webhook
n8n-nodes-base.webhook - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Send Email
n8n-nodes-base.emailSend - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Automates the full vulnerability lifecycle — from scheduled scanning and data aggregation to intelligent prioritization, ticket creation, real-time alerting, weekly reporting, and centralized tracking. Ensures critical vulnerabilities are patched quickly…