Automatically Create New Ecwid Products from Google Sheets Using Pabbly Connect

Learn how to automatically create new Ecwid products from Google Sheets using Pabbly Connect. Follow this detailed tutorial for a seamless integration process. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Sheets Integration

To begin the process of creating new Ecwid products from Google Sheets automatically, we will utilize Pabbly Connect. First, go to the Pabbly website by typing ‘Pabbly.com’ in your browser. It is advisable to use incognito mode to avoid authentication issues with multiple Gmail accounts.

Once on the Pabbly homepage, click on ‘Sign Up for Free’ to create your account. After signing in, navigate to the app section and select Pabbly Connect. Click on ‘Access Now’ to enter the integration setup.

2. Creating a New Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the ‘Create Workflow’ button located at the top right corner. A dialog box will prompt you to name your workflow. Enter a relevant name, such as ‘Google Sheets to Ecwid,’ and click on ‘Create’.

This will open two windows: the trigger and action windows. For the trigger, select ‘Google Sheets’ and then choose ‘New Spreadsheet Row’ as the trigger event. This setup allows Pabbly Connect to monitor your Google Sheets for new entries.

3. Setting Up Google Sheets for Product Data

Next, you need to prepare your Google Sheet. Create a new blank spreadsheet and set up the following columns: Product Name, Description, Sale Price, Compare Price, Quantity, and Warning Quantity. This structure is essential for Pabbly Connect to capture the necessary product details.

Once your sheet is ready, head to the ‘Add-ons’ menu in Google Sheets, and install the Pabbly Connect Webhooks add-on. After installation, refresh your Google Sheet. Then, go to the initial setup of the Webhooks add-on, where you will paste the Webhook URL provided by Pabbly Connect.

• Copy the Webhook URL from Pabbly Connect.
• Paste it into the Webhook URL field in Google Sheets.
• Set the trigger column to the last data entry column (e.g., Column F).

After setting this up, ensure to click ‘Submit’ to save your settings. This configuration allows Pabbly Connect to receive data whenever a new row is added in Google Sheets.

4. Creating Products in Ecwid from Google Sheets

With your Google Sheet ready and Pabbly Connect configured, now you can create products in Ecwid. In the action window of Pabbly Connect, select ‘Ecwid’ as the app and then choose ‘Create a Product’ as the action event.

Connect your Ecwid account by clicking on ‘Connect with Ecwid’. After successful authorization, you will see fields to fill in product details. Map the fields from Google Sheets to the corresponding Ecwid product fields, such as Product Name, Sale Price, Compare Price, and Quantity.

• Enter the product name from Google Sheets.
• Fill in the sale price, compare price, and quantity.
• Set the warning limit as needed.

Once all fields are mapped, click on ‘Save and Send Test Request’ to create the product in Ecwid. After a successful response, check your Ecwid account to confirm that the product has been created.

5. Conclusion: Automate Your Product Creation with Pabbly Connect

In this tutorial, we demonstrated how to use Pabbly Connect to automatically create new Ecwid products from Google Sheets. By setting up a simple workflow, you can streamline your product management process and save time.

With this integration, every new row added in Google Sheets will trigger the creation of a product in Ecwid, allowing for efficient inventory management. Start using Pabbly Connect today to automate your workflows and enhance your business operations.