How to Import Specific Data from Shopify to Google Sheets Using Pabbly Connect

Learn how to automate the import of specific data from Shopify to Google Sheets using Pabbly Connect. Step-by-step tutorial for seamless integration. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Shopify Google Sheets Integration

To import specific data from Shopify to Google Sheets, you need to start by setting up Pabbly Connect. This platform allows you to automate the transfer of data between different applications seamlessly. First, create a free account on Pabbly Connect if you haven’t done so already. Once you have your account, log in to access the dashboard.

From the dashboard, click on the ‘Create Workflow’ button. Name your workflow, for example, ‘Shopify to Google Sheets Integration’. After naming your workflow, click on the ‘Create’ button to proceed. This will open the workflow editor where you will set up the trigger and action for your automation.

2. Choosing Shopify as Trigger Application in Pabbly Connect

In your Pabbly Connect workflow, select Shopify as the trigger application. The trigger event you need is ‘New Order’ which indicates that a new order has been placed in your Shopify store. This will initiate the workflow each time an order is created. using Pabbly Connect

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

Next, you will need to set up this webhook in your Shopify store. Go to your Shopify dashboard, click on ‘Settings’, and then select ‘Notifications’. Scroll down to the ‘Webhooks’ section and click on ‘Create Webhook’. Here, paste the webhook URL you copied from Pabbly Connect into the URL field, and select ‘JSON’ as the format. Save the webhook settings.

3. Testing the Webhook Connection in Pabbly Connect

After setting up the webhook in Shopify, it’s time to test the connection. You need to create a test order in your Shopify store. This is essential to capture the order data and ensure that the webhook is functioning correctly. using Pabbly Connect

To create a test order, navigate back to your Shopify store and select a product to purchase. Complete the checkout process using dummy information for the order. Once the order is created, return to Pabbly Connect, and you will see that it is waiting for a response from Shopify.

• Create a test order in Shopify.
• Check Pabbly Connect for the received data.
• Verify that the order details are captured correctly.

Once the test order is created, Pabbly Connect will capture the order details, including the product ID, which you will need for the next steps. Make sure to check that the data is received as expected before proceeding to the next phase of the integration.

4. Applying Filters in Pabbly Connect for Specific Products

Now that you have the order details captured, the next step is to apply a filter within Pabbly Connect to ensure that only specific products trigger the action. In this case, you want to filter for a specific product, such as the ‘Center Table’. using Pabbly Connect

To do this, add a filter action step in your workflow. Choose the product ID from the previous step and set the condition to equal the product ID of the Center Table. This will ensure that the workflow only continues if the specified product is ordered.

Add a filter action step in Pabbly Connect. Select the product ID from the previous step. Set the condition to ‘equals to’ and input the specific product ID.

Once the filter is set, test the filter to ensure it is configured correctly. If the condition is met, the workflow will proceed to the next action of adding data to Google Sheets.

5. Adding Data to Google Sheets Using Pabbly Connect

The final step in this integration is to add the captured order details to Google Sheets. In your Pabbly Connect workflow, add an action step and select Google Sheets as the application. using Pabbly Connect

Choose the action event as ‘Add New Row’. Then, connect your Google account by clicking on ‘Sign in with Google’. After authorizing Pabbly Connect to access your Google Sheets, select the specific spreadsheet and sheet where you want the data to be added.

Select Google Sheets as the action application. Choose the action event ‘Add New Row’. Map the fields from the Shopify order data to the respective columns in Google Sheets.

After mapping the necessary fields, such as customer name, email, order date, and quantity, click on ‘Save’ and then test the action to ensure that data is being sent correctly to your Google Sheets. Upon successful testing, your integration is complete, and new order details will automatically populate in your spreadsheet as orders are placed for the specified product.

Conclusion

In this tutorial, we demonstrated how to import specific data from Shopify to Google Sheets using Pabbly Connect. By following the steps outlined, you can automate the data transfer process seamlessly, ensuring that your spreadsheets are always up to date with order information.