Integrate BigCommerce Orders with Google Sheets Using Pabbly Connect

Learn how to automate adding multi-product BigCommerce order details to Google Sheets using Pabbly Connect. Follow our step-by-step guide for seamless integration. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To integrate BigCommerce with Google Sheets, we will use Pabbly Connect. Start by visiting the Pabbly Connect website and signing up for a free account if you don’t have one. This platform allows you to automate tasks between different applications seamlessly.

Once logged in, you will see options for various applications. Click on the ‘Access Now’ button under Pabbly Connect to enter the dashboard. Here, you can manage all your workflows and create new integrations.

2. Create a New Workflow in Pabbly Connect

In Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create Workflow’ button. You will be prompted to name your workflow, which should reflect your objective, such as ‘Add Multi-Product BigCommerce Order Details to Google Sheets’. using Pabbly Connect

• Name your workflow to match your goal.
• Select a folder to save your workflow.
• Click on ‘Create’ to proceed.

With the workflow created, you will see two main sections: Trigger and Action. The trigger will initiate the workflow when a new order is created in BigCommerce, and the action will define what happens next.

3. Set Up Trigger for BigCommerce New Order

Now, select BigCommerce as your trigger application in Pabbly Connect. The trigger event you need to choose is ‘New Order Created’. This will ensure that every time a new order is placed, the workflow is activated. using Pabbly Connect

To connect your BigCommerce account, click on ‘Connect’ and then ‘Add New Connection’. You will need to provide the Client ID, Access Token, and Store Hash Key from your BigCommerce account. These details can be found in the API settings of your BigCommerce account.

• Navigate to BigCommerce settings and find API settings.
• Create a new API account and set the required scopes.
• Copy and paste the Client ID, Access Token, and Store Hash Key into Pabbly Connect.

Once all details are filled, click on ‘Save’ to establish the connection. Pabbly Connect will then wait for a response from BigCommerce to confirm the setup.

4. Retrieve Product Details from BigCommerce

After successfully setting up the trigger, the next step is to retrieve product details using the order ID from the new order created. Add another action step in your workflow and select BigCommerce as the action application. using Pabbly Connect

The action event should be ‘Get Product by Order ID’. This will allow you to pull the necessary product information associated with the order. Once selected, ensure to map the order ID received from the trigger step to fetch the correct product details.

Select the action event ‘Get Product by Order ID’. Map the order ID from the trigger response. Click on ‘Save’ to execute the action.

Next, add another action step to retrieve the order details by selecting ‘Get Order by ID’ as the action event. This will provide you with comprehensive order information, including customer details and order totals.

5. Format and Send Data to Google Sheets

With the order and product details retrieved, the next task is to format this data for Google Sheets. Use Pabbly Connect’s Data Transformer tool to convert the line items into a comma-separated format. This step is crucial for structuring the data correctly before sending it to Google Sheets. using Pabbly Connect

After formatting, add a final action step to connect Google Sheets. Choose the action event ‘Add New Row’ to insert the order data into your Google Sheet. Map all necessary fields such as customer name, order ID, email, quantity, product names, unit prices, and total amount from the previous steps into the corresponding columns in your Google Sheet.

Select Google Sheets as the action application. Choose ‘Add New Row’ as the action event. Map all relevant fields to the Google Sheets columns.

After mapping all fields, click ‘Save and Send Test Request’ to check if the data is correctly added to your Google Sheet. Once confirmed, your integration is complete and functioning as intended.

Conclusion

In this tutorial, we demonstrated how to integrate BigCommerce with Google Sheets using Pabbly Connect. By following these steps, you can automate the process of adding multi-product order details seamlessly into your Google Sheet.

This integration not only saves time but also ensures accurate data management for your e-commerce operations. Start using Pabbly Connect today to enhance your workflow efficiency!