{"product_id":"n8n-shopify-return-refund-workflow-gmail-claude-slack-sheets","title":"n8n Shopify Return Refund Workflow: Gmail, Claude, Slack \u0026 Sheets","description":"\u003ch3\u003eAutomate Shopify return approvals end-to-end with Gmail, Claude, Slack, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Shopify Return Refund Workflow\u003c\/strong\u003e watches your \u003cstrong\u003eGmail\u003c\/strong\u003e for Shopify return requests, uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to extract the details, checks return eligibility with your \u003cstrong\u003eJavaScript return policy\u003c\/strong\u003e, calculates the refund in \u003cstrong\u003eShopify\u003c\/strong\u003e, collects staff approval in \u003cstrong\u003eSlack\u003c\/strong\u003e, replies to the customer via \u003cstrong\u003eGmail\u003c\/strong\u003e, and logs every outcome to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers every minute\u003c\/strong\u003e when a new unread Gmail message arrives with the \u003cstrong\u003ereturns\u003c\/strong\u003e label (or you can run a manual test with a built-in sample request).\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to extract key fields from the email text: \u003cstrong\u003eorder number\u003c\/strong\u003e, \u003cstrong\u003ereturn items\u003c\/strong\u003e, \u003cstrong\u003ereason\u003c\/strong\u003e, and \u003cstrong\u003erequested resolution\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf \u003cstrong\u003eno order number\u003c\/strong\u003e is found: posts a \u003cstrong\u003eSlack\u003c\/strong\u003e note for staff, replies to the customer asking for the order number, and logs the request to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf an \u003cstrong\u003eorder number\u003c\/strong\u003e is provided: verifies \u003cstrong\u003eGmail DMARC pass\u003c\/strong\u003e, fetches the matching order from \u003cstrong\u003eShopify\u003c\/strong\u003e via \u003cstrong\u003eGraphQL\u003c\/strong\u003e, and runs return-policy checks (ownership, status, delivery window, final-sale tags, and item matching).\u003c\/li\u003e\n  \u003cli\u003eFor \u003cstrong\u003eeligible returns\u003c\/strong\u003e, requests Shopify to calculate the \u003cstrong\u003esuggested refund\u003c\/strong\u003e for the selected line items (and optional shipping), then sends a \u003cstrong\u003eSlack approval\u003c\/strong\u003e message that waits up to \u003cstrong\u003e48 hours\u003c\/strong\u003e to approve or decline.\u003c\/li\u003e\n  \u003cli\u003eIf approved: creates the refund in \u003cstrong\u003eShopify\u003c\/strong\u003e (or simulates in dry-run\/test mode), posts the result to \u003cstrong\u003eSlack\u003c\/strong\u003e, optionally replies in \u003cstrong\u003eGmail\u003c\/strong\u003e, and appends a row to the \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e “Returns log”.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReducing manual back-and-forth for missing order numbers in return requests.\u003c\/li\u003e\n  \u003cli\u003eCentralizing return eligibility logic for Shopify staff using Slack approvals.\u003c\/li\u003e\n  \u003cli\u003eMaintaining an auditable returns history in Google Sheets for every Gmail email outcome.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/integrations\u003c\/strong\u003e: if, set, code, Gmail, Slack, and Google Sheets logging (including Slack notes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI extraction\u003c\/strong\u003e: Anthropic Claude for order\/item\/reason\/resolution extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolicy enforcement\u003c\/strong\u003e: JavaScript-based return policy checks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eShopify access\u003c\/strong\u003e: GraphQL to fetch orders and calculate refunds; supports dry-run\/test mode.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup\u003c\/strong\u003e: connect \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e credentials.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46159503360179,"sku":"N8N-20389","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vQ042OMFwOe3WKm_hVNuj_ft4RWXLB.png?v=1791104743","url":"https:\/\/buyflowscripts.com\/products\/n8n-shopify-return-refund-workflow-gmail-claude-slack-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}