How it works

Follow these 4 simple steps to start sending Shopify orders to Airtable automatically

Shopify logo icon

An order is created

App connector: Shopify • Time to complete: 0 minutes (Auto-configured)
Why this matters: This trigger captures new orders the instant they're placed, enabling immediate Airtable record creation that gives teams real-time visibility into orders for production planning, fulfillment coordination, or custom reporting workflows.

This step automatically activates when any new order is placed in your Shopify store. The trigger captures all order information including customer details, shipping address, product line items, and order totals. No configuration is needed - it connects directly to your Shopify store and passes the complete order data to the next step for processing.

Retrieve Shop

App connector: Shopify • Time to complete: 0 minutes (Auto-configured)
Why this matters: Fetches your store's myshopify domain needed to construct direct admin links in Airtable records, enabling one-click navigation from the database to order details in Shopify for quick reference.

The workflow automatically retrieves your shop details from Shopify to build proper admin URLs for each order record. This happens behind the scenes without any input needed from you. The shop information gets combined with order data in later steps to create clickable links that take you directly to the order in your Shopify admin panel.

Loop over order products

App connector: Loop • Time to complete: 0 minutes (Auto-configured)
Why this matters: Processes each line item in the order separately, creating individual Airtable records for each product to enable item-level tracking, production workflows, and granular order analysis.

The loop examines every line item in the order and processes each product individually. If someone orders 3 different products, the loop runs 3 times - once for each item. This allows you to track product performance, inventory movement, and sales patterns at the individual product level rather than just seeing order totals. Each loop iteration passes specific product details like title, variant, SKU, price, and quantity to create separate Airtable records.

airtable logo icon

Add Record

App connector: Airtable • Time to complete: 5 minutes
Why this matters: Creates a detailed Airtable record for each line item with all order, customer, and product information in one place, providing your team with a customizable database for tracking, reporting, and collaboration.

For each product in the order, this step creates a new row in your Airtable base with the fields you chose during setup. You'll configure which Airtable base to use and can select from 22 different data fields including customer information, shipping details, product specifics, and order metadata. The step automatically maps Shopify data to your chosen Airtable columns and includes a direct admin link to view the order in Shopify. Each product gets its own row, so multi-item orders create multiple records for detailed analysis.

Make it your own

Customize this workflow even further:

Add fulfillment status tracking
Create a companion workflow triggered by "Fulfillment Created" that searches Airtable for matching order records and updates a "Fulfillment Status" field with tracking information and fulfillment date.
Filter by product or order criteria
Add filters before the loop that check order tags, product types, or order values, then only send specific orders to Airtable (like wholesale orders or custom product orders) for focused tracking.
Link to customer records
Create a separate Airtable table for customers and modify this workflow to create linked records between orders and customers, enabling relationship tracking and customer-level order history views.
Calculate and track metrics
Add Airtable formula fields or rollup fields that calculate order totals, average order values, or product performance metrics, turning the order log into an analytical dashboard.

Frequently asked questions

Can I send order updates to existing Airtable records?
This workflow only creates new records for new orders. To update existing records when orders are modified (like fulfillment or cancellation), you'd need to create additional workflows that search for matching records by Order ID and update them rather than creating new records.
What happens if I deselect some columns after the table is created?
Deselecting columns in the workflow won't delete existing columns in Airtable—it just stops populating them with new data. Existing data remains intact. To fully remove columns, you'll need to delete them manually in Airtable.
Can I send this to multiple Airtable bases or tables?
This workflow sends to one base and table. To log orders in multiple locations, either duplicate the "Add Record" step with different base/table configurations, or create separate workflows for each destination with different filtering criteria.
What is a template?
Templates are pre-made workflows by our team of experts. Instead of building a workflow from scratch, these have all the steps needed to complete the task.
Can I personalize a template?
Yes! Every step can be customized to meet your exact requirements. Additionally, you can even add more steps and make it more sophisticated.
Are templates free?
Yes! Our entire library containing hundreds of templates are free to use and customize to your exact needs.

Ready to start sending Shopify orders to Airtable automatically?

Join thousands who've automated their work and saved an average of 3.5 hours every week.

Start with this template — It's free
7-day free trial • 8 min setup • Cancel anytime