Templates / Automatically transfer Shopify order data to structured Airtable records

Automatically transfer Shopify order data to structured Airtable records

Ready for 3.0

by Mohammed Abid ✓ · 284 views · created 2025-07-26 · CRM

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 9 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Airtable.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

  1. Code: runs custom JavaScript code
  2. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  3. Sheet (Edit Fields (Set)): sets 39 fields: Order ID, Order Number, Order Created At…
  4. Order Sheeet (Airtable): search
  5. Code: runs custom JavaScript code
  6. Edit Fields (Edit Fields (Set)): sets 41 fields: S No, Order ID, Order Name…
  7. Generating S No (Code): runs custom JavaScript code
  8. CustomerSheet (Airtable): create or update

Services it uses

Airtable

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (5)

From the author

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…

Excerpt from Mohammed Abid's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.