{"id":"JJKkNnO4PQ12gQdE","meta":{"instanceId":"workflow-860d423a","versionId":"1.0.0","createdAt":"2025-09-29T07:07:52.095545","updatedAt":"2025-09-29T07:07:52.095558","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"name":"Retry Execution Hourly","nodes":[{"id":"ca8badce-4a43-4e86-acb8-6a3939ffa597","name":"When clicking ‘Test workflow’","type":"n8n-nodes-base.manualTrigger","position":[580,740],"parameters":{},"typeVersion":1,"notes":"This manualTrigger node performs automated tasks as part of the workflow."},{"id":"7867cbd1-bf14-488d-9bbf-11d4478f93f2","name":"n8n","type":"n8n-nodes-base.n8n","position":[1160,860],"parameters":{"filters":{"status":"error"},"options":{"activeWorkflows":false},"resource":"execution","returnAll":true,"requestOptions":{}},"credentials":{"n8nApi":{"id":"m9lkUOoNENYqXZIQ","name":"Gatu a/c"}},"typeVersion":1,"notes":"This n8n node performs automated tasks as part of the workflow."},{"id":"b9826e10-43b9-4a21-b2f8-f91fdee3e6a2","name":"Log into n8n","type":"n8n-nodes-base.httpRequest","position":[960,860],"parameters":{"url":"{{ $env.BASE_URL }}","method":"POST","options":{"response":{"response":{"fullResponse":true}}},"sendBody":true,"sendHeaders":true,"bodyParameters":{"parameters":[{"name":"email","value":"={{ $json.username }}"},{"name":"password","value":"={{ $json.password }}"}]},"headerParameters":{"parameters":[{"name":"accept","value":"application/json, text/plain, */*"},{"name":"accept-language","value":"en-US,en;q=0.9"},{"name":"user-agent","value":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36"}]}},"retryOnFail":true,"typeVersion":4.2,"notes":"This httpRequest node performs automated tasks as part of the workflow."},{"id":"1ca0527f-ccc4-4b3f-b585-94550987e0d3","name":"retry workflow automatically","type":"n8n-nodes-base.httpRequest","onError":"continueRegularOutput","position":[2080,980],"parameters":{"url":"{{ $env.BASE_URL }}","method":"POST","options":{"redirect":{"redirect":{}}},"sendBody":true,"sendHeaders":true,"bodyParameters":{"parameters":[{"name":"loadWorkflow","value":"true"}]},"headerParameters":{"parameters":[{"name":"accept","value":"application/json, text/plain, */*"},{"name":"accept-language","value":"en-US,en;q=0.9"},{"name":"cookie","value":"={{ $('Log into n8n').item.json.headers['set-cookie'][0] }}"},{"name":"user-agent","value":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36"}]}},"retryOnFail":true,"typeVersion":4.2,"notes":"This httpRequest node performs automated tasks as part of the workflow."},{"id":"b0b2f473-e12c-4377-80d3-46b18faa09b9","name":"If Node","type":"n8n-nodes-base.if","position":[1380,860],"parameters":{"options":{},"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"06acbcc4-1a82-4063-8a92-2ebbc6597b4b","operator":{"type":"string","operation":"notEmpty","singleValue":true},"leftValue":"={{ $json.retrySuccessId }}","rightValue":""}]}},"typeVersion":2.2,"notes":"This if node performs automated tasks as part of the workflow."},{"id":"6ea6fe2c-de31-4628-87b1-69e7ba867030","name":"No Operation, do nothing","type":"n8n-nodes-base.noOp","position":[1620,680],"parameters":{},"typeVersion":1,"notes":"This noOp node performs automated tasks as part of the workflow."},{"id":"851277e1-5b0e-4391-8174-2c118aacfa30","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[100,780],"parameters":{"width":383.5091496232509,"height":285.0376749192681,"content":"- ## check for failed executions hourly.\n- ## filter out those that have successful reexecution ids.\n- ## log into n8n and get the session ids.\n- ## retry the executions.\n\n- h\n"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"5b8bf8c1-f505-42da-936d-637394e71b34","name":"login_details","type":"n8n-nodes-base.set","position":[760,860],"parameters":{"options":{},"assignments":{"assignments":[{"id":"3edb7f73-73cb-44f4-b891-8499598d9b0a","name":"username","type":"string","value":"gaturanjenga@gmail.com"},{"id":"bc07f892-aacf-4f7c-96d1-64a9e28a4d92","name":"password","type":"string","value":"Password123"},{"id":"59874894-b1ec-4a31-949e-9c3834d68d47","name":"n8n_instance","type":"string","value":"{{ $env.WEBHOOK_URL }}"},{"id":"68c77c33-15e0-4505-90d0-8129e7a8fbba","name":"executionid","type":"string","value":"={{ $json.id }}"}]}},"typeVersion":3.4,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"74716a90-25a2-48b6-b342-197fe3807a3d","name":"Loop Over Items","type":"n8n-nodes-base.splitInBatches","position":[1620,940],"parameters":{"options":{},"batchSize":5},"typeVersion":3,"notes":"This splitInBatches node performs automated tasks as part of the workflow."},{"id":"6439f486-68d4-4f9e-8e7f-3df909e32324","name":"Schedule Trigger","type":"n8n-nodes-base.scheduleTrigger","position":[580,980],"parameters":{"rule":{"interval":[{"field":"hours"}]}},"typeVersion":1.2,"notes":"This scheduleTrigger node performs automated tasks as part of the workflow."},{"id":"882c03ea-d9e0-4d00-b4c6-5a1c55994fb0","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[740,740],"parameters":{"color":4,"width":349.5813953488373,"height":278.232558139535,"content":"## Set the login credential details in the set node, and login to n8n via api."},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"bcc4d7e3-a91e-4c90-a018-56c6321f6ae2","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[1140,740],"parameters":{"color":2,"width":343.81395348837225,"height":263.8139534883721,"content":"## Get all `Error` executions.\n- ### Filter out those that have been successfully retried\n"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"9219f2a8-8b71-45e0-a987-7e8c1a6364fe","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[1780,880],"parameters":{"color":5,"width":444.7441860465116,"height":268.139534883721,"content":"## Retry the executions.\n- ### Feel free to add notifications error messages for failed one to  email or slack"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"versionId":"eb687638-734c-4feb-af5a-b49cf1dc661b","connections":{"Log into n8n":{"main":[[],[],[],[],[],[],[],[],[]]},"retry workflow automatically":{"main":[[],[],[],[],[],[],[],[],[]]}},"description":"Automated workflow: Retry Execution Hourly. This workflow integrates 10 different services: stickyNote, httpRequest, scheduleTrigger, n8n, set. It contains 17 nodes and follows best practices for error handling and security.","notes":"Excellent quality workflow: Retry Execution Hourly. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}