How to Add Orders from BigCommerce to Google Sheets Using Pabbly Connect

Learn how to automatically add orders from BigCommerce to Google Sheets using Pabbly Connect for efficient order tracking and management. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start the integration process, you need to access Pabbly Connect. Begin by opening your web browser and searching for ‘Pabbly.com/connect’. This will take you to the Pabbly Connect landing page.

Once on the landing page, you have two options: sign in or sign up for free. If you are a new user, click on ‘Sign up for free’ to create an account. As an existing user, click on ‘Sign in’ to access your dashboard. From here, you can create a new workflow that connects BigCommerce with Google Sheets.

2. Creating a New Workflow in Pabbly Connect

After signing in, you will be directed to your Pabbly Connect dashboard. To create a new workflow, simply click on the ‘Create Workflow’ button. You will be prompted to choose between the new workflow builder or the classic one. Select the new workflow builder for a more modern interface. using Pabbly Connect

Next, you need to name your workflow. Enter a descriptive name, such as ‘BigCommerce to Google Sheets Orders’. You can also select a folder to save your workflow. If you need to create a new folder, click on the ‘Create New Folder’ button. Once everything is set, click on ‘Create’ to proceed.

3. Setting Up Triggers with BigCommerce

In this section, you will set up the trigger for your workflow. The trigger is essential as it initiates the workflow when a new order is placed in BigCommerce. Click on the ‘Add Trigger’ button and select BigCommerce as your trigger application. using Pabbly Connect

For the trigger event, choose ‘New Order Created’ and click on ‘Connect’. You will need to establish a connection to your BigCommerce account by providing the store hash key, client ID, and access token. This information can be found in your BigCommerce account settings under API accounts. Make sure to grant all necessary permissions for Pabbly Connect to access your order data.

• Navigate to BigCommerce settings and locate API accounts.
• Create a new API account and select V2/V3 API token.
• Copy the store hash key from the API path.

Once you have successfully connected your BigCommerce account, click on ‘Save and Send Test Request’. This will wait for a webhook response, so you need to place a test order to capture the data.

4. Adding Order Details to Google Sheets

After successfully capturing the order data from BigCommerce, the next step is to add these details to Google Sheets. Click on ‘Add New Action Step’ and select Google Sheets as the action application. Then, choose ‘Add New Row’ for the action event. using Pabbly Connect

You will need to connect your Google Sheets account. Click on ‘Add a New Connection’ and sign in with your Google account. Grant all necessary permissions for Pabbly Connect to access your Google Sheets. Once connected, select the spreadsheet where you want to add the order details.

• Select the spreadsheet named ‘BigCommerce Order Details’.
• Choose the specific sheet where the data will be added.
• Map the order ID, email, address, and other relevant details.

After mapping all required fields, click on ‘Save and Send Test Request’ to ensure the data is correctly added to your Google Sheets. Check your Google Sheets to verify that the details have been successfully entered.

5. Testing the Workflow for Real-Time Functionality

Now that your workflow is set up, it’s time to test it for real-time functionality. Place a new test order in your BigCommerce store. This will trigger the workflow you configured in Pabbly Connect. After placing the order, check your Google Sheets to see if the new order details have been added automatically.

Once you confirm that the data appears correctly in your Google Sheets, your integration is complete. You can now rely on Pabbly Connect to automatically add new orders from BigCommerce to Google Sheets without any manual effort. This automation will save you time and improve your order tracking efficiency.

For future orders, the workflow will trigger automatically, ensuring that your Google Sheets are always up-to-date with the latest order information.

Conclusion

Integrating BigCommerce with Google Sheets through Pabbly Connect allows for seamless order management and tracking. By following these steps, you can automate the process and enhance your e-commerce operations efficiently.