How to Capture Orders from BigCommerce to Google Sheets Automatically Using Pabbly Connect

Learn how to automatically capture orders from BigCommerce to Google Sheets using Pabbly Connect with this step-by-step tutorial. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin capturing orders from BigCommerce to Google Sheets automatically, you first need to access Pabbly Connect. Open your browser and navigate to the Pabbly Connect landing page by typing Pabbly.com/connect.

Once on the landing page, you have the option to sign in if you’re an existing user or sign up for free. New users can enjoy 100 free tasks every month, which is a great way to explore the features of Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

After signing in, you will be directed to your Pabbly Connect dashboard. Here, click on the ‘Create Workflow’ button to start building your automation. You will be prompted to choose between the new workflow builder or the classic one. For this tutorial, select the new workflow builder for a faster experience. using Pabbly Connect

• Click on ‘Create Workflow’.
• Enter a name for your workflow, such as ‘Capture Orders from BigCommerce to Google Sheets Automatically’.
• Select a folder to save your workflow.

After naming your workflow, click on the ‘Create’ button. This will open the workflow window where you can set up triggers and actions, which are essential for the automation to function correctly.

3. Setting Up the Trigger for New Orders

The next step in using Pabbly Connect is to set up the trigger. Click on ‘Add Trigger’ and select BigCommerce as the trigger application. For the trigger event, choose ‘New Order Created’. This tells Pabbly Connect to initiate the workflow whenever a new order is placed in BigCommerce.

To establish a connection, you can either select an existing connection or create a new one. If you choose to create a new connection, you will need to provide your BigCommerce API credentials, including the store hash key, client ID, and access token. Make sure to follow the prompts to enter these details accurately.

4. Adding Action Steps to Capture Order Details

Once the trigger is set, the next step is to add an action to retrieve the order details. Click on ‘Add New Action Step’ and select BigCommerce again. For the action event, choose ‘Get Order by ID’. This step is crucial as it allows Pabbly Connect to fetch the specific details of the order placed.

• Use the order ID from the trigger step to dynamically fetch order details.
• Map the necessary fields such as customer name, email, address, and order total.

After mapping the fields, click on ‘Save and Send Test Request’ to ensure that Pabbly Connect correctly retrieves the order details. This will confirm that your setup is functioning as intended.

5. Finalizing Integration with Google Sheets

Now that you have the order details, the final action is to send this information to Google Sheets. Click on ‘Add New Action Step’ and select Google Sheets as the action application. Choose the action event ‘Add New Row’. This will allow Pabbly Connect to automatically add the order information into your specified Google Sheet.

Connect your Google Sheets account by signing in with your Google credentials. Once connected, select the spreadsheet and worksheet where you want to store the order details. Map the fields from the previous step to the corresponding columns in your Google Sheet.

After completing the mapping, click on ‘Save and Send Test Request’ to verify that the order details are correctly added to Google Sheets. If successful, you will see the new order details appear in your specified sheet.

Conclusion

By following this tutorial, you have successfully set up an automation to capture orders from BigCommerce to Google Sheets automatically using Pabbly Connect. This integration streamlines your order management process and ensures that your data is organized in real time. Start using Pabbly Connect today to enhance your business operations!