Watch Step By Step Video Tutorial Below
1. Accessing Pabbly Connect for Integration
To start using Pabbly Connect, open your browser and navigate to pabbly.com/connect. This is where you can sign up or log in to your account.
Once logged in, you’ll be directed to the Pabbly Connect dashboard. This platform allows you to create automated workflows that connect various applications, including Shopify and Google Sheets.
2. Setting Up the Trigger in Pabbly Connect
In this step, we will configure the trigger for our integration using Pabbly Connect. Select Shopify as the trigger application since we want to capture new orders.
Choose the event labeled “New Order”. This event will trigger the workflow when a new order is placed in your Shopify store. After selecting the trigger, you will be prompted to create a connection.
- Select Shopify as the trigger application.
- Choose the “New Order” event.
- Create a connection to your Shopify account.
Once the connection is established, Pabbly Connect will provide you with a Webhook URL. This URL needs to be added to your Shopify account to capture the order data.
3. Configuring Webhooks in Shopify
Now, navigate to your Shopify account settings. Here, you will set up the Webhook to send order details to Pabbly Connect.
Go to the Notifications section in your Shopify settings, and find the Webhooks option. Select “Create Webhook” and choose the event “Order Creation”. Paste the Webhook URL provided by Pabbly Connect and save the changes.
- Access Shopify settings and go to Notifications.
- Select the Webhooks option and create a new Webhook.
- Choose “Order Creation” as the event and paste the Webhook URL.
After saving, Pabbly Connect will wait for a response from Shopify, indicating that the Webhook is set up correctly.
4. Adding Order Details to Google Sheets
Next, we will set up the action to add order details to Google Sheets using Pabbly Connect. Select Google Sheets as your action application.
Choose the event “Add New Row”. This action will allow you to input the order details into a new row in your specified Google Sheet. Connect to your Google account if you haven’t done so already.
Once connected, select the spreadsheet named “Shopify Orders” and map the necessary fields to include customer name, email, product details, and total amount. Use the mapping feature in Pabbly Connect to automatically pull this data from the Shopify order.
5. Testing the Integration and Finalizing the Setup
With everything set up, it’s time to test the integration. Create a new order in your Shopify store by clicking the “Buy Now” button and filling in the required details.
After completing the order, return to Pabbly Connect and check if the order details have been successfully added to your Google Sheet. You should see the customer’s name, email, phone number, product purchased, and total amount recorded.
This successful integration demonstrates how Pabbly Connect can automate the process of transferring order details from Shopify to Google Sheets, saving you time and effort.
Conclusion
By following this tutorial, you learned how to integrate Shopify with Google Sheets using Pabbly Connect. This automation streamlines your order management process and enhances efficiency.



