N8n expert

n8n Developer Needed – Outlook PDF Processing & Case Creation Automation Project Overview We are looking for an experienced n8n developer to build a production-ready workflow that automatically creates cases from incoming Outlook emails and webhook submissions. The workflow should: Monitor a dedicated Outlook folder Detect new emails containing PDF attachments Extract structured data from PDFs Validate and normalize data Prevent duplicates Create cases in our job management system Log all processing and errors Goal Incoming Outlook emails contain PDF attachments with work order information. The workflow must extract the data, validate it, prevent duplicates, and create the corresponding case automatically. Workflow Outlook Folder or Webhook ↓ Validate Input ↓ Extract PDF Data ↓ Normalize Fields ↓ Duplicate Check ↓ Create Case ↓ Log Result ↓ Move Email to Done or Error Outlook Processing Folder structure: Cases/New Cases/Processing Cases/Done Cases/Error Requirements: Process unread emails only Process emails with PDF attachments only Move email to Processing before extraction Move email to Done after successful processing Move email to Error if processing fails Process one email at a time Prevent duplicate case creation Webhook Requirement The workflow must also support case creation through a webhook. Example endpoint: POST /webhook/create-case Example payload: Reference Number Project Name Requestor Customer Name Customer Number Contact Person Address Postal Code City Date Notes The webhook and email workflow should reuse the same validation, duplicate detection, mapping, logging, and case creation logic. PDF Data Extraction Extract available information such as: Reference Number Project Name Requestor Customer Name Customer Number Contact Person Address Postal Code City Date Department Case Type Notes AI-assisted extraction using OpenAI is acceptable. Duplicate Prevention Use the Reference Number as the primary unique identifier. Before creating a case: Search for an existing case Skip or update if already present Create only if it does not exist Error Handling If processing fails: Do not create incomplete cases Move email to Error folder Log the error Send an internal notification Return a clear webhook error response Logging Track: Timestamp Source (Email or Webhook) Reference Number Processing Status Created Case ID Error Message Preferred storage: n8n Data Store Airtable Google Sheets PostgreSQL Deliverables Complete n8n workflow Webhook endpoint Email processing flow PDF extraction logic API integration Duplicate prevention Error handling Logging Documentation Setup guide Testing with sample PDFs Required Experience n8n Outlook integrations PDF extraction OpenAI integrations REST APIs GraphQL APIs Business process automation Proposal Should Include Similar projects completed Recommended architecture Estimated timeline Fixed-price quote Approach for duplicate prevention Approach for PDF extraction validation This should be a stable production automation capable of handling a high volume of incoming requests.