OpenRuna
Sign in
← Workflows

Query List of Sign-in IPs

14 nodes · httpRequest, removeDuplicates, moveBinaryData, convertToFile, form

Engine
n8n
Nodes
14
Trigger
scheduled/triggered
Source file
1854_Removeduplicates_Converttofile_Automation_Webhook.json

Workflow flow

IntegrationsHTTPRemoveDuplicatesMoveBinaryDataConvertToFileFormSetMerge
100%
TRIGGER

Authentication Request Form

Form

Set Date and Form Variables

Set

GET Events - Login Successful

HTTP

GET Events - OAuth Authentication

HTTP

GET Events - Office365 Shell WCSS

HTTP

Combine all Authentication Events

Merge

Filter IP Information

Set

Remove Duplicate IPs

RemoveDuplicates

Convert to CSV

ConvertToFile

Convert CSV to Base64

MoveBinaryData

Send Email Upon Completion (SMTP2Go)

HTTP

11 steps · flows top to bottom, branches left to right

Browse by integration

httpRequestremoveDuplicatesmoveBinaryDataconvertToFileform
Browse all integrations →
Download n8n JSONDownload sanitized JSONDownload flow graph

Import into n8n

  1. Download the n8n JSON file (full or sanitized).
  2. In n8n: Workflows → Import from file.
  3. Open each node and reconnect credentials to your accounts.
  4. Test with manual execution before enabling triggers.

Sanitized JSON removes credential IDs — safer for sharing. Flow graph JSON is OpenRuna's lightweight format for diagrams and other tools, not n8n import.

View source corpus ↗

Overview

Query List of Sign-in IPs is a free n8n workflow on OpenRuna — 14 nodes connecting httpRequest, removeDuplicates, moveBinaryData, convertToFile, form. Download the JSON, view the flow diagram, and import it into your n8n instance.

What this workflow does

Built in n8n, "Query List of Sign-in IPs" chains 14 nodes to move data between httpRequest, removeDuplicates, moveBinaryData, convertToFile, form. 14 nodes · httpRequest, removeDuplicates, moveBinaryData, convertToFile, form A scheduled/triggered entry point kicks it off, and each node passes data to the next until the run completes. OpenRuna shows the full flow diagram, an integration breakdown, and a one-click JSON export for n8n's "Import from file". Use it to learn integration patterns, fork it for your own use case, or deploy it quickly after reconnecting credentials.

Use cases

  • Study how data moves from httpRequest to removeDuplicates before building your own variant.
  • Share it with your team as a documented reference for scheduled/triggered automations in the httpRequest stack.
  • Import "Query List of Sign-in IPs" into n8n, reconnect credentials for httpRequest, removeDuplicates, moveBinaryData, convertToFile, form, and run the same automation in your own workspace.
  • Use it as a starting template when wiring httpRequest, removeDuplicates, moveBinaryData, convertToFile, form — adjust node parameters to your accounts and record IDs.

Example output

Imported into n8n, "Query List of Sign-in IPs" exposes 14 configured nodes. Trigger type: scheduled/triggered. Integrations: httpRequest, removeDuplicates, moveBinaryData, convertToFile, form. Open each node after import to map credentials to your own httpRequest and removeDuplicates accounts. Run it once in test mode to verify any branch logic (Switch/IF nodes) before enabling production triggers.

Tips by platform

Claude

Ask Claude to turn the "Query List of Sign-in IPs" JSON into a plain-English runbook, node by node. It can flag where httpRequest rate limits or missing retries might bite before you go live.

ChatGPT

Drop the workflow JSON or this OpenRuna page URL into ChatGPT and ask for a step-by-step runbook: triggers, branches, and which fields to customise for httpRequest, removeDuplicates, moveBinaryData, convertToFile, form. Handy for onboarding teammates new to n8n.

Cursor

In Cursor, ask Agent mode to parameterise "Query List of Sign-in IPs" — extract httpRequest IDs and secrets into environment variables without changing the 14-node structure.

Frequently asked questions

How do I import "Query List of Sign-in IPs" into n8n?
Click Download n8n JSON on this page, then in n8n choose Workflows → Import from file and select the downloaded file. Reconnect credentials on each node — the export carries credential IDs from the original author's instance, not working secrets.
Which integrations does "Query List of Sign-in IPs" use?
It uses: httpRequest, removeDuplicates, moveBinaryData, convertToFile, form. The flow diagram above shows how each service connects across the 14 nodes. Filter OpenRuna by integration to find related workflows and tools.
Can I import a sanitized export without credentials?
Yes. Use "Download sanitized JSON" to strip credential references before sharing internally. You will still add your own httpRequest and removeDuplicates credentials in n8n after import.
What trigger type does "Query List of Sign-in IPs" use?
Trigger type: scheduled/triggered. After import, confirm the trigger node (webhook, schedule, or app event) matches your environment, then activate the workflow when you are ready to run it.
Is "Query List of Sign-in IPs" free to use?
OpenRuna catalogs community n8n workflows under open licenses. Check the source corpus link for the original license; commercial use may require verifying the third-party API terms for httpRequest, removeDuplicates, moveBinaryData, convertToFile, form.

Related resources