Automatically Add Multi-Product Shopify Order Details in Airtable Using Pabbly Connect

Learn how to automatically add multi-product Shopify order details in Airtable using Pabbly Connect with this step-by-step tutorial. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Shopify and Airtable Integration

To automatically add multi-product Shopify order details in Airtable, we will use Pabbly Connect. Start by accessing Pabbly Connect, where you can create a new workflow. If you don’t have an account, sign up for free to get started.

Once logged in, click on the ‘Access Now’ button under Pabbly Connect. This action will take you to the dashboard, where you can see existing workflows and create new ones. Click on the ‘Create Workflow’ button, name your workflow, and select the folder where you want to save it. This sets the foundation for your automation.

2. Configuring Trigger for New Order in Shopify

The first step in the workflow is to set up the trigger using Pabbly Connect. Select Shopify as the trigger application and choose ‘New Order’ as the trigger event. This means that the workflow will activate each time a new order is placed in Shopify.

• Select Shopify as the trigger application.
• Choose ‘New Order’ from the trigger events.
• Copy the webhook URL generated by Pabbly Connect.

Next, you will connect Shopify to Pabbly Connect by creating a new webhook. Go to Shopify settings, find the notifications section, and create a new webhook for order creation. Paste the copied webhook URL and select JSON as the format before saving.

3. Retrieving Multi-Product Order Details

After setting up the trigger, it’s crucial to retrieve the order details using Pabbly Connect. To do this, create a multi-product order in your Shopify store. This will generate a response that contains all the details of the order.

Once you have created the order, go back to Pabbly Connect. You will see that it is waiting for the webhook response. Ensure that the ‘Simple Response’ toggle is off to receive the response in advanced format. This allows you to see all the details of the order in the response.

4. Transforming Order Data Using Pabbly Connect

Now that you have the order details, you need to transform the data for Airtable. Use the Data Transformer feature in Pabbly Connect to convert the line items array into a comma-separated format. This makes it easier to send the data to Airtable.

• Add a new action step and select Data Transformer.
• Choose ‘Line Itemizer’ as the action event.
• Map the line items array to separate them by commas.

Once the transformation is complete, you will have the product names, quantities, and unit prices ready for mapping into Airtable. This step is crucial for ensuring that the data is formatted correctly before it reaches Airtable.

5. Sending Data to Airtable

The final step involves sending the transformed data to Airtable using Pabbly Connect. Choose Airtable as the action application and select ‘Create Record’ as the action event. This allows you to add the order details into your Airtable workspace.

To connect Airtable with Pabbly Connect, you will need to generate an API token from your Airtable account. Navigate to the developer hub in Airtable, create a new token, and ensure you select the appropriate scopes for accessing your base.

After setting up the connection, map the fields in Airtable to the corresponding data from Shopify. This includes customer name, product name, quantity, and unit price. Once everything is mapped, click on ‘Save and Send Test Request’ to verify that the data is correctly added to Airtable.

Conclusion

In this tutorial, we successfully demonstrated how to automatically add multi-product Shopify order details in Airtable using Pabbly Connect. By following the steps outlined, you can streamline your order processing and ensure accurate data management between Shopify and Airtable.