Automate Shopify Orders to Google Sheets with Pabbly Connect

Learn how to automatically add multiple product Shopify orders to Google Sheets using Pabbly Connect. Follow this detailed 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. Setting Up Pabbly Connect for Shopify and Google Sheets

In this section, we will explore how to set up Pabbly Connect to automate the process of transferring Shopify orders to Google Sheets. Start by logging into your Pabbly Connect account or create a new one if you haven’t already.

Once logged in, navigate to the dashboard and click on the blue ‘Create Workflow’ button. Enter a name for your workflow, such as ‘Add Shopify Orders to Google Sheets,’ and select the main workflow folder. Click on ‘Create’ to proceed.

2. Configuring Trigger and Action in Pabbly Connect

After creating your workflow in Pabbly Connect, you will see two boxes labeled Trigger and Action. The trigger is the event that starts the automation, while the action is what happens in response. Select Shopify as your trigger application and choose ‘Order Created’ as the event.

• Select Shopify as the trigger application.
• Choose ‘Order Created’ as the trigger event.
• Copy the generated webhook URL for integration.

Next, go to your Shopify admin panel, navigate to Settings, and then Notifications. Scroll down to the Webhooks section and click on ‘Create Webhook.’ Paste the copied webhook URL, select the event as ‘Order Creation,’ and save it. This completes the trigger setup for capturing orders in Pabbly Connect.

3. Testing the Shopify and Pabbly Connect Integration

To test the integration, place a new order in your Shopify store. Ensure that you add multiple products to the cart to verify that the order details are captured correctly. Once the order is placed, return to Pabbly Connect to check if the order data appears in the webhook response.

Upon successful order placement, you will see the order details, including product names, quantities, and customer information. This confirms that the connection between Shopify and Pabbly Connect is working as intended.

4. Transforming Data for Google Sheets Integration

With the order data captured, the next step is to transform this data into a format suitable for Google Sheets. In Pabbly Connect, use the ‘Data Transformer’ feature to convert the JSON format into a more manageable format.

• Select the Data Transformer action in your workflow.
• Map the line item array to convert it into comma-separated values.
• Use the Text Formatter to replace commas with new lines for better organization.

This step ensures that when data is sent to Google Sheets, each product appears on a separate line, making it easier to read and manage. Once the data transformation is complete, you can proceed to connect Google Sheets.

5. Finalizing the Google Sheets Integration

Now that the data is transformed, it’s time to connect Google Sheets to your Pabbly Connect workflow. Select Google Sheets as the action application and choose ‘Add a New Row’ as the action event.

Connect your Google Sheets account to Pabbly Connect, select the spreadsheet where you want to store the order details, and map the fields according to your requirements. Ensure that you map the customer name, email, product names, order ID, quantity, and price correctly.

Once everything is set up, click on ‘Save & Send Test Request’ to verify that the data is correctly added to your Google Sheets. If successful, you will see the order details appear in your specified spreadsheet, confirming the automation is complete.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the integration between Shopify and Google Sheets. By following these steps, you can efficiently manage your Shopify orders and keep your records organized.