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

Turn Every New Customer Into a Record in Your Business Database

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, visit pabbly.com/connect. This platform will enable you to automate the process of saving customer orders directly from Shopify to Google Sheets.

Once on the site, click on “Sign Up Free” to create your account. You can begin with 100 free tasks each month, allowing you to set up your integration without any initial cost.

2. Connecting Shopify to Pabbly Connect

Next, you need to connect your Shopify store to Pabbly Connect. Start by copying the webhook URL provided by Pabbly Connect. This URL is crucial for capturing order data from Shopify.

Log into your Shopify account and navigate to Settings, then Notifications. Here, you will find the Webhooks section. Follow these steps to set up your webhook:

Click on “Create Webhook”.
Select “Order Creation” as the event.
Paste the copied webhook URL into the URL field.
Choose “JSON” as the format.
Save the webhook.

After saving, your Shopify store is now linked to Pabbly Connect, and it will send order data to the webhook whenever a new order is placed.

3. Setting Up Google Sheets to Receive Data

Now, let’s configure Google Sheets to receive the order data through Pabbly Connect. First, create a new spreadsheet where you want to store the customer details.

In Pabbly Connect, set up a new action step to connect to Google Sheets. Log in using your Google account and grant the necessary permissions. Then, follow these steps to add a new row:

Select the spreadsheet you created earlier.
Choose the worksheet where you want to add the data.
Map the fields from Shopify to the corresponding columns in Google Sheets.

By mapping the fields, every new order will automatically populate the spreadsheet with customer information, including their name, email, and order details.

4. Testing the Integration Between Shopify and Google Sheets

To ensure everything is working correctly, you need to test the integration set up with Pabbly Connect. Place a test order in your Shopify store.

Once the order is placed, check Pabbly Connect for the webhook response. You should see the order details captured from Shopify. Next, check your Google Sheets to confirm that the new order data has been recorded accurately. This will include:

Customer Name
Email Address
Order Amount
Address Details

If all data appears correctly, your integration is successful! Now every new order from Shopify will automatically be recorded in Google Sheets through Pabbly Connect.

5. Conclusion: Automate Your Workflow with Pabbly Connect

In this tutorial, we explored how to use Pabbly Connect to automate the process of saving Shopify orders to Google Sheets. This integration ensures that you never miss a customer detail again.

By leveraging Pabbly Connect, you can streamline your order management and focus on growing your business, especially with the upcoming Black Friday sales. Start automating today!