{"product_id":"gmail-to-gohighlevel-missed-edi-sales-csv-slack-alerts","title":"Gmail to GoHighLevel Missed EDI Sales (CSV) + Slack Alerts","description":"\u003ch3\u003eAutomatically capture Gmail EDI missed sales into GoHighLevel + get Slack alerts on errors\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Gmail for EDI sales report emails with CSV attachments, extracts the “missed sales” line items, and logs new records into \u003cstrong\u003eGoHighLevel (LeadConnector) custom objects\u003c\/strong\u003e—automatically linking them to matching opportunities by PO number. If anything goes wrong, you’ll receive an immediate \u003cstrong\u003eSlack\u003c\/strong\u003e alert.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Gmail\u003c\/strong\u003e for new messages that match your configured filters and downloads the CSV attachment(s).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts and processes CSV rows\u003c\/strong\u003e in batches from the attached EDI sales report file.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes key fields\u003c\/strong\u003e (including PO number and SAP material code) and generates a \u003cstrong\u003eunique key\u003c\/strong\u003e to prevent duplicates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates against GoHighLevel\u003c\/strong\u003e by searching the \u003cstrong\u003eLeadConnector\u003c\/strong\u003e missed sales custom object for an existing record with the same unique key, skipping already-logged rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates new missed sales records\u003c\/strong\u003e in GoHighLevel with quantity, pricing, value, and rejection reason details taken from each CSV row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLinks missed sales to opportunities\u003c\/strong\u003e by searching GoHighLevel opportunities using \u003cstrong\u003ePO number\u003c\/strong\u003e, and associating the new missed sales record when a match is found.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Slack alerts on workflow errors\u003c\/strong\u003e so issues don’t go unnoticed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCentralize EDI “missed sales” reporting into GoHighLevel for faster sales follow-up and reporting.\u003c\/li\u003e\n  \u003cli\u003eReduce manual data entry by automatically importing CSV line items from Gmail into a custom CRM object.\u003c\/li\u003e\n  \u003cli\u003eEnsure deduplication when EDI reports resend overlapping rows.\u003c\/li\u003e\n  \u003cli\u003eGet real-time operational visibility via Slack if the workflow fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers\/Nodes:\u003c\/strong\u003e \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003ehttp request\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifications:\u003c\/strong\u003e \u003cem\u003eslack\u003c\/em\u003e (posts to a specified Slack channel on any workflow error)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCRM integration:\u003c\/strong\u003e GoHighLevel via \u003cstrong\u003eLeadConnector\u003c\/strong\u003e using a \u003cstrong\u003ePrivate Integration Token\u003c\/strong\u003e and a \u003cstrong\u003elocation ID\u003c\/strong\u003e (replacing placeholders in HTTP requests)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow helper:\u003c\/strong\u003e \u003cem\u003esticky note\u003c\/em\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003ePerfect for n8n users, automation engineers, and SaaS operators running CRM workflows that depend on Gmail-delivered EDI CSV data.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938240454835,"sku":"N8N-19018","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tvIPLOpi99-i2Ch9q09TC_MqqbBdeU.png?v=1788340630","url":"https:\/\/buyflowscripts.com\/products\/gmail-to-gohighlevel-missed-edi-sales-csv-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}