Sync E-commerce Orders to Google Sheets in Real Time

Learn how to sync e-commerce orders from Shopify to Google Sheets in real time using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To sync e-commerce orders to Google Sheets in real time, you first need to access Pabbly Connect. Begin by navigating to pabby.com/connect in your browser. This will direct you to the Pabbly Connect homepage, where you’ll find options to sign in or sign up for free.

If you are a new user, click on the ‘Sign Up Free’ button to create an account and receive 100 free tasks monthly. Existing users can sign in directly. Once logged in, you will see all Pabbly applications, from which you can access Pabbly Connect by clicking on ‘Access Now’.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create Workflow’ button, and choose ‘Create from Scratch’. This will open the workflow builder where you can select either the Beta or Classic version; opt for the Beta version for a modern experience.

• Select the Beta version for flexibility.
• Name your workflow as ‘Sync E-commerce Orders to Google Sheets in Real Time’.
• Choose an appropriate folder for organization.

After naming your workflow, click the ‘Create’ button to proceed. You will now see a workspace where you can set up triggers and actions for your automation.

3. Setting Up the Trigger with Shopify

In this step, we will set up the trigger for the workflow using Shopify. Select Shopify as the trigger application and choose the event as ‘New Order’. Click ‘Connect’ to proceed, and you will receive a webhook URL to connect your Shopify store with Pabbly Connect.

Copy the webhook URL and head to your Shopify account. Navigate to Settings, then Notifications, and select Webhooks. Create a new webhook with the event set to ‘Order Creation’, format as JSON, and paste the webhook URL. Click ‘Save’ to finalize the setup.

4. Testing the Integration with a Test Order

Once your webhook is set up, it’s time to test the integration. Go back to your Shopify store and place a test order. Select a product, fill in the dummy customer details, and complete the order process. After placing the test order, switch back to Pabbly Connect to check for a response.

You should see a successful response with all the order details, including customer name, email, phone number, product name, amount, and order ID. This confirms that your Shopify store is now successfully integrated with Pabbly Connect.

5. Adding Google Sheets as an Action Step

Now that your trigger is set, the next step is to add Google Sheets as the action application. Select Google Sheets, and choose the event as ‘Add a New Row’. Click ‘Connect’ and sign in with your Google account to allow Pabbly Connect to access your Google Sheets.

After connecting, select the spreadsheet where you want to add the new order details. Map the data fields from the previous steps to the corresponding columns in your Google Sheets, such as customer name, email, phone number, product name, amount, and order ID. Finally, click ‘Save and Send Test Request’ to complete the setup.

Conclusion

By following these steps, you can effectively use Pabbly Connect to sync e-commerce orders from Shopify to Google Sheets in real time. This automation simplifies order management and enhances your operational efficiency. Start using Pabbly Connect today to streamline your e-commerce processes!