Log Every Shippo Shipping Label and Its Cost to Google Sheets
Shippo shows label spend inside its own dashboard, but finance and ops usually want it next to everything else in a spreadsheet. This workflow runs each time a Shippo label is purchased, looks up the rate it was bought at, and adds a row to Google Sheets with the date, carrier, service, cost, tracking number and label link, so you can total shipping spend by carrier or month without exporting anything.
How it works
3 steps to see what every shipping label costs in one sheet
When a Shippo label is purchased
When a Shippo label is purchased
Shippo looks up the rate the label was bought at
Shippo looks up the rate the label was bought at
Add the label and its cost to your Google Sheet
Add the label and its cost to your Google Sheet
Ready to see what every shipping label costs in one sheet
Get setup in 3 minutes.
FAQs
Why look up the rate separately?
A Shippo transaction carries the tracking number and label link, and points to the rate it was bought at. The rate holds the amount, carrier and service level, so the workflow retrieves it before writing the row.
Does it log labels bought through the Shippo Shopify app?
Yes. Labels bought for Shopify orders inside Shippo are Shippo transactions like any other, so each one adds a row.
Can I compare label cost with what the customer paid for shipping?
Yes. Add a Shopify step that looks up the order by its order number and writes the order's shipping charge to another column, then subtract one from the other in the sheet.
Personalize this template
Customize this workflow even further:
You're in good company
"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."
"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."
"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"
see what every shipping label costs in one sheet
3 min setup • Fully supported if you need help
