Dynamic search interface with Elasticsearch and automated report generation

Dynamic Search Interface with Elasticsearch and Automated Report Generation

🎯 What this workflow does

This template creates a comprehensive data search and reporting system that allows users to query large datasets through an intuitive web form interface. The system performs real-time searches against Elasticsearch, processes results, and automatically generates structured reports in multiple formats for data analysis and business intelligence.

Key Features: - 🔍 Interactive web form for dynamic data querying - ⚡ Real-time Elasticsearch data retrieval with complex filtering - 📊 Auto-generated reports (Text & CSV formats) with custom formatting - 💾 Automatic file storage system for data persistence - 🎯 Configurable search parameters (amounts, time ranges, entity filters) - 🔧 Scalable architecture for handling large datasets

🛠️ Setup requirements

Prerequisites - Elasticsearch cluster running on https://localhost:9220 - Transaction dataset indexed in banktransactions index - Sample dataset: Download from [Bank Transaction Dataset](https://github.com/dataminexcode/n8n-workflow/blob/main/Dynamic%20Search%20Interface%20with%20Elasticsearch%20and%20Automated%20Report%20Generation/data) - File system access to /tmp/ directory for report storage - HTTP Basic Authentication credentials for Elasticsearch

Required Elasticsearch Index Structure This template uses the Bank Transaction Dataset from GitHub: https://github.com/dataminexcode/n8n-workflow/blob/main/Dynamic%20Search%20Interface%20with%20Elasticsearch%20and%20Automated%20Report%20Generation/data

You can use this python script for importing the csv file into elasticsearch: [Python script for importing data](https://github.com/dataminexcode/n8n-workflow/blob/main/Dynamic%20Search%20Interface%20with%20Elasticsearch%20and%20Automated%20Report%20Generation/pythonscripts/importtoelasticsearch.py)