What This Workflow Does
This automation solution addresses the growing threat of phishing attacks by automatically checking URLs against VirusTotal's comprehensive threat database. It eliminates manual security reviews while providing auditable logs of all scanned links in Google Sheets. The workflow helps organizations comply with security policies requiring documented review of external links while reducing the workload on IT teams.
By automating URL reputation checks, businesses can scan 100% of incoming links rather than relying on spot checks. The system flags suspicious URLs with detection rates from multiple antivirus engines, community reputation scores, and categorization tags. This provides security teams with actionable intelligence to block phishing attempts before they reach employees or customers.
How It Works
1. URL Input
The workflow accepts URLs from various sources including email attachments, form submissions, or security alerts. It can process single URLs or batches from spreadsheets.
2. VirusTotal API Check
Each URL is sent to VirusTotal's API which checks against 70+ security vendors. The system returns detailed reputation data including detection rates and threat categorization.
3. Risk Assessment
The workflow evaluates the VirusTotal results against your configured risk thresholds. URLs with high detection rates or phishing tags are flagged for immediate review.
4. Google Sheets Logging
All scan results are recorded in Google Sheets with timestamps, including the URL, detection details, and risk classification. This creates an auditable security log.
Who This Is For
This workflow is ideal for security teams, compliance officers, and IT administrators in regulated industries. Financial services, healthcare, and e-commerce businesses will find it particularly valuable for:
- Documenting security reviews for compliance audits
- Reducing manual URL analysis workload
- Identifying phishing attack patterns over time
- Training employees based on actual threat exposure
What You'll Need
- VirusTotal API key (free tier available)
- Google Sheets with write permissions
- n8n instance (cloud or self-hosted)
- Source of URLs to check (emails, forms, etc.)
Quick Setup Guide
- Download the JSON template file
- Import into your n8n instance
- Configure your VirusTotal API credentials
- Set up the Google Sheets connection
- Test with sample URLs
- Deploy to your production environment
Key Benefits
Proactive phishing prevention: Catch malicious URLs before they're clicked, reducing successful attack rates by up to 89% according to security studies.
Compliance documentation: Automated logging creates detailed records of security reviews required by regulations like PCI DSS and HIPAA.
Scalable protection: Process thousands of URLs daily without additional staff, with consistent quality checks.
Actionable intelligence: Identify high-risk domains and attack patterns to strengthen overall security posture.
Pro tip: Combine this with email filtering rules to automatically quarantine messages containing high-risk URLs before they reach inboxes.