Shopify Order Data to Airtable
This n8n template demonstrates how to capture incoming Shopify order webhooks, transform the data into a structured format, and insert each product line item as a separate record in an Airtable sheet. It provides both high-level order information and detailed product-level metrics, making it ideal for analytics, reporting, inventory management, and customer insights.
Good to Know
Airtable API Rate Limits: By default, Airtable allows 5 requests per second per base. Consider batching or adding delays if you process high volumes of orders.
Shopify Webhook Configuration: Ensure you have configured the orders/create webhook in your Shopify Admin to point to the n8n webhook node.
Field Mapping: The template maps standard Shopify fields; if your store uses custom order or line item properties, update the Function nodes accordingly.
How It Works
Webhook Trigger: A Shopify orders/create webhook fires when a new order is placed.
Normalize Order Data: The Function node extracts core order, customer, shipping, and billing details and computes financial totals (subtotal, tax, shipping, discounts).
Line Item Breakdown: A second Function node builds an array of objects—one per line item—calculating per-item totals, tax/shipping allocation, and product attributes (color, size, material).
Check Customer Record: Optionally check against an Airtable "Customers" sheet to flag new vs existing customers.
Auto-Increment Record ID: A Function node generates a running serial number for each Airtable record.
Insert Records: The Airtable node writes each line item object into the target base and table, creating rich records with both order-level and product-level details.
How to Use
Clone the Template: Click "Use Template" in your n8n instance to import this workflow.
Configure Credentials:
Shopify Trigger: Add your Shopify store domain and webhook secret.
Airtable Node: Set up your Airtable API key and select the base and table.
Review Field Names: Match the field names in the Function nodes to the columns in your Airtable table.
Activate Workflow: Turn on the workflow and place a test order in your Shopify store.
Verify Records: Check your Airtable sheet to see the new order and its line items.
Requirements
n8n@latest
Shopify Store with orders/create webhook configured
Airtable Account with a base and table ready to receive records
Customizing This Workflow
Add Custom Fields: Extend the Functions to include additional Shopify metafields, discounts, or customer tags.
Alternative Destinations: Replace the Airtable node with Google Sheets, Supabase, or another database by swapping in the corresponding node.
Error Handling: Insert If/Wait nodes to retry on API failures or send notifications on errors.
Multi-Currency Support: Adapt the currency logic to convert totals based on dynamic exchange rates.