Turn Squarespace order emails into a spreadsheet
Squarespace Commerce sends "A New Order has Arrived" for each sale. MailQL collects them as rows you can total by month or download for your bookkeeping.
Free for 25 emails a month.
What each email becomes
| Channel | Order # | Customer | Items | Total | Ship to |
|---|---|---|---|---|---|
| Squarespace | 00231 | Grace Lee | 1 × Print, 11x14; 1 × Black frame | $95.00 | Savannah, GA |
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:(squarespace.info) subject:("new order"), choose Create filter, and tick Forward it to your MailQL address. - New Squarespace order emails turn into rows as they arrive. Forward a few old ones by hand to fill the table now.
Good to know
- Order numbers keep their leading zeros, like 00231.
- 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
Shopify order emailsEtsy sale emailsSquare online order emailsThumbtack lead emailsAngi lead emailsYelp quote requests
MailQL isn't affiliated with or endorsed by Squarespace. Names are trademarks of their owners, used here only to say which emails MailQL can read.