Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Every Order Auto-Saved in Google Sheets | Pabbly Connect Automation

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start the integration process, you must first access Pabbly Connect. Open a new tab and navigate to the Pabbly website.

If you are a new user, click on the ‘Sign Up Free’ option to create an account. Existing users can simply log in. Once logged in, you will see the Pabbly apps. Click on the ‘Access Now’ button under Pabbly Connect to reach the dashboard.

2. Creating a Workflow in Pabbly Connect

After accessing the dashboard of Pabbly Connect, you can create a new workflow. Click on the ‘+ Create Workflow’ button. You will have options to create from scratch or using AI; select ‘Create from Scratch’.

Enter a name for your workflow, such as ‘Every Order Auto Saved in Google Sheet’.
Select the folder for your workflow, typically ‘Pabbly Connect’.
Click on the ‘Create’ button to finalize the setup.

Your new workflow is now created, and you can proceed to set up the trigger application.

3. Setting Up the Trigger Application: Shopify

The next step is to set up the trigger application using Pabbly Connect. Select Shopify as your trigger application, and choose the event as ‘New Order’. Click on the ‘Connect’ button.

Pabbly Connect will provide you with a webhook URL. Copy this URL as it will be used in your Shopify settings to connect the two platforms.

Go to your Shopify account and click on ‘Settings’.
Select ‘Notifications’ and click on ‘Webhooks’.
Click on ‘Create Webhook’, select ‘Order Creation’, and paste the webhook URL.

After saving the webhook, your Shopify account is now linked with Pabbly Connect, ready to capture new orders automatically.

4. Setting Up the Action Application: Google Sheets

Now, we will set the action application to Google Sheets in Pabbly Connect. Select Google Sheets and choose the event ‘Add New Row’. You will be prompted to connect your Google Sheets account.

Click on ‘Add New Connection’ and sign in with your Google account. Allow the necessary permissions for Pabbly Connect to access your Google Sheets.

Select the spreadsheet you want to use, such as ‘Shopify Order Details’.
Map the fields from the Shopify order to the corresponding columns in Google Sheets.
Click on ‘Save and Send Test Request’ to ensure everything is working correctly.

Once the test is successful, your Google Sheets will automatically update with new order details from Shopify, showcasing the efficiency of Pabbly Connect.

5. Finalizing the Automation Workflow

After mapping all necessary fields, click on the ‘Save’ button in Pabbly Connect to finalize your automation. This will ensure that every new order placed in Shopify is recorded in your Google Sheets without manual input.

Now, you can test the entire workflow by placing a new order in your Shopify store. Check your Google Sheets to confirm that the order details have been added automatically.

This automation not only saves time but also enhances your business operations by providing accurate tracking of orders. If you encounter any issues, feel free to reach out for support.

Conclusion

In this tutorial, we explored how to integrate Shopify with Google Sheets using Pabbly Connect. This integration automates order tracking, saving time and enhancing efficiency. By following these steps, you can streamline your business processes effectively.