{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/8c20e567e61440598987471b93aed2fa\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/os/loom-media-content/loom/4302706d-e3bd-4afc-9132-04e51d457cee/de08657e-5dbc-45fa-8686-ec6bc40cea62/sessions-thumbnails-8c20e567e61440598987471b93aed2fa-7f9cd6b36b45cf66.gif/binary?authToken=eyJraWQiOiJtaWNyb3MtZ3JvdXAvdGRwLW9zLWFyY2hldHlwZS9iajFmZm9xaWRscTFydTFtIiwiYWxnIjoiUlMyNTYifQ.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTUyNjEwMjMsInRpIjoiZWNjMDlkZjMtYzI2OS00NWRhLTllYTItNzg2MTE1NzQ0MWJkIiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiIyMjQ1YWRlYS1lN2U5LTQyMGUtOWY2NC1kOTY5OGRhODcyZGQiLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy04YzIwZTU2N2U2MTQ0MDU5ODk4NzQ3MWI5M2FlZDJmYS03ZjljZDZiMzZiNDVjZjY2LmdpZiIsImV4cCI6MTc5NTI2MTYyMywiaWF0IjoxNzk1MjYxMDIzLCJqdGkiOiI2MDliMDYyZi0xYWE5LTRhY2MtYTQzNy1hOGRlYzk0NTM1MzYifQ.OJqaqYKjAitWyaLKQ2EMPZlCLPZw5-W1bFQtFDY6VM2URysaFDvATfcTkS946RhCetEsS7bVZ2vQb-x8e8r-UMmlhN7K5kEgyyVrlR4HP8rhQBe2zsUbuos0KPLK6nk0LnzNQKmGP_WMTYc4hzubKLNGR6RshM6lSC-W3D1rnFEAXAAzswcZAyqbvRxboxUKQdwXgFGs09sJrl6Xh5TLgWTOF7avBudvf3fSiQC0GOkS6xgntum1CiX3EruwCRiOZg5lMcAYSyjZpsTgO93kvhrcRt6IbndxZKAJfL-gxrMhq2RorZLRzMPo3TjDS1qHRUGhREbqUUN76eFtrAR3IQ&Expires=1795261624&Signature=YVXBpIcxM4MRRX6IYz3TKJLEnotYN9gEnxEXSLh-kmliuVMYS6U6UyR0JrAG6DAkaNeuLn1T6s3Yxk%7EusETpzW50w0U7EvkVLIsyK-MoXVdPcAiP4WjKbwZMpDlYXJWS2d6AvWKFhWprYtmxYLS3mpugYVVPKZIMiTOI2vsvYNGJeAxxzY-UNKOboXOcXNSQhu6CRi4uPJwgbI1oXv5HM-0Pt%7EOERh7WhErUT6z0pCl3Nszt005CHCrG4CeonG2OBG1p7DNZnlDXOfq3SPwh3Jaj4q0Y6YchjK3YIYIyxu1ffZWz1cpT-sXJXE7XnVN25qrhco4I2Ed0asjPJLSw0Q__&Key-Pair-Id=KQOSYIR44AIC0","duration":214.158,"title":"Reliable n8n Batch Processor: Validation, Retries, Logging &amp; Email Alerts","description":"This video shows a reliable batch processing workflow I built in n8n. It solves a common problem: when many records are processed automatically, bad data can get through, the same record can run twice, and a failed API call can break everything without anyone knowing.\n\nThe workflow prepares and validates the input data, sends invalid records to a separate sheet so they never reach the API, removes duplicates, and skips IDs that were already processed. Valid records go to an HTTP API call with automatic retries. If the call still fails, the error is formatted, logged in Google Sheets, and an alert email is sent. Successful records are logged too.\n\nTo test it, I changed the API URL to force a failure and reran the workflow, then confirmed that the error branch worked and that records already processed were not processed twice.\n\nTools: n8n, HTTP Request, Google Sheets, Gmail, JavaScript Code nodes."}