Intuz This workflow corresponds to n8n.io template #9448 — we link there as the canonical source.
This workflow follows the Airtable → Gmail recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "JjrhFDyBIgB20pnY",
"name": "Automate Shopify Orders from Airtable with Gmail Confirmations",
"tags": [],
"nodes": [
{
"id": "c07b2f4e-f9c6-40a9-88a3-cd3d905b1ab4",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1632,
-416
],
"parameters": {
"color": 3,
"width": 384,
"height": 560,
"content": "## The Trigger\n\n### This node acts as the workflow's entry point. It waits for a signal from an external service\n\n### It's designed to be triggered by an Airtable Automation whenever you mark an order as ready. The Airtable Automation will send the unique recordId of the order to this webhook.\n\n### Action Required: You must copy the 'Production URL' from this node and use it in your Airtable Automation script. This is how Airtable tells n8n to start."
},
"typeVersion": 1
},
{
"id": "aa293e3f-80ae-4d7d-822d-99060117f9d8",
"name": "Trigger from Airtable",
"type": "n8n-nodes-base.webhook",
"position": [
-1520,
-16
],
"parameters": {
"path": "f4e69e57-40f0-4af9-b44d-17eb9389b427",
"options": {}
},
"typeVersion": 2.1
},
{
"id": "5446b168-c78c-438f-9670-1a5e050a978f",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
-416
],
"parameters": {
"color": 3,
"width": 368,
"height": 560,
"content": "## Fetch Order & Customer Details\n\n### This node receives the recordId from the Webhook and uses it to look up the complete order record in your Airtable Orders table.\n\n### It gathers all the essential customer information needed for the Shopify order, such as the customer's name, email, and shipping address.\n\n### This step turns a simple ID into a full customer and order profile."
},
"typeVersion": 1
},
{
"id": "2f2c60e4-ffab-475a-9b09-5cd5bfa5e723",
"name": "Fetch Order & Customer Details",
"type": "n8n-nodes-base.airtable",
"position": [
-1056,
-16
],
"parameters": {
"id": "={{ $json.query.recordId }}",
"base": {
"__rl": true,
"mode": "list",
"value": "appQTd8PXDgHdjOpr",
"cachedResultUrl": "https://airtable.com/appQTd8PXDgHdjOpr",
"cachedResultName": "Dynamic Video Content"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblEXxxmfYYsMDLC9",
"cachedResultUrl": "https://airtable.com/appQTd8PXDgHdjOpr/tblEXxxmfYYsMDLC9",
"cachedResultName": "Orders"
},
"options": {}
},
"typeVersion": 2.1
},
{
"id": "d2faa646-73ed-4945-973c-9519a5ef172b",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-416
],
"parameters": {
"color": 3,
"width": 368,
"height": 560,
"content": "## Fetch Product Line Items \n\n### After getting the main order details, this node looks up the associated Order Line Items record.\n\n### It retrieves the specific products for the order, including the Product Name, Quantity, and Price. Without this step, Shopify wouldn't know what items to add to the cart.\n\n### This step builds the contents of the customer's order."
},
"typeVersion": 1
},
{
"id": "f95ca4c0-d248-45d7-b6f1-e232b625dc09",
"name": "Fetch Product Line Items",
"type": "n8n-nodes-base.airtable",
"position": [
-640,
-16
],
"parameters": {
"id": "={{ $json['Order Line Items'][0] }}",
"base": {
"__rl": true,
"mode": "list",
"value": "appQTd8PXDgHdjOpr",
"cachedResultUrl": "https://airtable.com/appQTd8PXDgHdjOpr",
"cachedResultName": "Dynamic Video Content"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblC9b18Rf1uZZW7m",
"cachedResultUrl": "https://airtable.com/appQTd8PXDgHdjOpr/tblC9b18Rf1uZZW7m",
"cachedResultName": "Order Line Items"
},
"options": {}
},
"typeVersion": 2.1
},
{
"id": "d26b1db9-f190-4ff5-9f9a-f8e24cb15fe0",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-368,
-416
],
"parameters": {
"color": 3,
"width": 368,
"height": 576,
"content": "## Create the Order in Shopify\n\n### This is the core action of the workflow. It takes all the customer and product information gathered from Airtable and uses it to create a new order directly in your Shopify store.\n\n### The fields in this node are carefully mapped to pull data like First Name, Country, Product Name, and Quantity from the previous steps.\n\n### This node turns your Airtable data into a real Shopify transaction."
},
"typeVersion": 1
},
{
"id": "5f84993b-5a4b-4afb-b9b5-4afe10c5e86e",
"name": "Create the Order in Shopify",
"type": "n8n-nodes-base.shopify",
"position": [
-208,
-16
],
"parameters": {
"limeItemsUi": {
"lineItemValues": [
{
"price": "={{ $json.Price }}",
"title": "={{ $json.Title }}",
"quantity": "={{ $json.Quantity }}",
"productId": "={{ $json['Product Name'] }}"
}
]
},
"authentication": "oAuth2",
"additionalFields": {
"email": "={{ $('Fetch Order & Customer Details').item.json['Email ID'] }}",
"shippingAddressUi": {
"shippingAddressValues": {
"zip": "={{ $('Fetch Order & Customer Details').item.json['Zip Code'] }}",
"city": "={{ $('Fetch Order & Customer Details').item.json.City }}",
"phone": "={{ $('Fetch Order & Customer Details').item.json.Phone }}",
"country": "={{ $('Fetch Order & Customer Details').item.json.Country }}",
"address1": "={{ $('Fetch Order & Customer Details').item.json['Address Line 1'] }}",
"address2": "={{ $('Fetch Order & Customer Details').item.json['Address Line 2'] }}",
"lastName": "={{ $('Fetch Order & Customer Details').item.json['Last Name'] }}",
"province": "={{ $('Fetch Order & Customer Details').item.json.Province }}",
"firstName": "={{ $('Fetch Order & Customer Details').item.json['First Name'] }}"
}
}
}
},
"typeVersion": 1
},
{
"id": "1a679ecb-190e-47b7-b8cc-e7a552ef265b",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
48,
-416
],
"parameters": {
"color": 3,
"width": 368,
"height": 576,
"content": "## Send Order Confirmation Email\n\n### Once the Shopify order is created successfully, this node sends a confirmation email to the customer.\n\n\n### It uses data from the new Shopify order (like order_number and total_price) to populate a professional HTML email template. You can customize the HTML in this node to match your brand's style.\n"
},
"typeVersion": 1
},
{
"id": "faaae486-32c7-4cf8-8c1b-15b2bb84ede0",
"name": "Send Order Confirmation Email",
"type": "n8n-nodes-base.gmail",
"position": [
176,
-16
],
"parameters": {
"sendTo": "user@example.com",
"message": "=<div style=\"font-family: Arial, sans-serif; color: #333333; line-height: 1.5; max-width: 600px; margin: auto; padding: 20px; background-color: #f9f9f9; border-radius: 8px;\"> <h2 style=\"color: #4CAF50; text-align: center;\">Your Order is Confirmed!</h2> <p>Hi <strong> {{ $json.customer.first_name }} {{ $json.customer.last_name }}</strong>,</p> <p>Thank you for your order! We're excited to let you know that your order has been successfully placed and is being processed.</p> <h3>Order Summary</h3> <table style=\"width: 100%; border-collapse: collapse; margin-bottom: 20px;\"> <tr> <th style=\"text-align: left; border-bottom: 1px solid #ddd; padding: 8px;\">Order Number</th> <td style=\"padding: 8px;\"> {{ $json.order_number }}</td> </tr> <tr> <th style=\"text-align: left; border-bottom: 1px solid #ddd; padding: 8px;\">Order Date</th> <td style=\"padding: 8px;\">{{ new Date($json.created_at).toISOString().split('T')[0] }}\n\n </td> </tr> <tr> <th style=\"text-align: left; border-bottom: 1px solid #ddd; padding: 8px;\">Total Amount</th> <td style=\"padding: 8px;\">{{ $json.currency }} {{ $json.current_total_price }}</td> </tr> </table> <h3>Item Ordered</h3> <table style=\"width: 100%; border-collapse: collapse; margin-bottom: 20px;\"> <tr> <th style=\"text-align: left; border-bottom: 1px solid #ddd; padding: 8px;\">Product</th> <td style=\"padding: 8px;\">{{ $('Fetch Product Line Items').item.json['Product Name'] }} </td> </tr> <tr> <th style=\"text-align: left; border-bottom: 1px solid #ddd; padding: 8px;\">Quantity</th> <td style=\"padding: 8px;\">{{ $json.line_items[0].quantity }}</td> </tr> <tr> <th style=\"text-align: left; border-bottom: 1px solid #ddd; padding: 8px;\">Price</th> <td style=\"padding: 8px;\">{{ $json.current_subtotal_price_set.shop_money.amount }}</td> </tr> </table> <p>If you have any questions, feel free to reply to this email or contact our support team.</p> <p style=\"text-align: center;\"> <a href=\"{{$json[\"OrderLink\"]}}\" style=\"display: inline-block; padding: 10px 20px; background-color: #4CAF50; color: #ffffff; text-decoration: none; border-radius: 5px;\">View Your Order</a> </p> <p style=\"font-size: 12px; color: #777777; text-align: center; margin-top: 20px;\"> © 2025 Your Samartian. All rights reserved. </p> </div>",
"options": {},
"subject": "Order Confirmed !"
},
"typeVersion": 2.1
},
{
"id": "b8ce7156-635b-4294-b7dd-429aa4995401",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
608,
-416
],
"parameters": {
"color": 3,
"width": 368,
"height": 576,
"content": "## Close the Loop - Update Airtable Status\n\n### This is the final step. It takes the original recordId from the very beginning of the workflow and uses it to find the order record in your Airtable Orders table.\n\n\n### It then updates the 'Shopify Ordered' status to 'Done'. This is crucial because it prevents the Airtable Automation from triggering this workflow for the same order ever again.\n"
},
"typeVersion": 1
},
{
"id": "38c5e7da-e7ec-4dd5-8d52-4684b600483f",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
368,
256
],
"parameters": {
"color": 3,
"width": 432,
"height": 560,
"content": "\n\n\n\n\n\n\n\n\n\n\n\n\n\n## Confirm Email Sent?\n\n### This is a simple but important checkpoint. It checks the output from the Gmail node to confirm that the confirmation email was successfully sent.\n\n\n### If the email has the SENT label, the workflow proceeds. If not, it stops. This prevents us from marking the order as 'Done' in Airtable if the customer didn't receive their confirmation.\n\n\n\n"
},
"typeVersion": 1
},
{
"id": "0899512f-4f91-4e92-91aa-4df4b3861d3c",
"name": "Confirm Email Sent?",
"type": "n8n-nodes-base.if",
"position": [
560,
304
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6ebeb00a-1bed-47dc-b84e-a83e4ea43b04",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.labelIds[0] }}",
"rightValue": "SENT"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "18b32ce7-74e4-42a0-ad1a-0e21502f3981",
"name": "Close the Loop - Update Airtable Status",
"type": "n8n-nodes-base.airtable",
"position": [
752,
-32
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appQTd8PXDgHdjOpr",
"cachedResultUrl": "https://airtable.com/appQTd8PXDgHdjOpr",
"cachedResultName": "Dynamic Video Content"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblEXxxmfYYsMDLC9",
"cachedResultUrl": "https://airtable.com/appQTd8PXDgHdjOpr/tblEXxxmfYYsMDLC9",
"cachedResultName": "Orders"
},
"columns": {
"value": {
"id": "={{ $('Fetch Order & Customer Details').item.json.id }}",
"Shopify Ordered": "Done"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Order Number",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Order Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "First Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address Line 1",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Address Line 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address Line 2",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Address Line 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "City",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Province",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Province",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Zip Code",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Zip Code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email ID",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Line Items",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Order Line Items",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Trigger Shopify",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Trigger Shopify",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shopify Ordered",
"type": "options",
"display": true,
"options": [
{
"name": "Pending",
"value": "Pending"
},
{
"name": "Done",
"value": "Done"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Shopify Ordered",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"typeVersion": 2.1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "e292d3d8-118d-45ef-aebc-1ed81c03bbfe",
"connections": {
"Confirm Email Sent?": {
"main": [
[
{
"node": "Close the Loop - Update Airtable Status",
"type": "main",
"index": 0
}
]
]
},
"Trigger from Airtable": {
"main": [
[
{
"node": "Fetch Order & Customer Details",
"type": "main",
"index": 0
}
]
]
},
"Fetch Product Line Items": {
"main": [
[
{
"node": "Create the Order in Shopify",
"type": "main",
"index": 0
}
]
]
},
"Create the Order in Shopify": {
"main": [
[
{
"node": "Send Order Confirmation Email",
"type": "main",
"index": 0
}
]
]
},
"Send Order Confirmation Email": {
"main": [
[
{
"node": "Confirm Email Sent?",
"type": "main",
"index": 0
}
]
]
},
"Fetch Order & Customer Details": {
"main": [
[
{
"node": "Fetch Product Line Items",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
It seamlessly syncs order data from an Airtable base directly to your Shopify store, creates the official order, and automatically sends a beautiful confirmation email to the customer, closing the loop by updating the status in Airtable. E-commerce Managers Operations Teams…
Source: https://n8n.io/workflows/9448/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automates inventory management and predictive reordering for Shopify stores. It integrates Shopify, Google Sheets, and Slack to monitor inventory levels, calculate dynamic reorder points
Shopify, Google Sheets, Gmail +2
Shopify Order Data to Airtable
Airtable
This workflow provides a robust, end-to-end automated pipeline for managing e-commerce orders. It bridges the gap between your storefront and your fulfillment team by handling inventory validation, mu
Gmail, Slack, Google Sheets
This workflow automates the synchronization of product prices across Shopify and WooCommerce platforms to ensure retail consistency. It triggers when a price change is detected in either system, appli
Shopify Trigger, Woo Commerce Trigger, WooCommerce +3
Never miss a revenue-impacting failure. This n8n workflow monitors your Shopify store and triggers an alert if X minutes pass without a single new order. By automatically detecting unexpected drops in
Stop And Error, Slack, Gmail +1