Workflow: Splitinbatches Workflow
Integrations: gmail, gmailTrigger, manualTrigger, set, slack, splitInBatches, stopAndError

{"id": "dDInVHNAfSedBUCb", "meta": {"instanceId": "workflow-eb4760f8", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:50.179298", "updatedAt": "2025-09-29T07:07:50.179305", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "Splitinbatches Workflow", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "09c19ba1-45f2-43af-9985-3508d801c1b7", "name": "Loop Over Items", "type": "n8n-nodes-base.splitInBatches", "position": [440, 0], "parameters": {"options": {}}, "typeVersion": 3, "notes": "This splitInBatches node performs automated tasks as part of the workflow."}, {"id": "18625b1d-f8ff-4e48-8b64-a9d42d24eccc", "name": "Click to Test Flow", "type": "n8n-nodes-base.manualTrigger", "position": [40, 0], "parameters": {}, "typeVersion": 1, "notes": "This manualTrigger node performs automated tasks as part of the workflow."}, {"id": "649933c4-b16b-46de-9038-7d8c0b3d8e88", "name": "Get emails from Gmail with certain subject", "type": "n8n-nodes-base.gmail", "position": [220, 0], "webhookId": "99c4deca-17c7-47ae-a38c-50344938e792", "parameters": {"simple": false, "filters": {"q": "subject:\u900f\u904e Uber Eats \u7cfb\u7d71\u9001\u51fa\u7684\u8a02\u55ae"}, "options": {}, "operation": "getAll", "returnAll": true}, "credentials": {"gmailOAuth2": {"id": "34rX9kxKlJadOY6u", "name": "Gmail account"}}, "typeVersion": 2.1, "notes": "This gmail node performs automated tasks as part of the workflow."}, {"id": "b2118a34-52ad-4464-b7ea-7f3105536fad", "name": "Receive certain keyword Gmail Trigger", "type": "n8n-nodes-base.gmailTrigger", "position": [120, -180], "parameters": {"simple": false, "filters": {"q": "subject:\u900f\u904e Uber Eats \u7cfb\u7d71\u9001\u51fa\u7684\u8a02\u55ae"}, "options": {}, "pollTimes": {"item": [{"mode": "everyHour", "minute": 30}]}}, "credentials": {"gmailOAuth2": {"id": "34rX9kxKlJadOY6u", "name": "Gmail account"}}, "typeVersion": 1.2, "notes": "This gmailTrigger node performs automated tasks as part of the workflow."}, {"id": "00986543-d01a-4b11-bbaa-60c73a1dae02", "name": "Extract Price, Shop, Date, TIme", "type": "n8n-nodes-base.set", "position": [620, 60], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "c24405f8-267f-4933-a178-1b51145d62bf", "name": "price", "type": "string", "value": "={{ $json[\"text\"].match(/\\$(\\d+(\\.\\d{2})?)/)[1] }}"}, {"id": "968cf7cd-6e28-4328-a829-3fe2cb327643", "name": "shop", "type": "string", "value": "={{ $json[\"text\"].match(/\u4ee5\u4e0b\u662f\u60a8\u5728([\\u4e00-\\u9fa5a-zA-Z0-9\\s]+)\u8a02\u8cfc/)[1] }}"}, {"id": "53642bcb-f3a6-4086-bdc1-2f8d27927462", "name": "date", "type": "string", "value": "={{ $json[\"text\"].match(/Date: (\\d{4}\u5e74\\d{1,2}\u6708\\d{1,2}\u65e5)/)[1].replace(\"\u5e74\", \".\").replace(\"\u6708\", \".\").replace(\"\u65e5\", \"\") }}"}, {"id": "cd227132-971b-4970-8b5d-724463efe036", "name": "time", "type": "string", "value": "={{ \n  $json[\"text\"].match(/(\u4e0a\u5348|\u4e0b\u5348) (\\d{1,2}):(\\d{2})/) ? \n  ($json[\"text\"].match(/(\u4e0a\u5348|\u4e0b\u5348) (\\d{1,2}):(\\d{2})/)[1] === '\u4e0b\u5348' && $json[\"text\"].match(/(\u4e0a\u5348|\u4e0b\u5348) (\\d{1,2}):(\\d{2})/)[2] !== '12' \n    ? (parseInt($json[\"text\"].match(/(\u4e0a\u5348|\u4e0b\u5348) (\\d{1,2}):(\\d{2})/)[2]) + 12) + ':' + $json[\"text\"].match(/(\u4e0a\u5348|\u4e0b\u5348) (\\d{1,2}):(\\d{2})/)[3] \n    : $json[\"text\"].match(/(\u4e0a\u5348|\u4e0b\u5348) (\\d{1,2}):(\\d{2})/)[2] + ':' + $json[\"text\"].match(/(\u4e0a\u5348|\u4e0b\u5348) (\\d{1,2}):(\\d{2})/)[3]\n  )\n  : null \n}}"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "3d8f97ea-4a0d-4939-898f-8a0ca9415e7d", "name": "Send to Slack with Block", "type": "n8n-nodes-base.slack", "position": [800, 60], "webhookId": "0e812732-74d2-4924-8db3-6b9234965937", "parameters": {"text": "=Ubereat \u8a02\u9910\u8cc7\u8a0a: \n\u5546\u5bb6:  {{ $json.shop }}\n\u91d1\u984d: {{ $json.price }}\n\u65e5\u671f: {{ $json.date }}\n\n\u8a18\u5e33\u7db2\u5740:\nmoze3://expense?amount={{ $json.price }}&account=\u4fe1\u7528\u5361&subcategory=\u5916\u9001&store={{ $json.shop }}&date={{ $json.date }}", "select": "channel", "blocksUi": "={\n\t\"blocks\": [\n\t\t{\n\t\t\t\"type\": \"section\",\n\t\t\t\"text\": {\n\t\t\t\t\"type\": \"mrkdwn\",\n\t\t\t\t\"text\": \"Ubereat \u8a02\u9910\u8cc7\u8a0a:\\n\\n*\u5546\u5bb6:* {{ $json.shop }}\\n*\u91d1\u984d:* {{ $json.price }}\\n*\u65e5\u671f:* {{ $json.date }}\"\n\t\t\t}\n\t\t},\n\t\t{\n\t\t\t\"type\": \"divider\"\n\t\t},\n\t\t{\n\t\t\t\"type\": \"section\",\n\t\t\t\"text\": {\n\t\t\t\t\"type\": \"mrkdwn\",\n\t\t\t\t\"text\": \"Moze \u8a18\u5e33\u8acb\u9ede\u6211\"\n\t\t\t},\n\t\t\t\"accessory\": {\n\t\t\t\t\"type\": \"button\",\n\t\t\t\t\"text\": {\n\t\t\t\t\t\"type\": \"plain_text\",\n\t\t\t\t\t\"text\": \"\u8a18\u5e33\",\n\t\t\t\t\t\"emoji\": true\n\t\t\t\t},\n\t\t\t\t\"value\": \"click\",\n\t\t\t\t\"url\": \"moze3://expense?amount={{ $json.price }}&account=\u4fe1\u7528\u5361&subcategory=\u5916\u9001&store={{ $json.shop }}&date={{ $json.date }}&&project=\u751f\u6d3b\u958b\u92b7&&time={{ $json.time }}\",\n\t\t\t\t\"action_id\": \"button-action\"\n\t\t\t}\n\t\t}\n\t]\n}", "channelId": {"__rl": true, "mode": "list", "value": "C0883CJM1UH", "cachedResultName": "\u5916\u9001\u8a18\u5e33\u81ea\u52d5\u5316"}, "messageType": "block", "otherOptions": {}, "authentication": "{{ $credentials.oAuth2 }}"}, "credentials": {"slackOAuth2Api": {"id": "sD1J9ZLyEhcglrRa", "name": "Slack account"}}, "typeVersion": 2.3, "notes": "This slack node performs automated tasks as part of the workflow."}, {"id": "error-f597a38f", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [1000, 400], "parameters": {"message": "Workflow execution error", "options": {}}}], "active": true, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "0840254c-0058-47fe-9b22-7fbb93144788", "connections": {"3d8f97ea-4a0d-4939-898f-8a0ca9415e7d": {"main": [[{"node": "error-handler-3d8f97ea-4a0d-4939-898f-8a0ca9415e7d-146d943d", "type": "main", "index": 0}]]}}, "description": "Automated workflow: Splitinbatches Workflow. This workflow processes data and performs automated tasks.", "notes": "Excellent quality workflow: Splitinbatches Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}