Doctor & Facility Extraction from Shop Banners (OpenAI, AWS SNS)

Extract doctors & facility details from medical shop banners and publish the results via AWS SNS

This n8n workflow receives a webhook with a shop banner reference, uses OpenAI (GPT-4o) vision to extract structured doctor and medical facility information, then Base64-encodes the JSON and publishes it to an AWS SNS topic—complete with separate SNS notifications for success and errors.

What this workflow does

• Receives a POST webhook request and immediately returns an acknowledgement containing the execution and workflow IDs.
• Fetches the source banner image by calling a separate n8n “file import” (file-management) workflow using values from the webhook payload.
• Resizes the image to a maximum of 800×800 to prepare it for vision processing.
• Validates and extracts data with OpenAI GPT-4o via an AI Agent: it checks that the banner is readable and extracts doctor and facility fields into a strict JSON schema.
• Packages the extraction result with success metadata (including executionRequestId and queryId from the webhook), then converts the payload to a Base64 string.
• Publishes to AWS SNS: success payloads are sent to the configured SNS topic; if any workflow error occurs, a separate Base64-encoded failure payload is published to the same topic via an error path.

Use cases

• Automating medical directory enrichment by extracting doctor names, specialties, and facility details directly from shop banners.
• Triggering downstream systems (CRMs, ERPs, indexing services) through AWS SNS once banner-to-JSON conversion is complete.
• Building a robust pipeline where extraction failures are also emitted for monitoring and retries.

Technical details

• Webhook (POST) entry point with immediate acknowledgement.
• Edit image step for resizing (max 800×800).
• OpenAI GPT-4o AI Agent for structured doctor & facility extraction into strict JSON.
• Base64 encoding for transport-ready payloads.
• AWS SNS node to publish success and error notifications to the SNS topic ARN.
• Additional workflow nodes include set, code, and an error trigger path.

Setup summary: configure an OpenAI credential for the GPT-4o chat model, an AWS credential with permission to publish to the SNS topic, ensure the referenced file-management workflow exists, and map its expected inputs to the webhook payload.