{"product_id":"n8n-workflow-parcel-returns-refunds-tracker-google-drive-gmail-kontoflux","title":"n8n Workflow: Parcel Returns \u0026 Refunds Tracker (Google Drive, Gmail, Kontoflux)","description":"\u003ch3\u003eParcel Returns \u0026amp; Refunds Tracker for n8n — automate delivery tracking and refund follow-ups\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically turns scanned return receipts in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e into a live return-and-refund status tracker. It enriches data using \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eKontoflux\u003c\/strong\u003e, then monitors \u003cstrong\u003eDHL\/Deutsche Post\u003c\/strong\u003e delivery status daily and manages refund confirmation with approval-based reminder emails.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceipts → structured return records:\u003c\/strong\u003e When a new receipt scan file is created in a specific Google Drive folder, the workflow downloads it and runs \u003cstrong\u003eMistral OCR\u003c\/strong\u003e to extract text. An \u003cstrong\u003eLLM\u003c\/strong\u003e parses the carrier, tracking ID, recipient\/shop name, and drop-off date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOrder matching and refund expectations:\u003c\/strong\u003e It uses \u003cstrong\u003eGmail\u003c\/strong\u003e and the \u003cstrong\u003eKontoflux transactions API\u003c\/strong\u003e (via an LLM agent) to locate the matching order confirmation, determine the expected refund amount, and split payment method (bank vs PayPal balance).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily DHL delivery status updates:\u003c\/strong\u003e Every day at \u003cstrong\u003e08:00\u003c\/strong\u003e, it reads overdue (not yet delivered) shipments from an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e, queries the \u003cstrong\u003eDHL Tracking API\u003c\/strong\u003e for DHL\/Deutsche Post tracking IDs, updates the Data Table, and sends a delivery notification email when delivered.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily refund checking in Kontoflux:\u003c\/strong\u003e Every day at \u003cstrong\u003e08:00\u003c\/strong\u003e, it checks overdue (not yet refunded) returns by searching Kontoflux for matching incoming credits (bank and PayPal) and records received amounts back into the Data Table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApproval-based marking:\u003c\/strong\u003e If the received refund fully matches what was originally paid (by channel), it requests approval by email to mark the return as refunded; otherwise, it continues refund follow-ups.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack return shipments end-to-end after customers drop packages at DHL\/Deutsche Post.\u003c\/li\u003e\n  \u003cli\u003eReduce refund delays by verifying incoming credits in Kontoflux (bank vs PayPal) against expected refunds.\u003c\/li\u003e\n  \u003cli\u003eAutomate operations for SaaS support teams using n8n Data Table as a single source of truth.\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 Google Drive (new file), \u003cstrong\u003eMistral AI\u003c\/strong\u003e (OCR), LLM parsing, \u003cstrong\u003eGmail\u003c\/strong\u003e tools, \u003cstrong\u003eKontoflux\u003c\/strong\u003e transactions API via LLM agent\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e \u003cstrong\u003en8n Data Table\u003c\/strong\u003e to store expected delivery and refund dates, plus received amounts\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled checks:\u003c\/strong\u003e Daily runs at \u003cstrong\u003e08:00\u003c\/strong\u003e for DHL\/Deutsche Post tracking and refund verification\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHelpers:\u003c\/strong\u003e \u003cstrong\u003eif\u003c\/strong\u003e logic and a \u003cstrong\u003eSticky Note\u003c\/strong\u003e for workflow clarity\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132842758323,"sku":"N8N-20167","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/77dF3UI8fBF7g9M3Qf_s1_I9DjDZye.png?v=1790759633","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-parcel-returns-refunds-tracker-google-drive-gmail-kontoflux","provider":"N8N Commerce","version":"1.0","type":"link"}