How to Sync New Shopify Orders to Google Sheets with Pabbly Connect

Learn how to sync new Shopify orders to Google Sheets using Pabbly Connect for efficient order tracking and management. Follow our step-by-step tutorial! Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Shopify Orders

To sync new Shopify orders to Google Sheets, you first need to access Pabbly Connect. Start by opening a new tab and going to the Pabbly Connect website.

Once there, you can sign up for a free account or log in if you already have one. After logging in, you will reach the dashboard where you can create and manage your automation workflows.

2. Creating a New Workflow in Pabbly Connect

To create a new workflow in Pabbly Connect, click on the ‘Create Workflow’ button in the dashboard. Here, you will choose between the new version or the classic version of the workflow builder.

For this tutorial, select the new version for its faster and more flexible interface. Name your workflow ‘Sync New Shopify Orders to Google Sheets for Better Tracking’ and choose a folder to organize your workflow.

• Click on ‘Create’ to finalize your workflow.
• Toggle the button to activate your workflow.
• Click on the ‘Add Trigger’ option to proceed.

Now you are ready to set up the trigger for your workflow.

3. Setting Up Shopify as the Trigger in Pabbly Connect

For this integration, select Shopify as your trigger application in Pabbly Connect. Choose ‘New Order’ as the event that will trigger the workflow. This means every time a new order is placed in Shopify, it will initiate the workflow.

After selecting the trigger, you will receive a webhook URL that acts as a bridge between Shopify and Pabbly Connect. Copy this URL and log in to your Shopify account.

• Go to the ‘Settings’ section in Shopify.
• Navigate to ‘Notifications’ and then click on ‘Create Webhook’.
• Select ‘Order Creation’ as the event and paste the webhook URL.

After saving the webhook, return to Pabbly Connect to wait for the webhook response.

4. Testing the Integration with a Sample Order

To test the integration, create a sample order in your Shopify store. This will trigger the webhook you set up in Pabbly Connect. Go back to Shopify, select a product, and complete the checkout process.

Once the order is placed, return to Pabbly Connect to see the webhook response. This response will include all order details such as customer name, email, order item, amount, and more.

Check if all details are correctly received in Pabbly Connect. If everything looks good, proceed to the next step.

Now you are ready to set up the action to send this data to Google Sheets.

5. Adding New Rows to Google Sheets via Pabbly Connect

Next, select Google Sheets as your action application in Pabbly Connect. Choose the ‘Add New Row’ action event to store the order details in your Google Sheets.

Connect your Google account by clicking on ‘Sign in with Google’ and authorizing Pabbly Connect to access your Google Sheets. After connecting, select the spreadsheet you created for Shopify order details.

Map the fields from the webhook response to the corresponding columns in your Google Sheet. Ensure that all fields like name, email, order item, amount, and city are properly linked.

Save your settings and send a test request to verify that the data is correctly added to your Google Sheets. Once confirmed, your automation is complete!

Conclusion

By following this tutorial, you have successfully learned how to sync new Shopify orders to Google Sheets using Pabbly Connect. This integration streamlines order tracking and enhances your inventory management. Now you can efficiently manage your sales data without manual entry!