Shopify Order Tracking to Google Sheets with Telegram Alerts - n8n Workflow

E-commerce business owners needing real-time visibility into sales.
Data analysts looking to centralize Shopify order data for reporting.
Developers seeking robust, low-code n8n templates for integration projects.
Operations teams that require instant alerts for every new transaction.

Managing high volumes of e-commerce orders requires immediate data centralization and communication. This specific n8n workflow solves the problem of delayed data entry by instantly processing incoming Shopify webhooks. When a new order is placed, this n8n automation pipeline transforms complex JSON data into a clean, standardized format suitable for Google Sheets. This ensures your sales tracking spreadsheet is always up-to-date without manual intervention. Furthermore, the n8n workflow provides instant, reliable notification via Telegram, ensuring you or your team never miss a sale. This automation is a foundational example of how versatile n8n templates can enhance business efficiency.

This highly efficient n8n workflow begins immediately upon receiving external input.

1. Incoming Data (n8n trigger): The process starts with the Receive New Shopify Order n8n node, which acts as a webhook. It listens for a POST request from your configured Shopify store whenever a new order is created.


2. Data Processing: The data is routed to the Transform Order Data to Standard Format n8n node (a Function node). This custom code meticulously parses the incoming Shopify JSON payload, extracts key details (customer name, items, totals), standardizes the format, and prepares complex fields (like customer and line items) as JSON strings for clean storage.


3. Data Storage: The standardized data is passed to the Save Order to Google Sheets n8n node. This node automatically appends a new row containing the full order details to your designated Google Sheet document.


4. Flow Control: The Success? n8n node acts as a check point. Although configured simply in this template, its purpose is to route the n8n workflow based on whether the previous storage action succeeded.


5. Success Notification: If the data was successfully recorded, the Send Success Notification1 n8n node sends a formatted message to a Telegram chat, confirming the order number, customer, and total price. This provides real-time confirmation for the successful execution of the n8n workflow.


6. Error Notification: If the Google Sheets operation fails, the failure path leads to the Send Error Notification n8n node, alerting the user via Telegram that the synchronization failed.

To deploy and utilize this powerful n8n workflow template, follow these steps:

1. Import: Copy the provided JSON code and paste it into your n8n instance using the 'Import Workflow' function.


2. Shopify Webhook (n8n trigger):

1. Telegram Credentials:

1. Activate: Save and activate the n8n workflow.

This n8n workflow relies on several key n8n node types to achieve seamless integration and data handling:

Receive New Shopify Order (Webhook n8n node):
Function: Acts as the primary n8n trigger, listening for incoming order events from Shopify.
Key Configuration: Configured to accept POST requests at the path /shopify-webhook.

Transform Order Data to Standard Format (Function n8n node):
Function: Executes custom JavaScript to parse the complex Shopify JSON, standardize fields, and prepare the structure for the Google Sheet, ensuring data integrity across this n8n automation.
Key Configuration: Custom code extracts order ID, customer details (handling missing fields), line items, and converts nested objects into stringified JSON.

Save Order to Google Sheets (Google Sheets n8n node):
Function: Performs the data storage action, appending the standardized order record as a new row in the designated tracking sheet.
Key Configuration: Operation set to Append. Requires configuration of Document ID and Sheet Name (e.g., 'Daily Orders Sheet' and 'Order').

Success? (If n8n node):
Function: Provides flow control based on the success of the Google Sheets operation. If successful, the n8n workflow proceeds to send the notification.
Key Configuration: Routes the flow to the success or failure Telegram n8n node.

Send Success Notification1 (Telegram n8n node):
Function: Sends a real-time, customized summary notification to Telegram using data derived earlier in the n8n workflow.
* Key Configuration: Uses expressions to inject dynamic data like orderNumber, customer name, and totalPrice into the message text.