Send Shopify Orders to Google Sheets Using Pabbly Connect

Learn how to automatically send Shopify orders to Google Sheets using Pabbly Connect in this 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 Automation

To start sending Shopify orders to Google Sheets, you need to access Pabbly Connect. Open a new tab and type Pabbly.com/connect in the URL bar. This will take you to the Pabbly Connect homepage.

Once on the homepage, you will see options to either sign in or sign up for free. New users can select ‘Sign Up Free’ to create an account, which gives you 100 free tasks each month. Existing users should click on ‘Sign In’ to access their accounts and begin creating workflows.

2. Creating a Workflow in Pabbly Connect

After signing into Pabbly Connect, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button to start. You will be prompted to choose between creating from scratch or using AI.

• Select ‘Create from Scratch’ for a manual setup.
• Choose the beta workflow builder for a modern experience.
• Name your workflow, such as ‘Add Shopify Orders to Google Sheets’.

Once named, select the folder for organization and click ‘Create’. Your new workflow will be ready for configuration.

3. Setting Up the Trigger App: Shopify

In this step, you will set Shopify as the trigger app in Pabbly Connect. Click on the ‘Add Trigger’ button and search for ‘Shopify V2’. Select it and choose the event as ‘New Order’ to initiate the workflow whenever a new order is placed.

After selecting the event, click on the ‘Connect’ button. You will receive a webhook URL, which you need to copy. This URL acts as a bridge between Shopify and Pabbly Connect for data transfer.

4. Configuring the Shopify Webhook

Now, navigate to your Shopify account to set up the webhook. Go to ‘Settings’ and then ‘Notifications’. Here, you will find the option for webhooks. Click on ‘Create Webhook’ and select the event as ‘Order Creation’.

• Paste the copied webhook URL from Pabbly Connect.
• Click on ‘Save’ to finalize the webhook setup.

Once saved, Pabbly Connect will be ready to receive data from Shopify whenever a new order is created. You can test the connection by placing a new order on your Shopify store.

5. Adding Google Sheets as the Action App

After confirming that Pabbly Connect is receiving order data, it’s time to set Google Sheets as the action app. Click on ‘Add New Action Step’ and select ‘Google Sheets’. Choose the event ‘Add New Row’ to insert the order details into your Google Sheet.

When prompted, connect to your Google account. Select the spreadsheet where you want to add the data, typically named ‘Shopify Orders’. Map the fields such as customer name, email, phone number, address, product, and total amount from the data received from Shopify.

Conclusion

By following these steps, you can easily automate the process of sending Shopify orders to Google Sheets using Pabbly Connect. This integration saves time and ensures accurate order tracking. Start utilizing Pabbly Connect today to enhance your business efficiency!