Monitor authentication IPs from SaaS alerts & email reports via SMTP2Go
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Convert to/from binary data. 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs when someone submits an n8n form (“Request Sign-In CSV”). It uses only n8n's built-in nodes. It also calls api.smtp2go.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Request Sign-In CSV”).
- Set Date and Form Variables (Edit Fields (Set)): sets 4 fields: Last 24 Hours, API, Name…
- GET Events - Login Successful (HTTP Request): calls an HTTP API
- GET Events - OAuth Authentication (HTTP Request): calls an HTTP API
- GET Events - Office365 Shell WCSS (HTTP Request): calls an HTTP API
- Combine all Authentication Events (Merge): merges the data from its input branches
- Filter IP Information (Edit Fields (Set)): sets or maps fields
- Remove Duplicate IPs (Remove Duplicates): removes duplicate items
- Convert to CSV (Convert to File): converts data to a file
- Convert CSV to Base (Convert to/from binary data): uses Convert to/from binary data
- Send Email Upon Completion (SMTP2Go) (HTTP Request): calls api.smtp2go.com (POST)
HTTP calls to: api.smtp2go.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Convert to/from binary data in Convert CSV to Base64: replace with Convert to File or Extract from File.
| Removed in 3.0 | Replace with |
|---|---|
| Convert to/from binary data Convert CSV to Base64 | Convert to File or Extract from File |
Nodes used (7)
- HTTP Request
n8n-nodes-base.httpRequest - Remove Duplicates
n8n-nodes-base.removeDuplicates - Convert to/from binary data
n8n-nodes-base.moveBinaryData - Convert to File
n8n-nodes-base.convertToFile - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - n8n Form Trigger
n8n-nodes-base.formTrigger
From the author
Collect and Email Authentication IP Addresses from SaaS Alerts (Last 24 Hours) Description This n8n workflow automates the process of collecting sign-in IP addresses from SaaS Alerts over the past 24 hours and emailing the results using SMTP2Go. Designed for…