Have you ever thought about a way through which you can add Google Sheets rows from BigCommerce order automatically?
Well, don’t be surprised, as we have found a way through which you can add Google Sheets rows from BigCommerce order automatically. We have a magic tool for all your projects called Pabbly Connect. This software allows you to integrate two or more two applications to automate the entire mechanism 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
Before getting started, let’s know a little bit about both software. Primarily, BigCommerce is an eCommerce platform that lets users 100’s of features, secure hosting, advanced SEO, and fantastic multi-channel integration. On the other hand, Google Sheets is an online spreadsheet app that lets users create and format spreadsheets and simultaneously work with other people.
Using Pabbly Connect, whenever new order will be created in BigCommerce, the order info will be saved in Google Sheets automatically. We have also embedded a video tutorial for this integration, have a look at it-
Pabbly Connect allows you to integrate unlimited premium applications without any coding skills. Just integrate it once & relax, it will handle all the workload later. Additionally, you can access all the features even in its free plan.
Furthermore, we have a template for this integration that can assist you to begin your integration journey in no time. Simply go to Marketplace and look for the apps you use to start integration. Just tap on the image below to get started.
So, without taking any more of your time, let’s follow the step by step procedure to integrate BigCommerce and Google Sheets.
Step 1: Sign up to Pabbly Connect
Start the process to add new Google Sheets rows from the new BigCommerce order by clicking on the “Sign Up Free” icon on the Pabbly Connect home page. You can either manually fill-up all the details or sign up using your Gmail account.
Try Pabbly Connect for FREE
Next, after logging into the account, click on the “Access Now” button of the Connect section in the dashboard. Start with creating a workflow for your project by clicking on the ‘Create Workflow’ button. Now, you need to name the workflow just like in the above-shown image. I named the workflow “BigCommerce to Google Sheets”, you can obviously name the workflow as per your requirements. As soon as you are done 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. Now, you have to select the application that you want to integrate. In this case, we are choosing “BigCommerce” for integration. In the method section, select “New Order Created”. After selecting the application, you have to click on the “Connect with BigCommerce” button just like in the above-shown image to take further the integration process. Next, to connect BigCommerce with Pabbly Connect, you have to authorize the application. For that, you have to log in to your BigCommerce account. First of all, go to the Bigcommece dashboard and click on “Advanced Settings”. Now, click on the “API Accounts” to proceed further. Next, press the button named “Create API Account” and then choose the option “Create V2/V3 API Token”. Furthermore, copy the API Path highlighted in the image and then click on the “Save” button to proceed further. As soon as you click on the “Save” button, a window will pop-up with API keys. Just copy the “Client ID and Access Token” then click on the “Done” button. Now, simply paste the respective API keys and tokens in the mentioned columns. Then press the “Save” button. Now, in order to check this integration, we will capture the data from BigCommerce, and for that, we will create a dummy order in BigCommerce. After adding the webhook URL to your BigCommerce account, now we will click on the “Capture Webhook Response” button to capture the data from BigCommerce. In order to add a new order, simply go to Bigcommerce account and make a dummy purchase. Once you are done placing the order in BigCommerce, the order info will appear on the Pabbly Connect dashboard. Then, click on the “Save” button. To make this BigCommerce-Google Sheets integration work, you have to choose two actions for your trigger. First, BigCommerce to get the proper order info from the order ID that we got in the trigger part. Second, Google Sheets to update the info in the sheet. Now in this step, click on the + button below and choose the application that you want to integrate. Here we will choose “BigCommerce” and in the method section select “Get Order By Id”. After choosing the application click on the “Connect with BigCommerce” button. Now, choose the previously used credentials to move forward. Now, after connecting with your BigCommerce account, map the “Order ID” and then hit the “Save & Send Test Request” button. Here, we can see that all the information about the new order is captured within Pabbly Connect. Hit the “Save” button to move forward. 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”. After choosing the application click on the “Connect with Google Sheets” button to move forward. Later, to connect Google Sheets with Pabbly Connect, you have to authorize the application. For this, you have to log into your Google account. 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. After connecting with your Google account, map all the fields quickly like spreadsheet, name, etc. Once you are done adding up all field data click on the “Save & Send Test Request” button. Finally, when you check your Google Sheets, you can see that the info is updated automatically for the newly created order in BigCommerce. Well Done! Now that you have learned “How to Add New Google Sheets Rows from New BigCommerce Order”, you can integrate any applications via Pabbly Connect to automate your entire workflow without any coding skills. Pabbly Connect is a wonderful tool that you can use to automate your projects and save a lot of time and effort. So what are you waiting for? Go signup for a free account now for the best automation & integration experience.Step 2: Access Pabbly Connect
Step 3: Workflow for BigCommerce to Google Sheets Integration
(a) Start with a New Workflow
(b) Name the Workflow
Step 4: Setting Trigger for BigCommerce to Google Sheets Integration
(a) Select Application you Want to Integrate
(b) Click Connect Button
Step 5: Connecting BigCommerce to Pabbly Connect
(a) Go to Advanced Settings
(b) Click on API Accounts
(c) Create API Account
(d) Copy the API Path Key
(e) Copy the Client ID and Access Token
(f) Paste the API Keys
Step 6: Place a Dummy Order
(a) Capture Webhook Response
(b) Make a Dummy Purchase
Step 7: Test the Response in Pabbly Connect Dashboard
Step 8: Setting Actions for BigCommerce to Google Sheets Integration
(a) Select Application you Want to Integrate
(b) Authorize Application
(c) Save & Send Test Request
(e) Save the API Response
(f) Select Application you Want to Integrate
(g) Click the Connect Button
Step 9: Connecting Google Sheets to Pabbly Connect
(a) Authorize Application
(b) Map the Fields
(c) Save and Send Test Request
Step 10: Check Response in Google Sheets
Conclusion –
You May Also Like To Read –
