Hello, we’re using a 3rd party shipping software (Shippo) to purchase shipping labels from Shopify orders. I have an integration between Shopify and Shippo where when a label is purchased, Shippo adds the tracking number to Shopify and a tracking number is auto emailed to the customer. Great, works perfectly. Where I need to expand on this is for orders where we are shipping more than 1 package for a single order. I’d like to automatically compile those tracking numbers into a row. I have a zap that is triggered each time a label is purchased in Shippo. My idea is that maybe each tracking number is sent to google sheets or airtable as a new cell (column) in a row, with column A in that row being the order number.
Zap 1: When order is created in Shopify, add a new row to google sheets with the order number populating column A.
Zap 2:
- Shipping label is purchased in Shippo
- Lookup row in google sheets by order number
- Update row in next available cell with tracking number from step 1? This is where I get lost. Can I update the next empty cell in the row found in step 2 with a tracking number? There may be 2 or 20 tracking numbers on different orders so I can’t specific which cell or column gets populated next, just needs to be last populated cell +1. I feel like this is simple and I’m just not seeing what I need.
Thanks!
Best answer by Troy Tessalone
View original
