Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Shopify and Google Sheets Integration

To begin the integration process, you first need to access Pabbly Connect. If you are a new user, visit pabbl.com/connect in your browser and click on the “Sign Up for Free” option in the top right corner. This will allow you to explore Pabbly Connect with 100 free tasks every month.

Once you have signed up, log into your Pabbly Connect account. Here, you will find the workflow builder, which is essential for creating your automation between Shopify and Google Sheets. This tool is where you will set up the trigger and action that will facilitate the integration.

2. Setting Up the Trigger in Pabbly Connect

The first step in automating your Shopify orders is to set up the trigger in Pabbly Connect. Click on the “Add Trigger” button and select Shopify as your application. Choose “Shopify V2” to ensure compatibility and select the event as “New Order.” This will initiate the workflow whenever a new order is placed.

  • Select Shopify V2 as the trigger application.
  • Choose the event “New Order”.
  • Click on “Connect” to receive the Webhook URL.

After copying the Webhook URL provided by Pabbly Connect, navigate to your Shopify account. Go to Settings > Notifications, and under Webhooks, click on “Add New Webhook.” Set the event to “Order Creation,” keep the format as JSON, and paste the copied URL. Finally, save your changes. This establishes the connection between Shopify and Pabbly Connect.

3. Capturing Webhook Response in Pabbly Connect

To capture the webhook response, you need to perform a test submission. Go back to your Shopify store and make a test purchase. Fill in the required details and complete the order. Once you do this, Pabbly Connect will automatically capture the response containing order details like customer name, email, and product information.

Once the order is placed, return to your Pabbly Connect workflow. You should see the captured response displayed, confirming that the integration is working. This response will include all necessary details that will later be sent to Google Sheets.

4. Adding Action Step to Send Data to Google Sheets

Next, you need to add an action step in Pabbly Connect to send the captured order details to Google Sheets. Click on “Add New Action Step” and select Google Sheets as your action application. Choose the event “Add New Row” to automatically insert the order details into your spreadsheet.

  • Select Google Sheets as the action application.
  • Choose “Add New Row” as the event.
  • Connect your Google Sheets account to Pabbly Connect.

When prompted to connect your Google account, select the appropriate account and grant the necessary permissions. You will then need to select the spreadsheet and sheet where the order details will be stored. Map the fields from the captured response to the corresponding columns in Google Sheets, ensuring that data is dynamically inserted with each new order.

5. Finalizing the Integration and Testing

Once you have mapped all necessary fields, including customer name, email, phone number, product, quantity, and total amount, click on “Save and Send Test Request” in Pabbly Connect. This will send a test entry to your Google Sheets. You should see the order details appear in your designated spreadsheet.

To finalize, ensure that the status column is set to “Placed,” and your team can later update this status as needed. This setup allows you to manage Shopify orders seamlessly through Google Sheets, making your workflow efficient and organized.

By following these steps, you can automate the process of transferring Shopify order data to Google Sheets using Pabbly Connect. This integration not only saves time but also minimizes errors in manual data entry.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the integration of Shopify orders with Google Sheets. By following the steps outlined, you can streamline your order management process effectively.