Turn Shopify order emails into a spreadsheet
Shopify emails you each new order. MailQL turns them into rows with the order number, customer, items, total and ship-to, so you can see orders from Shopify next to orders from anywhere else you sell.
Free for 25 emails a month.
What each email becomes
| Channel | Order # | Customer | Items | Total | Ship to |
|---|---|---|---|---|---|
| Shopify | 1042 | Emily Ross | 2 × Sea Salt Candle 8oz; 1 × Driftwood Candle 12oz | $68.85 | Austin, TX |
All the columns: Channel, Order #, Customer, Items, Total, Ship to. You can rename, add or remove any of them.
Set it up in two minutes
- Make a mailbox in MailQL and pick Web orders. You get an address like
orders-k7f3qd@in.mailql.com. - In Gmail, open Settings → See all settings → Forwarding and POP/IMAP and add that address. Confirm it with the code MailQL shows you.
- Search Gmail for
from:(shopify.com) subject:(order), choose Create filter, and tick Forward it to your MailQL address. - New Shopify order emails turn into rows as they arrive. Forward a few old ones by hand to fill the table now.
Good to know
- Each item is listed with its quantity in the Items column.
- Digital orders and gift cards leave Ship to empty.
- Anything MailQL isn't sure of is highlighted for you to check, with the words from the email it came from.
- Download the table as CSV whenever you like, send each new row to a webhook (Zapier and Make included), or ask questions like "how many this month?".
Other emails it reads
Etsy sale emailsSquare online order emailsSquarespace order emailsThumbtack lead emailsAngi lead emailsYelp quote requests
MailQL isn't affiliated with or endorsed by Shopify. Names are trademarks of their owners, used here only to say which emails MailQL can read.