Do you ever think about if there is any way through which you can add cancelled Shopify orders to Google Sheets rows automatically?

How to Add Cancelled Shopify Orders to Google Sheets Rows

Well, you don’t have to be surprised to know that there is a way through which you can add cancelled Shopify orders to Google Sheets rows automatically for the record-keeping purposes, without investing a lot of time. We have a magic tool for all your projects called Pabbly Connect. This software allows you to integrate two or more than two applications to automate the entire workflow without any coding skills.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect offers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect 

As we all know, Shopify is an e-commerce platform that offers you to create a website and use their shopping cart solution to sell, ship, and manage your products. On the other hand, Google Sheets is an online spreadsheet app that lets users create and format spreadsheets and simultaneously work with other people.

By setting up this workflow, the info in Google Sheets will be automatically updated whenever someone cancels an order in Shopify. We have also attached a video tutorial for this integration, have a look at it-

Moreover, if you want to save some time in making this automation from scratch, we have attached a template for the same. Just click on the below image to get started quickly and in case you are looking for more apps/integrations, simply visit the Marketplace.

How

Hence, without taking any more of your time, let’s follow the step by step procedure to integrate Shopify and Google Sheets.

How to Add Cancelled Shopify Orders to Google Sheets Rows (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create Workflow

4. Setting Trigger

5. Connecting to Shopify

6. Cancel an Order

7. Test the Response

8. Setting Action

9. Connecting to Google Sheets

10. Check Response

Step 1: Sign up to Pabbly Connect

Sign Up

We will begin the process to add cancelled Shopify orders to Google Sheets rows by clicking on the “Sign Up Free” icon on the Pabbly Connect home page. Next, either manually fill-up all the details or sign up using your Gmail account.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Next, after logging into the account, click on the “Access Now” button of the Connect section in the dashboard.

Step 3: Workflow for Shopify with Google Sheets Integration

(a) Start with a New Workflow

Create New Workflow

Start with creating a workflow for your project by clicking on the ‘Create Workflow’ button.

(b) Name the Workflow

Name the Workflow

Now, you need to name the workflow just like in the above-shown image. I named the workflow “Shopify to Google Sheets”, you can obviously name the workflow as per your requirements.

Step 4: Setting Trigger for Shopify with Google Sheets Integration

As soon as you are done with naming your workflow, you will have to select the application you want to integrate. Pabbly Connect allows you to integrate unlimited premium applications, create your free account now.

(a) Select Application you Want to Integrate

Select Shopify

Now, you have to select the application that you want to integrate. In this case, we are choosing “Shopify” for integration. In the method section, select “Order Cancelled”.

(b) Copy the Webhook URL

Copy the Webhook URL

After selecting the application, now you have to copy the webhook URL just like in the above-shown image to take further the integration process.

Step 5: Connecting Shopify to Pabbly Connect

To connect Shopify with Pabbly Connect, you have to paste the copied webhook URL in the software. For that, you have to log in to your Shopify account.

(a) Click on Shopify Settings

Click-on-Settings Shopify

After logging into your Shopify account, click on the “Settings” option given at the bottom of the screen.

(b) Click on Notifications

How

Next, you need to click on the “Notifications” option given among several other options.

(c) Click on Create Webhook

How

Now, just scroll down and then click on the “Create Webhook” button to paste the copied webhook URL.

(d) Paste the Webhook URL

Paste the Webhook URL

A dialogue box will appear on your screen, here select “Order Cancellation” in the event section and then paste the copied webhook URL. After making all the changes click on the “Save Webhook” button.

Step 6: Cancel an Order

To check this integration, we will capture the data from Shopify, and for that, we will cancel an order on Shopify.

(a) Click on Profile Icon

Click on Profile Icon Shopify

To cancel an order, click on the “Profile” icon in your Shopify dashboard.

(b) Select an Order

Click on Cancel Shopify

After landing on the “My Account” page, select any of the paid orders and then click on the “Cancel” option.

(c) Cancel Order

Cancel Order Shopify

Now, after reaching the cancellation page hit the “Cancel Order” button. Before clicking the button, click on the “Capture Webhook Response” button in Pabbly Connect to capture the data.

Step 7: Test the Response in Pabbly Connect Dashboard

Save the Webhook Response

Once you click on the “Cancel Order” in Shopify, the order info will appear on the Pabbly Connect dashboard. Then, click on the “Save” option.

Step 8: Setting Action for Shopify with Google Sheets Integration

To make this Shopify-Google Sheets integration work, you have to choose an action for your trigger.

(a) Select Application you Want to Integrate

Select Google Sheets

Now in this step, click on the + button below and choose the application that you want to integrate. Here we will choose “Google Sheets” and in the method section select “Add New Row”.

(b) Click the Connect Button

Connect with Google Sheets

After choosing the application click on the “Connect with Google Sheets” button to move forward.

Step 9: Connecting Google Sheets to Pabbly Connect

To connect Google Sheets with Pabbly Connect, you have to authorize the application. For this, you have to log into your Google account.

(a) Authorize Application

Authorize Application Google Sheets

Next, to authorize Google Sheets, a window will slide in from the right, here you need to again click on the “Connect with Google Sheets” button and then allow the permission to connect Google account with Pabbly Connect.

(b) Map the Fields

Map the Fields

After connecting with your Google account, map all the fields quickly like spreadsheet, email, etc.

(c) Save and Send Test Request

Send Test Request

Once you are done adding up all field data click on the “Save & Send Test Request” button.

Step 10: Check Response in Google Sheets

Check Response

Finally, when you check your Google Sheets, you can see that the info is updated automatically for the cancelled order in Shopify.

Conclusion –

Good job my friend! Now that you have learned “How to Add Cancelled Shopify Orders to Google Sheets Rows”, you can integrate any applications via Pabbly Connect to automate your entire workflow without any coding skills. Pabbly Connect is the magic wand that you can use to computerise your projects and save a lot of time and effort.

Therefore, signup for a free account now for the best integration experience. In case of any doubts or suggestions, please leave your comments below.

You May Also Like To Read –