Remove Duplicate IPs

Name: Remove Duplicate IPs
Rating: 3.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

13 views

0 downloads

Data Processingautomationdata-cleaningdeduplicationip-addresssecurity

Filters a list of IPs to remove duplicates.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow is designed to fetch authentication events, extract IP addresses, and then process this data to remove any duplicate IP entries. The final output is a clean list of unique IPs.

Key Features

Fetches various authentication event types (Login Successful, OAuth, Office365 Shell WCSS).
Merges data from multiple event sources.
Filters and selects relevant IP information.
Removes duplicate IP addresses from the dataset.
Converts the cleaned data to CSV format.
Encodes the CSV data to Base64.
Sends the processed data via email using SMTP2Go.

How To Use

Trigger the workflow by submitting the "Request Sign-In CSV" form with your name, email, and API key.
The workflow will fetch authentication events for the last 24 hours.
It will then process and deduplicate the IP addresses.
A CSV file containing unique IP information will be generated and emailed to you.

Apps Used

automation

data-cleaning

deduplication

ip-address

security

Workflow JSON

{
  "id": "8333ffcb-e257-422f-9f7c-d84b27bd8e2b",
  "name": "Remove Duplicate IPs",
  "nodes": 0,
  "category": "Data Processing",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.