Redis-Based Item Tracking and Logging Workflow

This n8n workflow serves as a centralized utility for item state management and detailed audit logging using Redis and Google Sheets. Designed to be triggered by other workflows, it ensures idempotency by preventing duplicate processing of items through Redis keys representing various states such as ‘check’, ‘add’, ‘update’, and ‘delete’. The workflow validates the ‘action’ parameter, routes it through a switch node, and performs corresponding Redis operations to track item status, mark items as in-progress, or remove tracking. It also generates comprehensive audit logs for each operation, including timestamps, parent workflow execution URLs, and status updates, which are published via Redis channels for monitoring and troubleshooting. The logs are stored in a Google Sheet for historical tracking, enabling transparency and easy debugging. This workflow is especially useful in scenarios where workflows need to process items idempotently, with a clear audit trail and the ability to easily trace issues back to their origin, making it ideal for automation in eCommerce, CRM, or workflow orchestration contexts.