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

Learn how to automate adding products in WooCommerce from Google Sheets using Pabbly Connect. This step-by-step guide covers scheduling and integration methods. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin adding products in WooCommerce from Google Sheets using Pabbly Connect, start by navigating to the Pabbly Connect website. Sign in with your existing account or create a new one if you’re a first-time user. Once logged in, access the dashboard to begin creating your workflow.

On the dashboard, click on the ‘Create Workflow’ button. This will prompt you to name your workflow. For this integration, name it ‘Add Product in WooCommerce from Google Sheets in Bulk at Scheduled Time’. Click on ‘Create’ to proceed to the workflow setup.

2. Setting Up a Scheduled Trigger in Pabbly Connect

In this section, you will set up a scheduled trigger using Pabbly Connect. Select the ‘Schedule’ option as your trigger event. This will allow your workflow to run at specified intervals, such as daily or hourly.

To configure the schedule, choose how often you want the workflow to run. For example, select ‘Every Day’ and set the time to 10:00 AM. After configuring these settings, click on ‘Save’ to activate the trigger. The workflow is now set to check Google Sheets for new products at the scheduled time.

3. Configuring Google Sheets Action in Pabbly Connect

Next, you will configure the action to retrieve product details from Google Sheets using Pabbly Connect. Select Google Sheets as your action application and choose the event ‘Lookup Spreadsheet Rows’. This action will fetch the data from your specified Google Sheet.

Connect your Google Sheets account by clicking on ‘Add New Connection’. Follow the prompts to authorize Pabbly Connect to access your Google Sheets. Once connected, specify the name of your spreadsheet and the sheet name where your product data is stored. Set the lookup column to the status column (e.g., column H) and the lookup value to ‘ready’. Click ‘Save & Send Test Request’ to test the connection.

• Select the spreadsheet containing your product details.
• Set the lookup column to identify products that are ready for addition.
• Test the connection to ensure data is being retrieved correctly.

After testing, you will receive a response containing the product details that are ready to be added to WooCommerce.

4. Adding Products to WooCommerce Using Pabbly Connect

Now that you have retrieved the product details, the next step is to add these products to WooCommerce through Pabbly Connect. Select WooCommerce as your action application and choose the action event ‘Create a Product’. This will allow you to add the products fetched from Google Sheets into your WooCommerce store.

Connect your WooCommerce account by clicking on ‘Add New Connection’. You will need to enter the Consumer Key, Consumer Secret, and the website URL from your WooCommerce settings. After entering this information, click ‘Save’ to complete the connection. Map the product details from Google Sheets to the corresponding fields in WooCommerce, such as product name, SKU, and price.

• Map product name, SKU, and price fields correctly.
• Set the product status to publish to make it live immediately.
• Save & Send Test Request to verify product creation.

Once the test is successful, you can check your WooCommerce products list to confirm that the new products have been added successfully.

5. Updating Product Status in Google Sheets

After successfully adding products to WooCommerce, the final step is to update the product status in Google Sheets using Pabbly Connect. Add another action step and select Google Sheets, then choose the action event ‘Update Cell Value’. This will allow you to change the status of products that have been added.

Connect to your Google Sheets account again, and specify the spreadsheet and the range where the status needs to be updated. For example, set the column name to H and the row index to the corresponding product row. Set the value to ‘published’ to reflect the new status. Click ‘Save & Send Test Request’ to execute the update.

Ensure the correct row index is mapped for the product status update. Change the value to ‘published’ to update the status in Google Sheets. Confirm the update by checking Google Sheets after execution.

This completes the integration process. Now, every time a product is marked as ready in your Google Sheet, it will automatically be added to WooCommerce, and the status will be updated accordingly.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate adding products in WooCommerce from Google Sheets at scheduled times. By following the steps outlined, you can efficiently manage your product listings without manual intervention. Automate your workflow today with Pabbly Connect for seamless integration!