New Product Arrival

{ "edges": [ { "to": "a4203358-3d38-4f86-b4d7-851310d74d73", "from": "67cb14fa-7f77-40d8-9c77-a9e0eae1a6ef", "toPort": "0", "fromPort": "0" }, { "to": "67cb14fa-7f77-40d8-9c77-a9e0eae1a6ef", "from": "7f515193-cbd0-4a76-8a04-7f32f73610da", "toPort": "0", "fromPort": "0" }, { "to": "b10d432d-b850-4540-a00f-878cfe102a3f", "from": "a4203358-3d38-4f86-b4d7-851310d74d73", "toPort": "0", "fromPort": "0" }, { "to": "7f515193-cbd0-4a76-8a04-7f32f73610da", "from": "fd3f411c-f5b9-42ea-809b-9824ab16a07c", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "fd3f411c-f5b9-42ea-809b-9824ab16a07c", "name": "WooCommerce – New Product Created", "type": "integration", "params": { "event": "product.created", "service": "woocommercetrigger", "operation": "run", "__originalType": "n8n-nodes-base.wooCommerceTrigger" }, "position": [ 384, 352 ] }, { "id": "7f515193-cbd0-4a76-8a04-7f32f73610da", "name": "Format Product Details", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "499d039d-9fad-4f59-8eb3-a0b3010f234d", "name": "body.name", "type": "string", "value": "={{ $json.body.name }}" }, { "id": "1cca1c31-a42e-4e71-b9ef-a8e18d0ca763", "name": "body.status", "type": "string", "value": "={{ $json.body.status }}" }, { "id": "f0b852e3-82cd-4495-9cb3-5884148c766e", "name": "body.price", "type": "string", "value": "={{ $json.body.price }}" }, { "id": "e7b9c164-c89f-4e6e-bc6a-214d50ecf5d3", "name": "body.permalink", "type": "string", "value": "={{ $json.body.permalink }}" }, { "id": "8f5c70bf-961c-4561-b3cd-73954a36fa6c", "name": "body.images", "type": "array", "value": "={{ $json.body.images }}" } ] } }, "position": [ 592, 352 ] }, { "id": "67cb14fa-7f77-40d8-9c77-a9e0eae1a6ef", "name": "Notify Team on Slack", "type": "integration", "params": { "text": "=New Product Live!\nName: {{ $json.body.name }}\nPrice: {{ $json.body.price }}\nURL: {{ $json.body.permalink }}\nImages:\n{{ $json.body.images.map(i => i.src).join('\\n') }}", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "id", "value": "" }, "operation": "read", "otherOptions": {} }, "position": [ 832, 352 ] }, { "id": "a4203358-3d38-4f86-b4d7-851310d74d73", "name": "Send Product Launch Email", "type": "integration", "params": { "message": "=\n\n\n \n New Product Arrival\n\n\n\n\n \n \n \n \n

\n\n

\n New Product Live!\n

\n\n

\n A new product has just been published and is now available.\n

\n\n \n \n \n \n \n\n \n \n \n \n\n \n \n \n\n \n \n \n \n

Product Name:	{{ $('Format Product Details').item.json.body.name }}
Price:	{{ $('Format Product Details').item.json.body.price }}
Status:	<{{ $('Format Product Details').item.json.body.status }}/td>\n
Product URL:	\n \n View Product\n \n

\n\n

Product Images

\n\n \n {{ $('Format Product Details').item.json.body.images.map(img => `\n

\n $\"Product$ \n

\n `).join('') }}\n\n

\n\n

\n This is an automated notification from your product system.\n

\n\n

\n\n\n", "options": {}, "service": "gmail", "subject": "=New Arrival: {{ $('Format Product Details').item.json.body.name }}", "operation": "read" }, "position": [ 1056, 352 ] }, { "id": "b10d432d-b850-4540-a00f-878cfe102a3f", "name": "Log Product in Google Sheets", "type": "integration", "params": { "columns": { "value": { "Price": "={{ $('Format Product Details').item.json.body.price }}", "Status": "={{ $('Format Product Details').item.json.body.status }}", "Image URL": "={{ $('Format Product Details').item.json.body.images?.map(i => i.src).join('\\n') }}", "Created At": "= {{ $now }}", "Product URL": "={{ $('Format Product Details').item.json.body.permalink }}", "Product Name": "={{ $('Format Product Details').item.json.body.name }}" }, "schema": [ { "id": "Product Name", "type": "string", "display": true, "required": false, "displayName": "Product Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Price", "type": "string", "display": true, "required": false, "displayName": "Price", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "required": false, "displayName": "Status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Product URL", "type": "string", "display": true, "required": false, "displayName": "Product URL", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Image URL", "type": "string", "display": true, "required": false, "displayName": "Image URL", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Created At", "type": "string", "display": true, "required": false, "displayName": "Created At", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/16f1RrNM-e_AEUGHApNXnUDxGb_xPSxxZlvtcLowbeg0/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "16f1RrNM-e_AEUGHApNXnUDxGb_xPSxxZlvtcLowbeg0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/16f1RrNM-e_AEUGHApNXnUDxGb_xPSxxZlvtcLowbeg0/edit?usp=drivesdk", "cachedResultName": "(Retail) New Product Drop Notifications" } }, "position": [ 1312, 352 ] } ] }

Send new WooCommerce product notifications to Slack, Gmail and Google Sheets