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.
1. Triggered from Airtable: The workflow starts instantly when an Airtable Automation sends a signal via a webhook. This happens when you mark an order as ready to be processed in your Airtable base.
2. Fetch Order Details: n8n receives the record ID from Airtable and fetches the complete order details, including customer information and the specific line items for that order.
3. Create Order in Shopify: All the gathered information is used to create a new, official order directly in your Shopify store.
4. Send Confirmation Email: Once the order is successfully created in Shopify, a professionally formatted HTML order confirmation email is sent to the customer via Gmail.
5. Update Airtable Status: Finally, the workflow updates the original order record in Airtable, marking its status as "Done" to prevent duplicate processing and keep your records in sync.
1. n8n Instance: An active n8n account (Cloud or self-hosted).
2. Airtable Base: An Airtable base on a "Pro" plan or higher (required for Airtable Automations). It should contain tables for Orders and Order Line Items.
3. Shopify Store: An active Shopify store with API access permissions.
4. Gmail Account: A Gmail account to send confirmation emails.
1. Configure the n8n Workflow:
2. Set Up the Airtable Automation (Crucial Step):
await fetch(webhookUrl, {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({ recordId: recordId }),
});
Click here- Get Started