Integrating BigCommerce Orders with Google Sheets Using Pabbly Connect

Learn how to integrate BigCommerce multi-product order details into Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for seamless automation. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Integration

To begin integrating BigCommerce with Google Sheets, first access Pabbly Connect. Open your browser and navigate to the Pabbly website. If you don’t have an account, sign up for free to access hundreds of tasks monthly.

Once logged in, click on the ‘Access Now’ button under Pabbly Connect to reach the dashboard. Here, you can create workflows that automate your tasks. Start by clicking on the ‘Create Workflow’ button and name your workflow, such as ‘Add Multi-Product BigCommerce Order Details to Google Sheets’.

Setting Up the Trigger with BigCommerce

In the workflow, the first step is to set up a trigger. For this integration, select BigCommerce as the trigger application in Pabbly Connect. Choose the ‘New Order Created’ event as your trigger. This means that every time a new order is placed, the workflow will initiate.

Next, connect your BigCommerce account by clicking on ‘Connect’ and selecting ‘Add New Connection’. You will need to provide the Client ID, Access Token, and Store Hash Key from your BigCommerce account. To find these, navigate to your BigCommerce settings, access API settings, and create a new API account with the necessary scopes.

• Client ID
• Access Token
• Store Hash Key

After entering these details into Pabbly Connect, click ‘Save’. This establishes the connection and sets up the trigger to capture new orders automatically.

Getting Order and Product Details

With the trigger set, the next step is to retrieve the order details using the order ID. Add an action step in Pabbly Connect and select BigCommerce again as the application. Choose the action event ‘Get Product by Order ID’. This allows you to fetch the details of products associated with the newly created order.

Map the Order ID from the previous trigger response to this action. After saving the configuration, you will receive a response containing all product details in an array format. To separate these details, you will need to transform the data using the Pabbly Connect Data Transformer tool.

• Select ‘Add Action Tab’
• Choose ‘Data Transformer’
• Select ‘Line Itemizer’ as Action Event

This transformation will convert the line items into a format suitable for Google Sheets, preparing your data for the next step.

Formatting Data for Google Sheets

Now that you have the product details transformed, it’s time to format this data for Google Sheets. Use the Text Formatter tool in Pabbly Connect to replace commas with new lines. This ensures that each product detail appears on a separate line in your Google Sheet.

Repeat this process for each relevant field, including product names, quantities, unit prices, and total amounts. For each field, map the data from the previous steps and set the find value as a comma, replacing it with a new line character.

Map Product Names Map Quantities Map Unit Prices Map Total Amounts

After formatting, your data will be ready to be sent to Google Sheets, ensuring clarity and organization in your order details.

Adding Data to Google Sheets

The final step is to send the formatted order details to Google Sheets. In Pabbly Connect, add another action step and select Google Sheets as your application. Choose the action event ‘Add New Row’. This will allow you to insert a new row with the order details into your specified Google Sheet.

Connect your Google account with Pabbly Connect and select the spreadsheet and sheet where you want the data to be added. Map the customer name, order ID, email, quantity, product names, unit prices, and total amount to their respective columns in your Google Sheet.

Map Customer Name Map Order ID Map Email Address Map Quantities and Prices

After mapping all details, click ‘Save and Send Test Request’. This will add the new row to your Google Sheet, confirming that the integration works successfully.

Conclusion

In this tutorial, we have demonstrated how to integrate BigCommerce multi-product order details into Google Sheets using Pabbly Connect. By following these steps, you can automate your order management process efficiently.

This integration not only saves time but also ensures that all order details are organized in one place. With Pabbly Connect, you can streamline your workflow and enhance productivity.