시니어 n8n 자동화 아키텍트

WORKFLOW OVERVIEW: This workflow receives a webhook trigger, validates the payload, processes the data through a series of transformations, and outputs the result to a database and an external API. NODES (in execution order): - Webhook: n8n-nodes-base.webhook Input: External HTTP POST request Operation: Receive payload Parameters: - HTTP Method: POST - Path: /trigger - Response Mode: On Received - Validate Payload: n8n-nodes-base.function Input: Webhook data Operation: Custom validation logic Parameters: - Function Code: Check required fields [FIELD_REQUIRED], reject if missing - Error Output: true - Transform Data: n8n-nodes-base.function Input: Validated payload Operation: Map and reshape data Parameters: - Function Code: Convert [SOURCE_FIELD] to [TARGET_FIELD], apply [FORMAT] - Keep Placeholders: [SOURCE_FIELD], [TARGET_FIELD], [FORMAT] - Insert Database: n8n-nodes-base.postgres Input: Transformed data Operation: Insert Parameters: - Table: [TABLE_NAME] - Columns: [COLUMN1], [COLUMN2] - Values: ={{ $json.[TARGET_FIELD] }} - Call External API: n8n-nodes-base.httpRequest Input: Transformed data Operation: POST Parameters: - URL: https://api.example.com/endpoint - Authentication: Predefined Credential - Body: ={{ $json }} CONNECTIONS: Webhook -> Validate Payload -> Transform Data -> Insert Database -> Call External API (branch: if validation fails, Validate Payload -> Error Output) ERROR HANDLING: - Validate Payload: On error, output to 'Error Output' node (n8n-nodes-base.stopAndError) with custom message - Insert Database: Enable retry on failure (3 attempts, 2s delay) via node settings - Call External API: Add 'On Error' branch to log failure to n8n-nodes-base.telegram (or email) and continue SECURITY: - Webhook: Enable 'Allow CORS' only for trusted domains, use 'Authentication' with header 'X-API-Key' and validate against environment variable - Postgres: Use credential with least-privilege user, store in n8n credentials vault - External API: Use OAuth2 or API key stored in n8n credentials, never hardcode DEPLOYMENT: - Run in queue mode (main process + worker) for scalability - Set webhook path to a non-guessable string (e.g., /trigger/[UUID]) - Use environment variables for all secrets and table names - Enable 'Save Execution Progress' for debugging in production - Monitor via n8n built-in logs and set up alerting on error outputs