24-Hour IP Login Report in CSV

# 24-hour deduplicated IP login report in CSV via email from three data sources

This automation workflow collects and aggregates user sign-in events from three sources over the past 24 hours, removes duplicates by IP, and delivers a clean CSV report directly to the user´s email. It eliminates manual data processing and is ideal for security teams, SaaS managers, and support staff who need fast, structured access logs.

## Who it´s for
- Security administrators requesting IP-based login reports
- SaaS platform managers monitoring user activity
- Analysts needing cleaned geolocation data on sign-ins
- Support teams automating report delivery to clients

## What the automation does
- Triggered by a web form submission with name, email, and API key
- Fetches login events from three endpoints: successful sign-ins, OAuth, and Office365
- Merges and filters data by key fields (IP, location, user)
- Removes duplicate entries based on IP address
- Converts data to CSV format and encodes it in Base64
- Sends the file as an email attachment via SMTP2Go

## What´s included
- Ready-to-use n8n workflow
- Logic for HTTP trigger and form handling
- Integrations with SaaS Alerts API, SMTP2Go, and Google Cloud Functions
- Basic textual instructions for setup and adaptation

## Requirements for setup
- n8n account with access to HTTP nodes
- Valid API key for SaaS Alerts API
- SMTP2Go account with email sending configured
- Ability to host or invoke Google Cloud Function (if used)

## Benefits and outcomes
- Saves time on manual data collection and cleaning
- Delivers a unified, deduplicated report from multiple sources
- Fully automated email delivery without human intervention
- Clear visibility into sign-in locations for anomaly detection
- Ready-to-use reporting for clients or internal teams

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat