Integrate Shopify Orders with Airtable Automatically Using Pabbly Connect

Learn how to automatically add Shopify orders to Airtable using Pabbly Connect. Follow this step-by-step tutorial for seamless integration! Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Shopify and Airtable Integration

To integrate Shopify with Airtable, you will first need to access Pabbly Connect. Start by logging into your Pabbly Connect account. This platform is essential for creating automated workflows between your applications.

Once logged in, navigate to the dashboard. From there, click on the ‘Create Workflow’ button. You will be prompted to select a workflow builder. Choose the ‘New’ workflow builder for a modern interface and enhanced features.

2. Setting Up the Trigger in Pabbly Connect

In this step, you will set up the trigger for your workflow using Pabbly Connect. After creating your workflow, click on the ‘Add Trigger’ button. Search for and select ‘Shopify’ as the application and choose ‘New Order’ as the event.

• Select ‘Shopify V2’ for the trigger.
• Click on ‘Connect’ to establish a connection with your Shopify account.
• Copy the webhook URL provided by Pabbly Connect.

Now, head over to your Shopify account. Under the settings, navigate to ‘Notifications’ and then to ‘Webhooks’. Click on ‘Create Webhook’, select ‘Order Creation’ as the event, and paste the copied URL. Save the changes to establish the connection.

3. Testing the Connection Between Shopify and Pabbly Connect

After setting up the trigger, it’s time to test the connection using Pabbly Connect. You need to perform a test submission by purchasing a product from your Shopify store. This step ensures that the webhook is functioning correctly.

Go to your Shopify store and select a product to purchase. Complete the checkout process by entering the required details, including your payment information. Once the payment is successful, return to Pabbly Connect to see if the order details have been captured as a webhook response.

4. Adding Airtable as an Action in Pabbly Connect

Now that the Shopify trigger is set up and tested, you will add Airtable as the action application in Pabbly Connect. Click on ‘Add New Action Step’ and select ‘Airtable’ as the application.

• Choose ‘Create Record’ as the action event.
• Connect your Airtable account by granting permissions to access your bases.
• Select the specific base and table where you want to store the order details.

Once connected, you can map the details from the Shopify order to the appropriate fields in Airtable. Mapping allows for dynamic data insertion, ensuring that every new order is automatically recorded.

5. Finalizing and Testing the Workflow in Pabbly Connect

After mapping the order details, it’s time to finalize your workflow in Pabbly Connect. Click on ‘Save and Send Test Request’ to verify that the order details are correctly added to Airtable.

Upon successful completion, check your Airtable base to see the new record reflecting the order information. You will see all relevant details, including order number, customer name, email, product name, quantity, and total amount. This automation will now run in the background, automatically adding new Shopify orders to Airtable without manual input.

Conclusion

By following this tutorial, you have successfully integrated Shopify with Airtable using Pabbly Connect. This automation saves time and reduces manual errors by automatically adding new orders to your Airtable base. With Pabbly Connect, managing your e-commerce orders has never been easier!