How to Add Products in BigCommerce from Google Sheets Using Pabbly Connect

Learn how to automate adding products to BigCommerce from Google Sheets using Pabbly Connect with this detailed step-by-step tutorial. 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

1. Setting Up Pabbly Connect for Automation

To begin the process of adding products in BigCommerce from Google Sheets, you first need to access Pabbly Connect. This platform allows you to automate workflows seamlessly. Start by signing up for a free account on Pabbly Connect, which will only take a couple of minutes.

Once you are logged in, navigate to the dashboard and click on the option to create a new workflow. Name your workflow appropriately, for example, ‘Google Sheets to BigCommerce’. This will help you identify the workflow later. After naming it, click on the ‘Create’ button to proceed.

2. Configuring the Trigger in Pabbly Connect

In this step, you will set up a trigger in Pabbly Connect to automate the fetching of product details from Google Sheets. Select the ‘Schedule’ module, which allows the workflow to run at specified intervals. You can choose to run this workflow daily, weekly, or at any custom interval that suits your needs.

• Choose the frequency (e.g., every day).
• Set the specific time for the workflow to run, such as 10 AM.

After configuring the schedule, click on the ‘Save’ button. This will ensure that your automation is set to run at the desired times. The next step is to connect to Google Sheets to fetch the necessary product data.

3. Fetching Data from Google Sheets Using Pabbly Connect

Now that you have set up the trigger, it’s time to fetch product details from Google Sheets. In the action step of your workflow, select ‘Google Sheets’ and then choose the action event ‘Lookup Spreadsheet Row’. This will allow Pabbly Connect to find rows in your Google Sheet based on specific criteria. using Pabbly Connect

• Connect your Google Sheets account by signing in through Pabbly Connect.
• Select the spreadsheet that contains your product details.
• Specify the sheet and lookup column (e.g., column H for product status).

Set the lookup value to ‘ready’ to filter products that are ready to be added to BigCommerce. Ensure you include headers in the response to easily identify the data fields. After configuring these settings, click on ‘Save and Send Test Request’ to verify that Pabbly Connect retrieves the correct data.

4. Adding Products to BigCommerce via Pabbly Connect

With the product details fetched from Google Sheets, the next step is to add these products to your BigCommerce store. In the action step, select ‘BigCommerce’ and choose the action event ‘Create Product’. This will allow you to create new products based on the information retrieved from Google Sheets. using Pabbly Connect

Connect your BigCommerce account by entering the required credentials such as Client ID, Access Token, and Store Hash Key. These details can be found in your BigCommerce account settings under API accounts. After connecting, map the product details received from Google Sheets to the corresponding fields in BigCommerce, such as product name, SKU, and price.

Once you have mapped all necessary product information, click on ‘Save and Send Test Request’. Pabbly Connect will attempt to add the product to your BigCommerce account. If successful, you will receive a positive response confirming that the product has been created.

5. Updating Product Status in Google Sheets

The final step in this automation process is to update the status of products in Google Sheets after they have been successfully added to BigCommerce. This prevents the same products from being added multiple times. To do this, add another action step in Pabbly Connect and select ‘Google Sheets’ again, then choose the action event ‘Update Cell’. using Pabbly Connect

In this step, you will need to specify the range of the cell that needs updating. Since the row number will change based on the product being processed, use the row index from the iterator response to dynamically set the correct row. Update the status to ‘published’ to indicate that the product has been added to BigCommerce.

After configuring this step, click on ‘Save and Send Test Request’ to confirm that the status has been updated in your Google Sheet. This completes the automation workflow, allowing you to efficiently manage product listings in BigCommerce using data from Google Sheets.

Conclusion

By leveraging Pabbly Connect, you can automate the process of adding products to BigCommerce from Google Sheets effectively. This integration not only saves time but also ensures that your product listings are always up-to-date. With scheduled automation, you can focus on growing your e-commerce business while Pabbly Connect handles the repetitive tasks.