Watch Step By Step Video Tutorial Below





1. Setting Up Pabbly Connect for Shopify Integration

To turn your Shopify store into a live order tracker, the first step is to access Pabbly Connect. This platform enables seamless integration between Shopify and Google Sheets, allowing you to automatically track new orders.

Log into your Pabbly Connect account and click on “Create Workflow”. Choose “Create from Scratch” and name your workflow. Select the folder you want to save it in, such as “Automate Google Sheets”, and click “Create”. Your workflow is now ready to be configured.

2. Configuring the Trigger App in Pabbly Connect

Next, you will set up the trigger app in Pabbly Connect. For this integration, select Shopify as your trigger app. The event you want to trigger is “New Order”. This means every time a new order is placed in your Shopify store, it will activate the workflow.

After selecting the trigger, you will need to connect Pabbly Connect to your Shopify account using a Webhook. This Webhook acts as a bridge between Shopify and Pabbly Connect. Follow these steps to create the Webhook:

  • Go to Shopify settings and select “Notifications”.
  • Create a new Webhook and select “Order Creation” as the event.
  • Paste the Webhook URL provided by Pabbly Connect into the URL field.
  • Select JSON format and save the Webhook.

Once the Webhook is created, return to Pabbly Connect and click on “Test Trigger” to ensure that the connection is working correctly.

3. Sending a Test Order to Capture Webhook Response

In this step, you will send a test order from your Shopify store to capture the Webhook response in Pabbly Connect. Go to your Shopify store and simulate a new order by adding a product to your cart and proceeding to checkout.

Fill in the required details, including a test email like “[email protected]” and a name such as “latest lead”. Complete the order process. After the order is confirmed, check back in Pabbly Connect to see if the test order details have been captured successfully.

You should see the order details, including customer information, product details, and payment status. This confirms that your setup is functioning properly and ready for further integration.

4. Adding Google Sheets as the Action App

Now, you will add Google Sheets as the action app in Pabbly Connect. Select Google Sheets and choose the action event “Add New Row”. This action will ensure that every new order from Shopify is automatically added to your Google Sheets document.

Connect your Google account to Pabbly Connect by clicking on “Connect”. You will be prompted to log in and grant permissions. Once connected, select the Google Sheets document you created for tracking orders.

  • Select the spreadsheet named “Shopify Orders”.
  • Map the order details from Shopify to the corresponding columns in your Google Sheets.
  • Ensure all fields like name, email, product, and price are correctly linked.

After mapping the fields, click on “Save & Send Test Request” to verify if the data is being sent to Google Sheets correctly.

5. Finalizing the Integration and Conclusion

After successfully setting up the integration, every time a new order is placed in your Shopify store, the details will automatically populate in your Google Sheets document. This setup allows for efficient tracking of orders without manual entry.

By utilizing Pabbly Connect, you have streamlined the order tracking process, making it easier to manage and analyze your Shopify orders. This integration not only saves time but also minimizes errors associated with manual tracking.

With Pabbly Connect, you can create various automations to enhance your business operations. Start using this powerful tool today to maximize efficiency and productivity!