Shopify Order Fulfillment Tracker

Task

Use @Shopify/Get Customer Orders by EmailName it "Shopify/Get Customer Orders by Email" and call it with @Shopify/Get Customer Orders by Email to pull a customer's order history, then @Shopify/Get Order FulfillmentsName it "Shopify/Get Order Fulfillments" and call it with @Shopify/Get Order Fulfillments to check the fulfillment status of each order. Log results to @Google Sheets/Add RowsName it "Google Sheets/Add Rows" and call it with @Google Sheets/Add Rows and send a @Slack/Send Message alertName it "Slack/Send Message alert" and call it with @Slack/Send Message alert for any orders that are unfulfilled or have shipping issues.

Example: Check all orders for vip-customer@exampleName it "example" and call it with @example.com, flag anything unfulfilled older than 3 days, and alert the ops team in Slack.

Input

The user will provide:

1. A customer email address (or list of emails) to check
2. The Slack channel to send alerts to (e.g., #fulfillment-ops)
3. The Google Sheet ID where fulfillment data should be logged
4. Optional: a threshold in days for flagging delayed orders (default: 3 days)

Example: "Check orders for sarah@bigclientName it "bigclient" and call it with @bigclient.com and log to sheet 1A2B3C. Alert #ops if anything is unfulfilled for more than 2 days."

Context

Fulfillment Statuses to Watch

Requires attention:

• fulfillmentStatus is null (not yet fulfilled)
• shipmentStatus is "label_printed" but no movement in 48+ hours
• shipmentStatus is "failure" or "attempted_delivery"
• Order created more than [threshold] days ago with no fulfillment

Normal — no alert needed:

• shipmentStatus is "in_transit" or "delivered"
• fulfillmentStatus is "fulfilled" with tracking info present

Data to Collect Per Order

For each order, capture:

• Order name/number and creation date
• Financial status (paid, pending, refunded)
• Fulfillment status and tracking number
• Carrier and shipment status
• Line items with quantities
• Days since order was placed

Spreadsheet Structure

Log to Google Sheets with columns: | Order # | Customer Email | Created | Total | Financial Status | Fulfillment Status | Tracking # | Carrier | Shipment Status | Days Open | Flagged |

Alert Logic

Send a Slack message when:

• Any order has been unfulfilled for longer than the threshold
• A shipment shows a failure or attempted_delivery status
• There are more than 3 unfulfilled orders for a single customer

Output

Google Sheet: One row per order with all fulfillment details and a "Flagged" column (YES/NO).

Slack Alert (if issues found):

:warning: Fulfillment Alert — [Customer Name]

[Count] orders need attention:

| Order | Created | Status | Issue | |-------|---------|--------|-------| | #1234 | Jan 15 | Unfulfilled | 5 days without shipment |

Action needed: Review flagged orders in the [spreadsheet link].

If no issues: No Slack message sent. Sheet is updated silently.