{"nodes":[{"name":"On clicking 'execute'","type":"n8n-nodes-base.manualTrigger","disabled":true,"position":[70,140],"parameters":{},"typeVersion":1,"id":"node-1839d0bc"},{"name":"Cron","type":"n8n-nodes-base.cron","position":[70,320],"parameters":{"triggerTimes":{"item":[{"hour":8}]}},"typeVersion":1,"id":"node-fa77dce6"},{"name":"Telegram","type":"n8n-nodes-base.telegram","position":[620,210],"parameters":{"text":"LIMPOU PACOTES TRANSPORTE-RECEBIDO PONTO MIX","chatId":"-657820242","additionalFields":{}},"credentials":{"telegramApi":{"id":"{{ $credentials.telegramApi.id }}","name":"Telegram account"}},"typeVersion":1,"id":"node-b9459171"},{"name":"Telegram1","type":"n8n-nodes-base.telegram","position":[620,460],"parameters":{"text":"LIMPOU PACOTES TRANSPORTE-RECEBIDO OBJETIVA","chatId":"-657820242","additionalFields":{}},"credentials":{"telegramApi":{"id":"{{ $credentials.telegramApi.id }}","name":"Telegram account"}},"typeVersion":1,"id":"node-a7bc6d31"},{"name":"Webhook","type":"n8n-nodes-base.webhook","position":[70,480],"webhookId":"7ecb2d2f-5a09-44a5-a7bc-27f188c74e0b","parameters":{"path":"limparPacotes","options":{}},"typeVersion":1,"id":"node-fc998899"},{"name":"limparPacoteCliente1","type":"n8n-nodes-base.mySql","position":[380,470],"parameters":{"query":"-- LIMPAR ETIQUETAS ANTIGAS \nwith t as (\nselect token from i_objeto where modulo = 'pacoteProduto' and situacao = 'TRANSPORTE-RECEBIDO' and data <= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)\n)\nupdate i_objeto \nset modulo = 'DELETE'\nwhere modulo = 'pacoteProduto' and token in (select token from t)","operation":"executeQuery"},"credentials":{"mySql":{"id":"{{ $credentials.mySql.id }}","name":"OBJ"}},"typeVersion":1,"id":"node-79193f15"},{"name":"limpaPacoteCliente0","type":"n8n-nodes-base.mySql","position":[380,210],"parameters":{"query":"-- LIMPAR ETIQUETAS ANTIGAS \nwith t as (\nselect token from i_objeto where modulo = 'pacoteProduto' and situacao = 'TRANSPORTE-RECEBIDO' and data <= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)\n)\nupdate i_objeto \nset modulo = 'DELETE'\nwhere modulo = 'pacoteProduto' and token in (select token from t)","operation":"executeQuery"},"credentials":{"mySql":{"id":"{{ $credentials.mySql.id }}","name":"PPM"}},"typeVersion":1,"id":"node-bff62c7b"},{"id":"error-efff0495","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"connections":{},"name":"Production Workflow","settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3},"meta":{"instanceId":"workflow-0b76ade6","versionId":"1.0.0","createdAt":"2025-09-29T07:07:56.146131","updatedAt":"2025-09-29T07:07:56.146142","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"description":"Production-ready workflow: Production Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}