Integrate Shopify with Google Sheets Using Pabbly Connect

Learn how to automatically add product details from Shopify to Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Shopify and Google Sheets Integration

To start integrating Shopify with Google Sheets, you need to access Pabbly Connect. First, visit the Pabbly website and sign in to your account. If you don’t have an account, you can sign up for free. Once signed in, navigate to the Pabbly Connect dashboard.

Here, you will find the option to create a new workflow. Click on the ‘Create Workflow’ button, and name your workflow. For this tutorial, let’s name it ‘Shopify to Google Sheets’. This naming helps in identifying the workflow later.

2. Setting Up the Trigger Event in Pabbly Connect

The next step involves setting up the trigger event in Pabbly Connect. Choose Shopify as the trigger application. For the trigger event, select ‘Product Updated’. This option ensures that every time a product is updated in Shopify, the details will be captured.

• Select Shopify as the trigger application.
• Choose ‘Product Updated’ as the trigger event.
• Copy the generated webhook URL provided by Pabbly Connect.

After copying the webhook URL, you need to set it in your Shopify account. This URL will connect Shopify to Pabbly Connect, allowing it to receive updates whenever a product is modified.

3. Configuring the Webhook in Shopify

Now, navigate to your Shopify dashboard to configure the webhook. Click on ‘Settings’ at the bottom left corner, then select ‘Notifications’. Scroll down to find the ‘Create Webhook’ section. Here, choose the event as ‘Product Update’ and paste the webhook URL you copied from Pabbly Connect.

Make sure to leave the format as JSON and select the latest API version. Once done, click on ‘Save’. You should see a confirmation message indicating that the webhook has been saved successfully.

4. Testing the Integration Between Shopify and Google Sheets

To ensure that the integration works correctly, you need to test it. Go back to your Shopify dashboard and update a product. For instance, you can create or modify a product, such as adding an air conditioner with a specific price.

After saving the product, return to Pabbly Connect to check if it captures the response. You should see the details of the product, including the title and price, successfully retrieved from Shopify.

• Confirm that the product details are captured in Pabbly Connect.
• If successful, proceed to set up the action event.

This step verifies that Pabbly Connect is receiving updates from Shopify, which is crucial for the next steps.

5. Adding Product Details to Google Sheets

In this final step, you will set up the action event to add the product details to Google Sheets. Select Google Sheets as the action application in Pabbly Connect. Choose the action event as ‘Add New Row’. This ensures that each time a product is updated, a new row will be added to your specified Google Sheets document.

Next, connect your Google Sheets account and grant the necessary permissions. After connecting, select the spreadsheet where you want the product details to be added. Map the fields such as the product title and price to the respective columns in your Google Sheets.

Finally, save the configuration and send a test request. Check your Google Sheets to confirm that the product details have been successfully added as a new row, indicating that the integration is complete.

Conclusion

In this tutorial, we demonstrated how to integrate Shopify with Google Sheets using Pabbly Connect. By following these steps, you can automate the process of updating product details in Google Sheets whenever a product is modified in Shopify. This integration streamlines your workflow and saves time, allowing you to focus on other aspects of your business.