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.

Use this template →

Row Created

Get Unfulfilled Order

Loop

Filter

Retrieve Order

Create Order Fulfillment

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

Rothy's

How it works

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

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.

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

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.

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.

The loop iterates through any orders returned from the previous search step, ensuring each potential match gets individually evaluated. Even though the search limits to 1 result, the loop structure provides reliability for edge cases and prepares the data for the filtering step. Each iteration passes order details to subsequent steps for validation.

App connector: Filter • Time to complete: 1 minute

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

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.

This step fetches the full order record from Shopify using the order ID that passed through the filter. It retrieves all necessary order details including line items, shipping information, and fulfillment requirements that will be needed for creating the fulfillment record. The complete order data ensures the fulfillment includes all relevant product and shipping details.

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.

This step creates the fulfillment record using the tracking company and tracking number from your Google Sheets row. You'll need to specify which location the fulfillment should be created from - choose a location where your products are available for shipping. The fulfillment automatically includes all line items from the order and updates the order status to "fulfilled" with the provided tracking information.

Ready to set this up? It only takes 8 minutes.

Our support team will even help you personalize this workflow for free.

Get started →

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.

Common questions

What is a template?

Can I customize a template?

Are templates free?

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

7-day free trial • 8 min setup • Cancel anytime

Start with this template — It's free

Need help? Our automation experts will help you personalize this workflow for free. Contact support