Generate Shopify Order Fulfillments from New Google Sheets Rows

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

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.

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.

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.

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.

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.