Parse invoice XML files and update sales opportunities in GoHighLevel
Ready for 3.0What this workflow does
This workflow has 7 nodes and runs when an HTTP POST request hits its webhook URL. It uses only n8n's built-in nodes. It also calls services.leadconnectorhq.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Extract XML from Binary (Extract from File): extracts data from a file (xml)
- Set Raw XML Field (Edit Fields (Set)): sets 1 field: xmlData
- Convert XML Binary to JSON (XML): converts between XML and JSON
- Loop Over Invoices (Loop Over Items (Split in Batches)): loops over the items in batches
- Search GHL Opportunity by Order Ref (Test) (HTTP Request): calls services.leadconnectorhq.com (POST)
- Update GHL Opportunity with Invoice Data (Test) (HTTP Request): calls an HTTP API (PUT)
HTTP calls to: services.leadconnectorhq.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Webhook
n8n-nodes-base.webhook - Extract from File
n8n-nodes-base.extractFromFile - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - XML
n8n-nodes-base.xml
From the author
Quick overview This workflow receives a posted invoice XML file via webhook, parses it into JSON, and for each invoice searches and updates a matching GoHighLevel (LeadConnector) opportunity with invoiced amount, pipeline stage, and custom field values. How…