Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To begin integrating Shopify with Google Sheets, you need to access Pabbly Connect. Open your browser and navigate to pabbly.com/connect. This will take you to the Pabbly Connect homepage.

Once there, you will see options to sign in or sign up. If you are a new user, click on “Sign up for free” to get started with 100 free tasks each month. Existing users can simply sign in. After signing in, click on “Access Now” to enter the Pabbly Connect dashboard.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a workflow. Click on the “Create from scratch” option to start building your automation. This allows you to set up the connection between Shopify and Google Sheets efficiently.

  • Select “Create from scratch” to begin your workflow.
  • Describe your workflow: “When I receive a new order on Shopify, add it to Google Sheets.”
  • Choose the trigger: Select “New Order” from Shopify as the event.
  • Set the action: Choose “Add a new row” in Google Sheets.

Once you have set these parameters, click on “Approve and Create” to finalize your workflow setup. You will receive a unique workflow link for future reference.

3. Setting Up the Trigger in Pabbly Connect

The next step in using Pabbly Connect is to set up the trigger that will initiate the automation. You will receive a webhook URL that you need to connect to your Shopify account.

To do this, log into your Shopify account and navigate to the “Settings” section. From there, select “Notifications” and scroll down to the “Webhooks” section. Click on “Create Webhook” and fill in the required details:

  • Select “Order Creation” as your event.
  • Choose “JSON” as the format.
  • Paste the webhook URL from Pabbly Connect.
  • Select the latest API version and click “Save”.

Once the webhook is set up, Pabbly Connect will be ready to receive data from Shopify every time a new order is placed.

4. Mapping Data to Google Sheets

Now that the trigger is set, the next step is to map the data from Shopify to Google Sheets using Pabbly Connect. This involves linking the information received from Shopify to the corresponding fields in your Google Sheets document.

To do this, you will need to connect your Google account in Pabbly Connect. Click on “Sign in with Google” and select your account. After granting access, choose the appropriate spreadsheet and sheet from the dropdown menu.

  • Select the spreadsheet named “New Shopify Orders”.
  • Choose “Sheet1” for the sheet to map the data.
  • Map the fields: customer name, email, contact number, item purchased, and amount.

Once the data is mapped correctly, click on “Save and Send Request” to confirm that the data is being sent to Google Sheets successfully. You should see the new order details reflected in your Google Sheets.

5. Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of adding new Shopify orders directly to Google Sheets. By following these steps, you can streamline your order management.

With Pabbly Connect, you can enhance your business automation and ensure that your data is organized and easily accessible. This integration allows for real-time updates, saving you time and effort in manual data entry.

By implementing this automation, you can focus on growing your business while Pabbly Connect handles the repetitive tasks for you.