Automated SWIFT/BIC Code Scraper with MongoDB Integration
detail.loadingPreview
This n8n workflow automates the extraction of SWIFT/BIC codes, bank names, cities, and branches from `theswiftcodes.com`. It efficiently navigates country-specific pages, handles multi-page results, normalizes country data, and stores all collected information directly into a MongoDB database.
About This Workflow
This robust n8n workflow provides a comprehensive solution for gathering essential SWIFT/BIC code data from a web source. It intelligently begins by programmatically identifying all available countries, then proceeds to process each country's dedicated listing page. For countries with extensive banking networks, the workflow is designed to seamlessly handle pagination, ensuring every piece of relevant data is captured. It integrates with the uProc service for country code normalization, guaranteeing data consistency and quality. Finally, all extracted bank details, including names, SWIFT codes, branches, and cities, are meticulously structured and persisted into a MongoDB collection, making it an ideal tool for building financial data repositories or enriching existing datasets.
Key Features
- Automated Country Discovery: Automatically scrapes a directory page to identify all available countries for detailed data extraction.
- Smart Pagination Handling: Seamlessly navigates through multiple pages of results for each country, ensuring comprehensive data capture without manual intervention.
- Country Data Normalization: Utilizes the uProc service to standardize country names into ISO codes, enhancing data quality and consistency across your dataset.
- MongoDB Integration: Directly stores all extracted SWIFT/BIC code data (bank name, swift code, city, branch) into a specified MongoDB collection, providing a structured and persistent storage solution.
- Web Scraping Capabilities: Leverages n8n's powerful HTTP Request and HTML Extract nodes for efficient and precise data retrieval from complex web pages.
How To Use
- Set Up Credentials: Ensure you have active and valid credentials configured for both
uProcApi(e.g.,uproc-miquel) andMongoDB(e.g.,db-mongo) within your n8n instance. - Configure MongoDB Collection: Verify or update the
collectionname in theMongoDB1node (currentlyswifts.meetup) to specify your desired database and collection for storing the extracted data. - Execute Workflow: Initiate the data extraction process by manually executing the workflow via the 'On clicking 'execute'' node.
- Monitor Progress: Observe the workflow execution to confirm that data is being successfully extracted from
theswiftcodes.comand inserted into your MongoDB instance. - Review Data: After the workflow completes, connect to your MongoDB database to review and verify the scraped SWIFT/BIC code data.
Apps Used
Workflow JSON
{
"id": "d9c8802a-0ad0-4723-9489-af55f165b9af",
"name": "Automated SWIFT/BIC Code Scraper with MongoDB Integration",
"nodes": 13,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: d9c8802a-0ad0...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.