{"product_id":"doctor-facility-extraction-from-shop-banners-openai-aws-sns","title":"Doctor \u0026 Facility Extraction from Shop Banners (OpenAI, AWS SNS)","description":"\u003ch3\u003eExtract doctors \u0026amp; facility details from medical shop banners and publish the results via AWS SNS\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives a POST webhook request\u003c\/b\u003e and immediately returns an acknowledgement containing the \u003ci\u003eexecution\u003c\/i\u003e and \u003ci\u003eworkflow\u003c\/i\u003e IDs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFetches the source banner image\u003c\/b\u003e by calling a separate n8n “file import” (file-management) workflow using values from the webhook payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eResizes the image\u003c\/b\u003e to a maximum of \u003cb\u003e800×800\u003c\/b\u003e to prepare it for vision processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates and extracts data with OpenAI GPT-4o\u003c\/b\u003e via an AI Agent: it checks that the banner is readable and extracts doctor and facility fields into a \u003cb\u003estrict JSON schema\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePackages the extraction result\u003c\/b\u003e with success metadata (including \u003cb\u003eexecutionRequestId\u003c\/b\u003e and \u003cb\u003equeryId\u003c\/b\u003e from the webhook), then converts the payload to a \u003cb\u003eBase64\u003c\/b\u003e string.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePublishes to AWS SNS\u003c\/b\u003e: 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.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomating medical directory enrichment by extracting doctor names, specialties, and facility details directly from shop banners.\u003c\/li\u003e\n  \u003cli\u003eTriggering downstream systems (CRMs, ERPs, indexing services) through \u003cb\u003eAWS SNS\u003c\/b\u003e once banner-to-JSON conversion is complete.\u003c\/li\u003e\n  \u003cli\u003eBuilding a robust pipeline where extraction failures are also emitted for monitoring and retries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eWebhook\u003c\/b\u003e (POST) entry point with immediate acknowledgement.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEdit image\u003c\/b\u003e step for resizing (max 800×800).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI GPT-4o\u003c\/b\u003e AI Agent for structured doctor \u0026amp; facility extraction into strict JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBase64 encoding\u003c\/b\u003e for transport-ready payloads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAWS SNS\u003c\/b\u003e node to publish success and error notifications to the SNS topic ARN.\u003c\/li\u003e\n  \u003cli\u003eAdditional workflow nodes include \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, and an \u003cb\u003eerror trigger\u003c\/b\u003e path.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eSetup summary:\u003c\/b\u003e 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46068030963891,"sku":"N8N-19774","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/VxbMpQjC0RONs4OTn1Bzm_Iu7ZDTqS.png?v=1789981618","url":"https:\/\/buyflowscripts.com\/products\/doctor-facility-extraction-from-shop-banners-openai-aws-sns","provider":"N8N Commerce","version":"1.0","type":"link"}