n8n Shopify Automation: Smarter Order Processing & Customer Updates

When a customer places an order on Shopify, n8n triggers a workflow to send a confirmation SMS, update stock levels in Google Sheets and notify the fulfillment team on Slack.

• n8n installed (local or cloud, see Installation Guide).
• Shopify store with webhook access.
• Accounts: Twilio (SMS), Google Sheets (API enabled), Slack (bot token).

1. Prepare n8n Environment

• Navigate to http://localhost:5678 (or your n8n hosted URL) and log in with your credentials. 

• In the sidebar, click “Workflows,” then select “+ New” and name it (e.g., “Campaign Tracker”). Click “+” on the canvas to open the node selector.

2. Trigger Node: Shopify Webhook

• Node: Webhook

• Settings:

• Method: POST

• Path: shopify-order

• Authentication: None

• Shopify Setup: In Shopify Admin > Settings > Notifications > Webhooks, add https://<n8n-host>/webhook/shopify-order for “Order Creation.”

• Output: Order data (e.g., {{ $json.body.customer.email }}).

3. Send SMS Node: Twilio

• Node: Twilio

• Settings:

• Credentials: Twilio Account SID, Auth Token

• From: Your Twilio number

• To: {{ $node["Webhook"].json.body.customer.phone }}

• Message: Thanks for your order #{{ $node["Webhook"].json.body.order_number }}! We’re processing it now.

• Output: SMS confirmation sent.

4. Update Inventory Node: Google Sheets

• Node: Google Sheets

• Settings:

• Credentials: Google API key with Sheets scope

• Operation: Update

• Spreadsheet ID: Your inventory sheet

• Range: A:B (e.g., SKU, Quantity)

• Key: {{ $node["Webhook"].json.body.line_items[0].sku }}

• Value: {{ $node["Webhook"].json.body.line_items[0].quantity - 1 }}

• Output: Updated stock level.

5. Notify Team Node: Slack

• Node: Slack

• Settings:

• Credentials: Slack Bot Token

• Channel: #fulfillment

• Text: New order #{{ $node["Webhook"].json.body.order_number }} - {{ $node["Webhook"].json.body.line_items[0].name }}

• Output: Team alert posted.

• Flow: Webhook (Shopify order) → Twilio (SMS) → Google Sheets (inventory) → Slack (alert).
• Execution: Real-time, ~10 seconds total.

 

• Eliminates manual order updates, saving ~5 minutes per order.
• Enhances customer trust with instant confirmations.
• Ensures team coordination without email delays.

 

• Webhook Fails: Verify Shopify webhook URL and n8n host accessibility.
• Sheets Error: Check API key permissions and column alignment

Ready to transform your business with our technology solutions? Contact Us today to Leverage Our AI/ML Expertise.