Send Shopify Orders to Airtable

When an order is created in Shopify, this trigger activates the workflow and captures complete order data including {{shopify.id}}, {{shopify.name}}, {{shopify.email}}, {{shopify.customer}}, {{shopify.total_price}}, {{shopify.shipping_address}}, {{shopify.tags}}, {{shopify.note}}, {{shopify.created_at}}, and {{shopify.line_items[]}} which contains all products with their details. The workflow runs for every new order placed in your store.

This step retrieves your Shopify store information, specifically {{shopify_1.myshopify_domain}}, which contains your store's unique domain (like "yourstore.myshopify.com"). This domain is used to build the order URL format "https://admin.shopify.com/store/yourstore/orders/[id]" that appears in the Admin Order URL column.

This loop step iterates through each item in the {{shopify.line_items[]}} array. For every line item, the loop executes the Airtable record creation step using {{loop.title}}, {{loop.variant_title}}, {{loop.sku}}, {{loop.price}}, {{loop.quantity}}, and {{loop.id}}. This granular approach creates one Airtable record per product, which is essential for workflows where individual items need tracking, production assignments, or fulfillment coordination.

This step adds a new record to your Airtable base and table with fields you configured during setup. Configuration: During initial setup, you'll (1) Name your table (it will be created automatically), (2) Select an existing Airtable base to house the table, and (3) Choose which columns to include from options like Order ID, Order Name, Order Email, Customer First Name, Customer Last Name, Customer Email, Total Price, Shipping Address fields, Order Tags, Order Notes, Product Title, Product Variant, Product SKU, Product Price, Product Quantity, Line Item ID, Created At, and Admin Order URL. The workflow maps Shopify data to Airtable fields: {{shopify.id}} to Order ID, {{shopify.name}} to Order Name (number), {{shopify.email}} to Order Email, customer name fields, {{shopify.total_price}} to Total Price, shipping address components, {{shopify.tags}} to Order Tags, {{shopify.note}} to Order Notes, {{loop.title}} to Product Title, {{loop.variant_title}} to Product Variant, {{loop.sku}} to Product SKU, {{loop.price}} to Product Price, {{loop.quantity}} to Product Quantity, {{loop.id}} to Line Item ID, {{shopify.created_at}} to Created At, and the constructed admin URL to Admin Order URL. The typecast parameter is false, meaning field types must match data types (numbers as numbers, text as text). All selected columns are created in the new table automatically.