{ "edges": [ { "to": "59f3b9c4-6d16-4b7a-be7b-e0b449965bf6", "from": "3d337e0e-120d-484f-89f3-206d53f17d27", "toPort": "0", "fromPort": "0" }, { "to": "338515e8-2f5c-430f-a96a-5a15d5b42a90", "from": "b7082b51-1e6b-4194-8086-e400401317c4", "toPort": "0", "fromPort": "0" }, { "to": "adc38812-1d54-4a21-901a-bd142150a36e", "from": "338515e8-2f5c-430f-a96a-5a15d5b42a90", "toPort": "0", "fromPort": "0" }, { "to": "1ab38b6f-2392-4143-8906-29455cde1ce3", "from": "adc38812-1d54-4a21-901a-bd142150a36e", "toPort": "0", "fromPort": "0" }, { "to": "59f3b9c4-6d16-4b7a-be7b-e0b449965bf6", "from": "9b03d732-becc-4506-890a-8d0e6cf5bed1", "toPort": "0", "fromPort": "0" }, { "to": "b7082b51-1e6b-4194-8086-e400401317c4", "from": "59f3b9c4-6d16-4b7a-be7b-e0b449965bf6", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "b7082b51-1e6b-4194-8086-e400401317c4", "name": "split_orders", "type": "passthrough", "params": { "mode": "splitOut", "field": "data", "options": {}, "fieldToSplitOut": "data" }, "position": [ 784, 368 ] }, { "id": "338515e8-2f5c-430f-a96a-5a15d5b42a90", "name": "last_24_hours", "type": "passthrough", "params": { "mode": "filter", "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "8efda825-22b2-4754-b994-5cd7053cf79e", "operator": { "type": "dateTime", "operation": "after" }, "leftValue": "={{ $json.metadata.date }}", "rightValue": "={{ $now.minus(24, 'hours') }}" } ] } }, "position": [ 1136, 368 ] }, { "id": "adc38812-1d54-4a21-901a-bd142150a36e", "name": "prepare_email", "type": "code", "params": { "jsCode": "// Normalize incoming data into an array of order objects\n\nlet orders = [];\n\n// Case 1: Each n8n item is one order\nif (items.length > 1) {\n orders = items.map(i => i.json);\n}\n\n// Case 2: A single item contains an array inside json\nelse if (Array.isArray(items[0].json)) {\n orders = items[0].json;\n}\n\n// Case 3: Single item with a single order object\nelse {\n orders = [items[0].json];\n}\n\n// Minimal CSS for readability\nconst styles = `\n \n`;\n\nfunction formatDate(iso) {\n try {\n return new Date(iso).toLocaleString();\n } catch {\n return iso;\n }\n}\n\n// Build HTML per order\nconst ordersHTML = orders\n .map(order => {\n const m = order.metadata || {};\n\n return `\n

Order #${m.id || \"Unknown\"}

\n\n

Status: ${m.order_status || \"Unknown\"}

Total Price: $${m.total_price || \"0.00\"}

Date: ${formatDate(m.date)}

Fulfillment: ${m.fulfillment_status || \"Not fulfilled\"}

Tracking: ${m.trackingUrls || \"N/A\"}

\n \n

Order Status URL: \n View Order\n

\n\n ${m.product_image ? `

` : \"\"}\n

\n `;\n })\n .join(\"\\n\");\n\n// Final HTML\nconst html = `\n\n\n${styles}\n\n

Daily Order Report

\n ${ordersHTML}\n\n\n`;\n\nreturn [\n {\n json: { html }\n }\n];\n" }, "position": [ 1392, 368 ] }, { "id": "1ab38b6f-2392-4143-8906-29455cde1ce3", "name": "send_email", "type": "integration", "params": { "message": "={{ $json.html }}", "options": { "appendAttribution": false }, "service": "gmail", "subject": "Daily Order Report", "operation": "read" }, "position": [ 1600, 368 ] }, { "id": "3d337e0e-120d-484f-89f3-206d53f17d27", "name": "every_24h", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ {} ] } }, "position": [ -80, 320 ] }, { "id": "9b03d732-becc-4506-890a-8d0e6cf5bed1", "name": "daily_order_report", "type": "manualTrigger", "params": {}, "position": [ -80, 464 ] }, { "id": "59f3b9c4-6d16-4b7a-be7b-e0b449965bf6", "name": "Streamline Connector1", "type": "integration", "params": { "service": "streamline", "resource": "orderActions", "operation": "getMany", "__originalType": "n8n-nodes-streamline.streamline", "requestOptions": {} }, "position": [ 528, 368 ] } ] }

Send a daily Shopify order report with Streamline Connector and Gmail