This n8n workflow automates the process of monitoring a designated FTP folder for new PDF reports every 15 minutes. When a new report is detected, it is parsed and analyzed to extract key insights, metrics, findings, and sentiment using advanced AI. Based on this analysis, the workflow formats alerts and sends them via Slack and email to inform your team about important updates or issues. Additionally, each processed report is logged into a database for record-keeping and further analysis.

The workflow begins with a scheduled trigger every 15 minutes, checking the FTP directory for new files. It filters out only PDF files, then parses each report’s content using a PDF vector analysis node that leverages AI to extract relevant information.

Next, the extracted content is processed to identify key insights, such as report type, date, metrics, findings, and overall sentiment. Based on this analysis, a formatted alert message is created, highlighting the report’s importance and details. The alerts are then dispatched via Slack channel ‘#reports’ and email, ensuring prompt communication.

Finally, each report and its insights are logged into a PostgreSQL database, maintaining a comprehensive record of processed reports.

This workflow is ideal for organizations that need to monitor and analyze incoming reports automatically, ensuring timely responses to critical issues and efficient data management.