How it works

Follow these 5 simple steps to automatically create Shopify fulfillments from tracking details entered in Google Sheets

google sheets logo icon

Connect your Google Sheets trigger
This monitors your spreadsheet for new shipment rows, allowing your team to manage fulfillments from a familiar interface without accessing Shopify directly.
When someone adds a new row with order and tracking information to your Google Sheet, this trigger captures the data and initiates the fulfillment process. The workflow checks for new rows every hour by default. Required columns in your spreadsheet: • Order Name (Number) - e.g., "#1001" • Tracking Company - e.g., "UPS", "FedEx", "USPS" • Tracking Number
Time to complete: 2 minutes

Match the order in Shopify
This ensures tracking information is added to the right order.
This step searches Shopify for an unfulfilled order matching the "Order Name (Number)" from your Google Sheet row (like "#1001"). It only retrieves orders that haven't been fulfilled yet, preventing duplicate fulfillments.
Time to complete: 1 minute

Verify and retrieve order details
This double-checks that the order exists and hasn't been fulfilled.
The workflow uses a filter to confirm the order name matches exactly and that results were found, then pulls the full order details from Shopify. This ensures you're not attempting to fulfill orders that are already processed or incorrectly referenced.
Time to complete: 1 minute

Set your fulfillment location
Shopify requires a location ID to track which warehouse or store is shipping the order, which affects inventory counts and reporting.
You'll need to specify which Shopify location is handling these fulfillments. This is especially important if you have multiple warehouses, retail stores, or fulfillment centers. To find your location ID: Go to Shopify Admin → Settings → Locations, click on your location, and find the ID in the URL (e.g., .../locations/68288479276)
Time to complete: 2 minutes
Shopify logo icon

Map tracking information in Shopify
With Shopify fulfillment data added, customers can track their shipments.
The workflow automatically reads the "Tracking Company" and "Tracking Number" columns from your Google Sheet row and creates the fulfillment in Shopify with this information.
Time to complete: 1 minute

Make it your own

Customize this workflow even further:

Change the check frequency
Adjust how often MESA scans for new rows—from every 15 minutes for high-volume stores to every 6 hours for slower shipping schedules. Faster polling helps urgent orders get fulfilled sooner.
Send confirmation emails when fulfillments are created
Add an email step after the fulfillment is created to notify your shipping team or operations manager. This creates an audit trail and confirms each fulfillment was processed successfully.
Handle partial fulfillments for multi-item orders
Add logic to check which line items are being fulfilled and only mark specific products as shipped. This is useful when orders contain items from different warehouses or when some products are backordered.
Log fulfillment data to a tracking database
Store each fulfillment event in a MESA Data Table. This creates a searchable fulfillment history for troubleshooting delivery issues or analyzing shipping performance metrics like average time from order to fulfillment.

Frequently asked questions

What is a template?
Templates are pre-made workflows by our team of experts. Instead of building a workflow from scratch, these have all the steps needed to complete the task.
Can I personalize a template?
Yes! Every step can be customized to meet your exact requirements. Additionally, you can even add more steps and make it more sophisticated.
Are templates free?
Yes! Our entire library containing hundreds of templates are free to use and customize to your exact needs.

Related templates you'll love

Recommended workflows that pair well with this template

Ready to automatically create Shopify fulfillments from tracking details entered in Google Sheets?

Join thousands who've automated their work and saved an average of 3.5 hours every week.

Use this template — It's free
7-day free trial • 7 min setup • Cancel anytime