Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start automating product descriptions for your Shopify store, access Pabbly Connect by visiting pabby.com/connect. Here, you will find options to sign in or sign up for free. Signing up allows you to explore the platform with 100 free tasks, making it ideal for testing your automation setup.

Once you’ve signed up, log into your dashboard. Click on the “Create Workflow” button and select “Create from Scratch.” Name your workflow appropriately, such as “Build a Shopify AI Agent using Gemini,” and select a folder for organization. This is where you’ll set up the integration process.

2. Setting Up Google Sheets with Pabbly Connect

In this step, you will connect Google Sheets to Pabbly Connect to trigger actions based on new or updated rows. Select Google Sheets as your trigger application and choose the event “New or Updated Spreadsheet Row.” Click on the connect button to obtain your webhook URL.

  • Copy the webhook URL provided by Pabbly Connect.
  • Open Google Sheets and navigate to Extensions > Add-ons > Get Add-ons.
  • Search for “Pabbly Connect Webhooks” and install it.

After installation, refresh your spreadsheet. Go back to Extensions > Pabbly Connect Webhooks > Initial Setup. Paste the webhook URL and specify your trigger column, which should be set to column G. Click on the submit button to finalize the setup.

3. Entering Product Details in Google Sheets

Now that Google Sheets is connected to Pabbly Connect, you can enter product details. Input basic information such as product name, category, features, material, unit price, cost price, and sale price. For example, you might enter:
– Name: Oversized Streetwear Hoodie
– Category: Unisex Hoodies
– Features: Trendy oversized fit, warm fleece
– Material: Cotton fleece blend
– Unit Price: $21.99
– Cost Price: $9.50
– Sale Price: $17.99

Upon entering these details, the system will automatically capture the row data and send it to Pabbly Connect. You can check if the trigger captures the response by monitoring the workflow dashboard in Pabbly Connect. If successful, you’ll see the product details reflected in the workflow.

4. Generating SEO-Approved Product Descriptions Using AI

Next, you will add an action step to generate SEO-optimized product descriptions using Gemini AI. Choose “Gemini” as your action application and select the event “Generate Content.” Connect to your existing Gemini account or create a new connection using your API key.

In the prompt field, enter your request, such as: “You are an expert e-commerce copywriter for a premium fashion apparel brand called New U Fashion using the following details.” Map the product details from the previous step into the fields provided. This will ensure that the description is dynamic and updates automatically based on the product details you enter.

  • Map the product name, category, features, material, unit price, cost price, and sale price.
  • Select the model as Gemini Pro for better results.
  • Click on “Save and Send Test Request” to generate the description.

After a few moments, you will receive a generated product description that is SEO-approved and ready for use in your Shopify store.

5. Updating Google Sheets with Generated Descriptions

Finally, you will update your Google Sheets with the newly generated product description. Add another action step in Pabbly Connect and select Google Sheets as the application, with the event set to “Update Cell Value.” Connect to your Google account and select the spreadsheet and sheet where you want to update the description.

Specify the range for the cell where the description will be updated, such as column H. Map the generated product description from the previous step to this field. Once everything is set, click on “Send Test Request” to ensure the description updates correctly.

Upon successful execution, your Google Sheets will now reflect the updated product descriptions generated by AI, making it easier to manage your Shopify store’s product listings efficiently.

Conclusion

In this tutorial, we explored how to automate product descriptions for your Shopify store using Pabbly Connect and Google Sheets. By following these steps, you can streamline your product management process and enhance your SEO efforts.