Log Every Shippo Shipping Label and Its Cost to Google Sheets

3 min setup
No coding required
Runs automatically

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.

shippo logo icon
When a Shippo label is purchased
shippo logo icon
Shippo looks up the rate the label was bought at
google sheets logo icon
Add the label and its cost to your Google Sheet

How it works

3 steps to see what every shipping label costs in one sheet

shippo logo icon

When a Shippo label is purchased

App connector: Shippo • Time to complete: 1 minute

Runs each time a shipping label (a Shippo transaction) is created, whether it was bought in the Shippo dashboard, through the Shopify app or through the API.

shippo logo icon

Shippo looks up the rate the label was bought at

App connector: Shippo • Time to complete: 1 minute

Use the rate ID on the transaction to get the label's amount, currency, carrier and service level.

google sheets logo icon

Add the label and its cost to your Google Sheet

App connector: Google Sheets • Time to complete: 1 minute

Add one row with the purchase date, carrier, service level, amount, currency, tracking number, label URL and status, so the sheet can be filtered and totaled by carrier or month.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to see what every shipping label costs in one sheet

Get setup in 3 minutes.

Use this template →

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:

Skip refunded labels
Add a Filter step so only labels with a successful status are logged, or add a second workflow on Transaction Updated that marks refunded labels in the sheet.
Send a weekly total to Slack
Add a separate Schedule workflow that reads the sheet each Monday and posts last week's label spend by carrier to Slack.

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."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

see what every shipping label costs in one sheet

3 min setup • Fully supported if you need help