{ "id": "DswhuYzoemjA6iNN", "meta": { "instanceId": "workflow-12a48778", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:54.269052", "updatedAt": "2025-09-29T07:07:54.269080", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production" }, "name": "Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV", "tags": [ "automation", "n8n", "production-ready", "excellent", "optimized" ], "nodes": [ { "id": "2e4f64a5-353c-4dd3-9822-62df795d4940", "name": "Convert to CSV File", "type": "n8n-nodes-base.convertToFile", "position": [ 1640, 340 ], "parameters": { "options": {} }, "typeVersion": 1.1, "notes": "This convertToFile node performs automated tasks as part of the workflow." }, { "id": "472442d3-a691-4310-93f8-019579d0c473", "name": "Extract all books from the page", "type": "n8n-nodes-base.html", "position": [ 760, 340 ], "parameters": { "options": {}, "operation": "extractHtmlContent", "dataPropertyName": "content", "extractionValues": { "values": [ { "key": "YOUR_CREDENTIAL_HERE", "cssSelector": ".row > li", "returnArray": true, "returnValue": "html" } ] } }, "typeVersion": 1.2, "notes": "This html node performs automated tasks as part of the workflow." }, { "id": "92765257-d64d-47c9-bd57-50914342138b", "name": "Sort by price", "type": "n8n-nodes-base.sort", "position": [ 1420, 340 ], "parameters": { "options": {}, "sortFieldsUi": { "sortField": [ { "order": "descending", "fieldName": "price" } ] } }, "typeVersion": 1, "notes": "This sort node performs automated tasks as part of the workflow." }, { "id": "efc2f33f-1bef-4906-b3b7-b02868080a54", "name": "Extract individual book price", "type": "n8n-nodes-base.html", "position": [ 1200, 340 ], "parameters": { "options": {}, "operation": "extractHtmlContent", "dataPropertyName": "books", "extractionValues": { "values": [ { "key": "YOUR_CREDENTIAL_HERE", "attribute": "title", "cssSelector": "h3 > a", "returnValue": "attribute" }, { "key": "YOUR_CREDENTIAL_HERE", "cssSelector": ".price_color" } ] } }, "typeVersion": 1.2, "notes": "This html node performs automated tasks as part of the workflow." }, { "id": "74c7c3af-d63c-4b6c-95a0-15f45b19134b", "name": "Send CSV via e-mail", "type": "n8n-nodes-base.gmail", "position": [ 1860, 340 ], "webhookId": "40f2d609-52ed-40bf-b190-1f1cebbe3fb7", "parameters": { "sendTo": "", "message": "Hey, here's the scraped data from the online bookstore!", "options": { "attachmentsUi": { "attachmentsBinary": [ {} ] } }, "subject": "bookstore csv", "emailType": "text" }, "credentials": { "gmailOAuth2": { "id": "j70r3RTMED1pgN3R", "name": "Gmail account 2" } }, "typeVersion": 2.1, "notes": "This gmail node performs automated tasks as part of the workflow." }, { "id": "95c7998b-ece0-4dea-b99e-97ac22fb8a59", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [ 140, -260 ], "parameters": { "width": 619, "height": 297, "content": "### Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV\n\nšŸ“Œ This workflow scrapes book data from a website, turns it into a CSV, saves it, and sends it by email.\n\nšŸ”§ It starts from a Google Sheets trigger, fetches the page using DumplingAI, extracts books, sorts by price, and emails the CSV.\n\nāœ… Make sure APIs for Gmail, Sheets & Drive are enabled in Google Cloud. Update the URL in the \"Fetch website content\" node.\n" }, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow." }, { "id": "f599028a-49a9-4b85-b484-5abf1229e373", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [ 140, 60 ], "parameters": { "color": 4, "width": 900, "height": 300, "content": "### šŸ” Trigger to Raw Book HTML\n\n1. **Google Sheets Trigger** \n Watches a sheet for new row entries. Once a new URL is added, the workflow starts.\n\n2. **Fetch Website Content (Dumpling AI)** \n Makes an HTTP POST request to Dumpling AI to scrape and return the full HTML of the target URL.\n\n3. **Extract All Books** \n Uses CSS selectors to isolate the list items (`li.row > li`) containing book entries.\n\n4. **Split Out Node** \n Breaks the array of book HTML blocks into individual items, so each book can be processed separately in the next steps.\n" }, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow." }, { "id": "bc6ab72c-de03-4e79-9da0-ca12ddf31811", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [ 1140, 60 ], "parameters": { "color": 6, "width": 840, "height": 300, "content": "### šŸ“¦ Parse, Sort, Export & Email\n\n5. **Extract Individual Book Data** \n From each book, extract the title (`

a` title attribute) and price (`.price_color` content).\n\n6. **Sort by Price** \n Organizes the extracted data in descending order using the price field.\n\n7. **Convert to CSV File** \n Transforms the sorted JSON data into a downloadable CSV file format.\n\n8. **Send CSV via Gmail** \n Automatically sends an email with the CSV file attached to the predefined address.\n" }, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow." }, { "id": "a1246b4e-212f-4bd3-970b-b0ff8db2f834", "name": "Trigger- Watches For new URL in Spreadsheet", "type": "n8n-nodes-base.googleSheetsTrigger", "position": [ 320, 340 ], "parameters": { "event": "rowAdded", "options": {}, "pollTimes": { "item": [ { "mode": "everyMinute" } ] }, "sheetName": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "URLs" } }, "credentials": { "googleSheetsTriggerOAuth2Api": { "id": "qDzHSzTkclwDHpSR", "name": "Google Sheets Trigger account" } }, "typeVersion": 1, "notes": "This googleSheetsTrigger node performs automated tasks as part of the workflow." }, { "id": "b19aa287-3be4-4e16-908d-b0cb484519e3", "name": "Scrape Website Content with Dumpling AI", "type": "n8n-nodes-base.httpRequest", "position": [ 540, 340 ], "parameters": { "url": "{{ $env.API_BASE_URL }}", "method": "POST", "options": { "allowUnauthorizedCerts": true }, "jsonBody": "={\n \"url\": \"{{ $('Trigger- Watches For new URL in Spreadsheet')}}\", \n \"format\": \"html\",\n \"cleaned\": \"True\"\n }", "sendBody": true, "sendHeaders": true, "specifyBody": "json", "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth", "headerParameters": { "parameters": [ { "name": "Content-Type", "value": "application/json" } ] } }, "credentials": { "httpBasicAuth": { "id": "mznexGH3YDtrUTAk", "name": "Unnamed credential" }, "httpHeaderAuth": { "id": "xamyMqCpAech5BeT", "name": "Header Auth account" } }, "typeVersion": 4.1, "notes": "This httpRequest node performs automated tasks as part of the workflow." }, { "id": "02cbc6f9-bdcb-45fc-9973-ded42346ffbc", "name": "Split HTML Array into Individual Books", "type": "n8n-nodes-base.splitOut", "position": [ 980, 340 ], "parameters": { "options": {}, "fieldToSplitOut": "books" }, "typeVersion": 1, "notes": "This splitOut node performs automated tasks as part of the workflow." } ], "active": false, "pinData": {}, "settings": { "executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000 }, "versionId": "264412ff-9d74-443c-a2ff-69be1e042a82", "connections": { "b19aa287-3be4-4e16-908d-b0cb484519e3": { "main": [ [ { "node": "error-handler-b19aa287-3be4-4e16-908d-b0cb484519e3", "type": "main", "index": 0 } ], [ { "node": "error-handler-b19aa287-3be4-4e16-908d-b0cb484519e3-75a02fe3", "type": "main", "index": 0 } ], [ { "node": "error-handler-b19aa287-3be4-4e16-908d-b0cb484519e3-ecfc256d", "type": "main", "index": 0 } ], [ { "node": "error-handler-b19aa287-3be4-4e16-908d-b0cb484519e3-64627b92", "type": "main", "index": 0 } ], [ { "node": "error-handler-b19aa287-3be4-4e16-908d-b0cb484519e3-afc2ce2f", "type": "main", "index": 0 } ], [ { "node": "error-handler-b19aa287-3be4-4e16-908d-b0cb484519e3-383e16c9", "type": "main", "index": 0 } ], [ { "node": "error-handler-b19aa287-3be4-4e16-908d-b0cb484519e3-b227a0ee", "type": "main", "index": 0 } ], [ { "node": "error-handler-b19aa287-3be4-4e16-908d-b0cb484519e3-5178dc80", "type": "main", "index": 0 } ], [ { "node": "error-handler-b19aa287-3be4-4e16-908d-b0cb484519e3-d576d587", "type": "main", "index": 0 } ] ] }, "2e4f64a5-353c-4dd3-9822-62df795d4940": { "main": [ [ { "node": "error-handler-2e4f64a5-353c-4dd3-9822-62df795d4940-b29bead0", "type": "main", "index": 0 } ] ] }, "a1246b4e-212f-4bd3-970b-b0ff8db2f834": { "main": [ [ { "node": "error-handler-a1246b4e-212f-4bd3-970b-b0ff8db2f834-93a6d7bd", "type": "main", "index": 0 } ] ] } }, "description": "Automated workflow: Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV. This workflow integrates 9 different services: convertToFile, stickyNote, httpRequest, googleSheetsTrigger, splitOut. It contains 15 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV. This workflow has been optimized for production use with comprehensive error handling, security, and documentation." }