Generate Shopify Order Fulfillments from New Google Sheets Rows

8 min setup

No coding required

Runs automatically

Streamline your order fulfillment process by using Google Sheets to trigger fulfillments in Shopify. When a team member adds tracking information to a new row in Google Sheets, this MESA workflow template automatically creates the order fulfillment in Shopify. Save time on manual updates and let your team manage shipments effortlessly, allowing you to focus on other essential business tasks.

How it works

6 steps to create fulfillments from tracking details entered in Google Sheets

Row Created

App connector: Google Sheets• Time to complete: 2 minutes

Why this matters: This monitors your spreadsheet for new shipment rows, allowing your team to manage fulfillments from a familiar interface without accessing Shopify directly.

Required columns in your spreadsheet:

• Order Name (Number) - e.g., "#1001"

• Tracking Company - e.g., "UPS", "FedEx", "USPS"

• Tracking Number

Get Unfulfilled Order

App connector: Shopify• Time to complete: 1 minute

Why this matters: 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.

Loop Through Orders

App connector: Loop• Time to complete: 0 minutes (Auto-configured)

Why this matters: This processes each matching order individually, handling cases where multiple orders might share similar names or numbers.

Filter: Confirm Order Match

App connector: Filter• Time to complete: 1 minute

Why this matters: This double-checks that the order exists and hasn't been fulfilled.

Retrieve Order

App connector: Shopify• Time to complete: 2 minutes

Why this matters: This gets the complete order details needed to create the fulfillment, including line items and location information.

Create Order Fulfillment

App connector: Shopify• Time to complete: 1 minute

Why this matters: This actually creates the fulfillment record in Shopify with your tracking information, completing the shipping notification process.

Frequently asked questions

What is a template?

MESA templates are fully pre-configured workflows built and vetted by Shopify Experts.

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.

Are templates free?

Yes! Our entire library of expert-built, production-ready templates is free to use.

Make this template your own!

Customize this workflow even further:

• Change the check frequency
• Send confirmation emails when fulfillments are created
• Handle partial fulfillments for multi-item orders
• Log fulfillment data to a tracking database

You're in good company

Avg. App Store rating 4.9/5

Merchant reviews 157

Avg. time saved per week 3.5 hrs

PetFriendly "It's like Zapier but exactly designed for Shopify."

Zailys "The MESA team has been amazing at helping us set up our automations."

Rothy's "We would highly recommend this app!"