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

Create a Live Shopify Dashboard in Google Sheets

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To integrate Shopify with Google Sheets, start by accessing Pabbly Connect. Open your browser and go to the Pabbly Connect website. If you are a new user, click on the “Sign Up for Free” button in the top right corner to create an account.

Once you have signed up, you can start using Pabbly Connect. Existing users can directly log in to their accounts. After logging in, you will be directed to the workflow builder where you can create your automation.

2. Creating a New Workflow in Pabbly Connect

Next, you need to create a new workflow in Pabbly Connect. Click on the “Add Trigger” button to begin. In the trigger application, search for “Shopify V2” and select it.

Select the event as “New Order”.
Click on “Connect” to generate a webhook URL.
Copy the webhook URL for later use.

After setting up the trigger, you will need to configure your Shopify store. Go to the settings in your Shopify account, navigate to “Notifications”, and then to “Webhooks”. Click on the “Create Webhook” button and select “Order Creation” from the event options. Paste the copied webhook URL into the URL field, select JSON for the format, and save the changes.

3. Capturing Order Details from Shopify

Now that you have set up the webhook, Pabbly Connect will wait for the webhook response. To capture this response, make a test purchase from your Shopify store. This will trigger the webhook and send order details to Pabbly Connect.

Once the order is placed, return to your Pabbly Connect workflow. You should see the order details captured successfully, including the customer’s name, address, and product purchased. This confirms that the integration is working correctly.

4. Adding Google Sheets as an Action Step

Next, you will add Google Sheets as an action step in your workflow. Click on “Add New Action Step” and select “Google Sheets” as the action application. Choose the event as “Add New Row” and click on “Connect”.

If you have an existing connection, select it.
If not, click on “Add New Connection” and sign in with your Google account.
Grant necessary permissions to Pabbly Connect.

After establishing the connection, you need to select the specific spreadsheet and sheet where the order details will be added. You can map the relevant fields from the Shopify order details to the columns in your Google Sheets document.

5. Mapping Order Details in Google Sheets

Mapping is a crucial step in using Pabbly Connect effectively. It allows you to insert data dynamically from the previous steps into your Google Sheets. To map the data, enter a slash and search for the details you wish to add, such as product name, quantity, and total amount.

For each field, ensure you map the correct data from the Shopify order. Once you have mapped all the necessary fields, click on the “Save and Send Test Request” button. This will send the order details to your Google Sheets, confirming that the integration is complete.

In conclusion, integrating Shopify with Google Sheets using Pabbly Connect streamlines your order management process. By following these steps, you can automate the workflow and easily manage your orders in real-time, enhancing your business efficiency.