Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, open your browser and navigate to pabbl.com/connect. If you’re a new user, click on the “Sign up for free” button in the top right corner. This will allow you to explore the platform with 100 free tasks every month.

Once signed up, you can access the workflow builder. This is where the automation process begins. If you’re an existing user, simply log in to your account to start creating your integration.

2. Setting Up Google Sheets as the Trigger Application

In Pabbly Connect, the first step is to set Google Sheets as your trigger application. Click on the “Add Trigger” button and select Google Sheets. Choose the event as “New or Updated Spreadsheet Row” and click on “Connect” to receive the webhook URL.

  • Select Google Sheets as the trigger application.
  • Choose the event “New or Updated Spreadsheet Row”.
  • Copy the webhook URL provided.

Next, open your Google Sheets and install the Pabbly Connect Webhooks add-on. Go to Extensions > Add-ons > Get Add-ons, search for “Pabbly Connect Webhooks”, and install it. After installation, refresh your spreadsheet and navigate to Extensions > Pabbly Connect Webhooks > Initial Setup.

3. Configuring the Webhook in Google Sheets

In the Initial Setup window of the Pabbly Connect Webhooks add-on, paste the webhook URL you copied earlier. Specify the trigger column, which will send the entire row data to your webhook. For this example, we’ll set the trigger column to F, where product details will be entered.

Click on the “Submit” button to save your configuration. You will see a confirmation that the setup was successful. To test the connection, click on “Send Test” to send test data from your Google Sheets to Pabbly Connect.

  • Paste the webhook URL in the Initial Setup window.
  • Enter the trigger column (e.g., F).
  • Click “Submit” and then “Send Test”.

This action will capture the first row of data in your workflow, enabling Pabbly Connect to respond to any new entries in the specified column.

4. Integrating Gemini for Image Generation

After configuring the webhook, the next step is to add an action step to generate images using Gemini. Click on “Add New Action Step” and select Gemini as the action application. Choose the event “Generate and Edit Image” and connect it to your existing Gemini account.

If you haven’t set up a connection before, you will need to enter your Google AI API key. Access your Google AI studio to create a new API key, name it, and copy it back to Pabbly Connect. This key is essential for authenticating your requests.

Once connected, select the model you want to use for image generation, such as Nano Banana. Specify the method as “Generate Content for the Prompt” and map the product details from the Google Sheets input. This mapping allows dynamic content generation based on the product details entered in your spreadsheet.

5. Updating Google Sheets with Generated Images

The final step in this automation is to update your Google Sheets with the generated image URLs from Gemini. Add another action step in Pabbly Connect and select Google Sheets again. This time, choose the event “Update Cell Value”.

Connect your Google Sheets account and select the spreadsheet where you want to update the image URL. Specify the cell range, mapping the row index dynamically while keeping the column static. For example, set it to G2, and map the row index to change with each new entry.

Finally, map the image URL received from Gemini to the cell in Google Sheets and click “Save and Send Test Request”. This will add the generated image URL to your specified cell, completing the automation process.

Conclusion

In this tutorial, we explored how to automate fashion product image generation using Pabbly Connect, Google Sheets, and Gemini. By following the steps outlined, you can streamline your workflow and enhance productivity through automation.