Recipe No. 36 · Customer support
Refund request logging
Log refund requests from email into a sheet with order lookup for faster approval.
- Serves
- E-commerce
- Made with
- Make
- Prep (setup)
- ~45 min est.
- Yield
- 1–2 hrs/week saved, est.
- Level
- Intermediate
- Plan needed
- Make: Core from $12/mo per Axis Consulting; a free tier may cover low volume. Check your plan.
- Est. SMS cost
- Via Twilio: ~$0.0083 per US text segment plus carrier fees, and $1.15/mo per local number (Oct 2026). Other SMS apps price differently, so check your plan.
- TriggerGmail 'Watch Emails' with label Support/Refund
- Step 2Text Parser 'Match Pattern' to extract an…
- Step 3Shopify 'Get an Order' by name
- Step 4Google Sheets 'Add a Row'
- Step 5Approve refunds manually in Shopify
- Step 6Test with dummy data, then turn it on and…
Ingredients
- Gmail
- Make.com
- Shopify
- Google Sheets
Editor-reviewedLast checked 2026-10-16v1.0.0 · Free
Steps reviewed against current tool UIs by the editor; not yet run end-to-end in a live account. Time saved is an estimate; results vary. Costs from Axis Consulting and Twilio pricing; check current pricing.
SMS rules: only text people who gave you their number for this purpose, identify your business, and include “Reply STOP to opt out”. US business texting needs A2P 10DLC registration.
Method
- Gmail 'Watch Emails' with label Support/Refund (pairs with the triage recipe).
- Text Parser 'Match Pattern' to extract an order number like #1234.
- Shopify 'Get an Order' by name.
- Google Sheets 'Add a Row': customer, order total, date, email link.
- Approve refunds manually in Shopify.
- Test with dummy data, then turn it on and review results for the first week.