Step 2: Connect Google Sheets

Configure the destination where normalized orders will be logged.

1. Add the Append Order to Sheets node.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials.
3. Set Operation to append.
4. Set Document to [YOUR_ID] (replace with your Google Sheet ID).
5. Set Sheet to Order (or your target tab name).
6. Leave Mapping Mode as autoMapInputData to map fields from the normalized payload automatically.

Step 3: Set Up the Processing Node

Normalize the incoming Shopify payload so it is consistent and ready for logging.

1. Add the Normalize Order Payload node between Incoming Shopify Order Hook and Append Order to Sheets.
2. Paste the provided JavaScript into Function Code exactly as in the workflow to standardize fields and stringify nested objects.
3. Verify the output includes fields like orderId, orderNumber, customer, shippingAddress, and lineItems.

Step 4: Configure Output and Alerts

Send alerts depending on whether the sheet append succeeds or fails.

1. Add the Outcome Check node after Append Order to Sheets to route success and failure paths.
2. Connect the true output of Outcome Check to Send Success Alert and the false output to Dispatch Failure Alert.
3. In Send Success Alert, set Text to =🛍️ New Order Successfully Recorded Order #: {{ $node["Normalize Order Payload"].json.orderNumber }} Customer: {{ JSON.parse($node["Normalize Order Payload"].json.customer).name }} Total: {{ $node["Normalize Order Payload"].json.currency }} {{ $node["Normalize Order Payload"].json.totalPrice }} Date: {{ $node["Normalize Order Payload"].json.created_at }} Order has been added to your Order Tracking Sheet..
4. In Send Success Alert, set Chat ID to =[YOUR_ID].
5. Credential Required: Connect your telegramApi credentials in Send Success Alert.
6. In Dispatch Failure Alert, set Text to ❌ *ERROR: Shopify Order Processing Failed* ``` {{ $json.error }} ``` *Error occurred at:* {{ $now }}.
7. In Dispatch Failure Alert, set Chat ID to ={{$node["Utility: Assign Config Values"].json.telegramChatId}}.
8. Credential Required: Connect your telegramApi credentials in Dispatch Failure Alert.

Step 5: Add Error Handling

Use a configuration helper to centralize IDs used in error alerts.

1. Open Utility: Assign Config Values and set spreadsheetId to [YOUR_ID].
2. Set sheetName to orders.
3. Set telegramChatId to [YOUR_ID] for your failure alert destination.

Step 6: Test and Activate Your Workflow

Validate that Shopify orders are logged and alerts are delivered before enabling the automation.

1. Click Execute Workflow and send a test order payload to the Incoming Shopify Order Hook URL.
2. Confirm the Normalize Order Payload output shows standardized fields and stringified JSON sections.
3. Verify that Append Order to Sheets adds a new row in your target sheet.
4. Ensure Send Success Alert posts to Telegram with order details, or Dispatch Failure Alert posts error text when you simulate a failure.
5. Toggle the workflow to Active to start processing live Shopify orders.