Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start integrating Shopify with Google Sheets, you’ll need to access Pabbly Connect. Begin by visiting pabbly.com and signing in to your account. If you’re a new user, you can sign up for free to explore the features.

After logging in, navigate to the Pabbly Connect dashboard. Here, you will find options to create workflows. Click on the “Create Workflow” button to initiate the integration process.

2. Creating a New Workflow in Pabbly Connect

Once you’re in Pabbly Connect, you can create a new workflow to connect Shopify with Google Sheets. Name your workflow something like “Automatically Add Shopify Orders to Google Sheets”. Select the appropriate folder for better organization.

  • Click on the “Create” button to finalize the workflow setup.
  • You will see a box prompting you to select a trigger application.

In this case, select Shopify as the trigger application and choose “New Order” as the trigger event. This means that whenever a new order is placed on Shopify, it will activate the workflow created in Pabbly Connect.

3. Setting Up Webhook in Shopify

The next step is to connect Shopify with Pabbly Connect using a webhook. After selecting Shopify as the trigger application, you will receive a webhook URL. This URL acts as a bridge between Shopify and Pabbly Connect.

To set this up, go to your Shopify admin panel. Click on “Settings” and then navigate to “Notifications”. Here, find the option for “Webhooks” and click on “Create Webhook”.

  • Select “Order Creation” as the event.
  • Set the format to JSON and paste the webhook URL from Pabbly Connect.

After saving the webhook, you can test it by placing a new order in your Shopify store. This will send the order details to Pabbly Connect, confirming that the connection is successful.

4. Adding Google Sheets as an Action in Pabbly Connect

With the webhook set up, the next step is to add Google Sheets as an action application in Pabbly Connect. Select Google Sheets and choose the action event “Add New Row”. This will allow you to automatically add new order details to your Google Sheets spreadsheet.

Click on “Connect” to link your Google Sheets account. If you don’t have an existing connection, follow the prompts to sign in to your Google account and grant the necessary permissions.

  • Choose the spreadsheet where you want to store the order details.
  • Map the order details from Shopify to the corresponding fields in Google Sheets.

For instance, map the customer’s name, email, phone number, product, and price. This ensures that every new order will automatically populate the spreadsheet without manual input, showcasing the efficiency of Pabbly Connect.

5. Testing the Integration Setup

After setting up the Google Sheets action, it’s time to test the integration. Click on “Save and Send Test Request” in Pabbly Connect. This will send a test order to your Google Sheets to verify that everything works correctly.

Check your Google Sheets to confirm that the order details have been added successfully. You should see the name, email, phone number, product, and price listed in the spreadsheet. This confirms that the integration between Shopify and Google Sheets via Pabbly Connect is functioning as expected.

Once confirmed, you can start using this automated workflow. Now, every time a new order is placed on Shopify, the details will automatically be recorded in your Google Sheets, streamlining your order management process.

Conclusion

This tutorial has guided you through the steps to integrate Shopify with Google Sheets using Pabbly Connect. By following these steps, you can automate order tracking and enhance your business efficiency.