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
- GET Events - Login Successful
- Send Email Upon Completion (SMTP2Go)
- Remove Duplicate IPs
- Convert CSV to Base64
- Convert to CSV
- Filter IP Information
- Combine all Authentication Events
- GET Events - OAuth Authentication
- GET Events - Office365 Shell WCSS
- Set Date and Form Variables
- Authentication Request Form
- Error Handler
- Stopanderror 1
- Stopanderror 2
49 steps in total.
Similar automations