{"nodes":[{"id":"d0c92688-14fc-4393-a1d6-926eb867b81e","name":"On clicking 'execute'","type":"n8n-nodes-base.manualTrigger","position":[180,240],"parameters":{},"typeVersion":1,"notes":"This manualTrigger node performs automated tasks as part of the workflow."},{"id":"0edbad78-249b-441c-877d-bac57fb44a91","name":"Note","type":"n8n-nodes-base.stickyNote","position":[180,31],"parameters":{"width":436,"height":169,"content":"## n8n version\n\nThis workflow was created using n8n version 0.197.1 and uses a new [expression syntax]({{ $env.WEBHOOK_URL }} as well as a new version of the Merge node. Make sure you're also using n8n version 0.197.1 or newer when running this workflow."},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"251d893c-11cb-4702-a289-44f198581722","name":"Download XML File","type":"n8n-nodes-base.httpRequest","position":[400,240],"parameters":{"url":"{{ $env.WEBHOOK_URL }}","options":{}},"typeVersion":3,"notes":"This httpRequest node performs automated tasks as part of the workflow."},{"id":"0973b302-1ba9-4faf-9d6c-2caca1b301f5","name":"Parse XML content","type":"n8n-nodes-base.xml","position":[620,240],"parameters":{"options":{}},"typeVersion":1,"notes":"This xml node performs automated tasks as part of the workflow."},{"id":"01854111-27cb-40c1-b95e-14f91f89e9f1","name":"Create new spreadsheet file","type":"n8n-nodes-base.googleSheets","position":[1060,140],"parameters":{"title":"My XML Data","options":{},"resource":"spreadsheet"},"credentials":{"googleSheetsOAuth2Api":{"id":"{{ $credentials.googleSheetsOAuth2Api.id }}","name":"Tom's Google Sheets account"}},"executeOnce":true,"typeVersion":2,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"affbcb81-5873-406e-a51d-cd6fee682992","name":"Define header row","type":"n8n-nodes-base.set","position":[1280,140],"parameters":{"values":{"string":[{"name":"columns","value":"={{ [ Object.keys($(\"Split out food items\").first().json) ] }}"}]},"options":{},"keepOnlySet":true},"executeOnce":true,"typeVersion":1,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"537aff03-ae08-4712-bfae-15f0e3a5e69a","name":"Split out food items","type":"n8n-nodes-base.itemLists","position":[840,240],"parameters":{"options":{},"fieldToSplitOut":"breakfast_menu.food"},"typeVersion":1,"notes":"This itemLists node performs automated tasks as part of the workflow."},{"id":"b247f984-6ed2-4de0-8877-a61571863ff8","name":"Write header row","type":"n8n-nodes-base.googleSheets","position":[1500,140],"parameters":{"options":{},"rawData":true,"sheetId":"={{ $(\"Create new spreadsheet file\").first().json[\"spreadsheetId\"] }}","operation":"update","dataProperty":"columns"},"credentials":{"googleSheetsOAuth2Api":{"id":"{{ $credentials.googleSheetsOAuth2Api.id }}","name":"Tom's Google Sheets account"}},"typeVersion":2,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"fc9e2c32-30b1-4162-a686-2d049e52e111","name":"Wait for spreadsheet creation","type":"n8n-nodes-base.merge","position":[1720,240],"parameters":{"mode":"chooseBranch","output":"input2"},"typeVersion":2,"notes":"This merge node performs automated tasks as part of the workflow."},{"id":"fdc6d5d9-e08d-4086-a233-0edb3c11bc86","name":"Write data to sheet","type":"n8n-nodes-base.googleSheets","position":[1940,240],"parameters":{"options":{},"sheetId":"={{ $(\"Create new spreadsheet file\").first().json[\"spreadsheetId\"] }}","operation":"append"},"credentials":{"googleSheetsOAuth2Api":{"id":"{{ $credentials.googleSheetsOAuth2Api.id }}","name":"Tom's Google Sheets account"}},"typeVersion":2,"notes":"This googleSheets node performs automated tasks as part of the workflow."}],"connections":{"Download XML File":{"main":[[],[],[],[],[],[],[],[],[]]},"Create new spreadsheet file":{"main":[[]]},"Write header row":{"main":[[]]},"Write data to sheet":{"main":[[]]}},"name":"Manualtrigger Workflow","settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"description":"Automated workflow: Manualtrigger Workflow. This workflow integrates 9 different services: stickyNote, httpRequest, itemLists, merge, set. It contains 15 nodes and follows best practices for error handling and security.","meta":{"instanceId":"workflow-b531d50d","versionId":"1.0.0","createdAt":"2025-09-29T07:07:48.781293","updatedAt":"2025-09-29T07:07:48.781318","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"notes":"Excellent quality workflow: Manualtrigger Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}