How it works

Follow these 3 simple steps to start receiving fulfillment tracking data in your Google Sheets whenever Shopify creates a fulfillment with tracking information

Shopify logo icon

Fulfillment Created
App connector: Shopify • Time to complete: 0 minutes (Auto-configured)
Why this matters: This trigger monitors your Shopify store for new fulfillments and kicks off the entire workflow whenever tracking information is added to an order.

The trigger automatically detects when Shopify creates a fulfillment record with tracking details for any order.

No configuration is needed - it connects directly to your Shopify store and listens for fulfillment events in real-time. When a fulfillment with tracking information is created, it captures the order ID, tracking number, tracking company, and fulfillment timestamp to pass to the next steps.

Retrieve Order
App connector: Shopify • Time to complete: 0 minutes (Auto-configured)
Why this matters: This step fetches complete order details needed for the spreadsheet since the fulfillment trigger only provides basic information.

The system automatically retrieves the full order record using the order ID from the fulfillment trigger. This pulls comprehensive customer information including name, email, phone number, shipping address, and order total that will populate the Google Sheets columns. The retrieved order data gets combined with the tracking information from the trigger to create a complete fulfillment record.

google sheets logo icon

Add Row
App connector: Google Sheets • Time to complete: 2 minutes
Why this matters: This action creates the actual spreadsheet entry with all the fulfillment and order details in an organized format for easy tracking and analysis.

You'll need to connect your Google account and specify which Google Sheets spreadsheet and worksheet tab to use for the fulfillment data. The workflow will add a new row containing 17 columns of information including Order ID, Customer Name, Email, Phone, Shipping Address, Total Price, Tracking Number, Tracking Company, and Days Since Ordered. Configure the spreadsheet ID and sheet name in the settings - you can find the spreadsheet ID in your Google Sheets URL between "/d/" and "/edit".

Make it your own

Customize this workflow even further:

Add conditional formatting
Set up color coding in Google Sheets to highlight urgent shipments, such as orders over 7 days old or high-value orders that need priority tracking.
Send notification emails
Connect email steps to alert your team when high-priority orders ship, or send automated tracking notifications to VIP customers.
Create fulfillment reports
Add steps to calculate shipping metrics, average fulfillment times, and carrier performance data that gets saved to summary sheets or sent to your team weekly.
Filter by product types
Use conditional logic to route different product categories to separate spreadsheets, like sending fragile items to a special handling tracker.

Frequently asked questions

Will this capture fulfillments that don't have tracking numbers?
No, this workflow specifically triggers on fulfillments with tracking information. Orders fulfilled without tracking details won't create spreadsheet rows, keeping your data focused on trackable shipments only.
Can I modify which order details get added to the spreadsheet?
Yes, you can customize the columns in the Add Row step to include additional order fields like product names, SKUs, or custom order tags, or remove fields you don't need for your tracking purposes.
What happens if the same order gets fulfilled multiple times?
Each fulfillment will create its own row in the spreadsheet, which is helpful for orders that ship in multiple packages. The Order ID will be the same, but each row will have different tracking numbers and fulfillment timestamps.
What is a template?
MESA templates are fully pre-configured workflows built and vetted by Shopify Experts. Unlike competitor templates that provide basic scaffolds requiring extensive setup, MESA templates come with all data variables properly mapped, required fields configured, and steps ready to activate. You can turn them on immediately and start automating.
Can I customize a template?
Absolutely! While our templates work out-of-the-box, every step can be personalized to match your exact business requirements. Add conditional logic, integrate additional apps, or build more sophisticated workflows. MESA's templates provide a solid foundation that you can expand as needed.
Are templates free?
Yes! Our entire library of expert-built, production-ready templates is free to use. Unlike platforms that charge for premium templates or provide only basic scaffolds, MESA gives you access to hundreds of fully-configured, vetted workflows at no additional cost.

Related templates you'll love

Recommended workflows that pair well with this template

Ready to start receiving fulfillment tracking data in your Google Sheets whenever Shopify creates a fulfillment with tracking information?

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

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