Skip to content
NEWError doctor and Watchtower: failed n8n runs explained in plain words, and emailed to you. See what is new

Library / Security & Compliance

Security & Compliance

Export Sign-in IP Lists and Email as CSV

When a form is submitted, it fetches successful login events, removes duplicate IPs, builds a CSV and emails it via SMTP2Go.

What it does

# Query List of Sign-in IPs ## Overview Automated workflow: Query List of Sign-in IPs. This workflow integrates 9 different services: convertToFile, stickyNote, httpRequest, formTrigger, merge. It contains 23 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 23 - Node Types: 9 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - GET Events - Login Successful: httpRequest - Sticky Note: stickyNote - Sticky Note1: stickyNote - Sticky Note2: stickyNote - Send Email Upon Completion (SMTP2Go): httpRequest - Remove Duplicate IPs: removeDuplicates - Convert CSV to Base64: moveBinaryData - Convert to CSV: convertToFile - Filter IP Information: set - Combine all Authentication Events: merge - ... and 13 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible

The steps

  1. GET Events - Login Successful
  2. Send Email Upon Completion (SMTP2Go)
  3. Remove Duplicate IPs
  4. Convert CSV to Base64
  5. Convert to CSV
  6. Filter IP Information
  7. Combine all Authentication Events
  8. GET Events - OAuth Authentication
  9. GET Events - Office365 Shell WCSS
  10. Set Date and Form Variables
  11. Authentication Request Form
  12. Error Handler
  13. Stopanderror 1
  14. Stopanderror 2

49 steps in total.

Similar automations