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:

1. Shipping label is purchased in Shippo

2. Lookup row in google sheets by order number 

3. 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!