A developer sought to build a production-ready automation system, moving beyond basic tutorials. Using n8n, they created a two-workflow system focused on safety, testing, and idempotency. This approach ensures that data is reliably ingested, stored, and processed without duplicates, even if workflows are re-run.

The system is divided into two distinct workflows. The first, triggered by a webhook, appends incoming data to a Google Sheet. The second, running on a schedule, processes only pending rows, sends emails, and updates statuses. This separation enhances testability and maintainability. Each workflow is designed to handle its specific responsibility, making the system robust and scalable.

The developer emphasizes the importance of idempotency to prevent duplicate processing and ensure that failures don't disrupt the system. They also highlight the value of schema-first design and thorough testing, which are critical for building reliable automation systems. This project serves as a practical example for those looking to move from simple automations to production-grade solutions.