Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for AI Image Generation

To begin generating AI images, first access Pabbly Connect by visiting the official website. Create an account if you haven’t already, and log in to your dashboard. Pabbly Connect offers a free trial, so you can start automating without any upfront costs.

Once logged in, click on the “Create Workflow” button. Name your workflow, such as “AI Images,” and click on the “Create” button to set up your integration. This marks the initiation of your AI image generation process using Pabbly Connect.

2. Setting Up Google Sheets as a Trigger in Pabbly Connect

In this step, you will configure Google Sheets as the trigger application in Pabbly Connect. Click on the “Add Trigger” button and select Google Sheets from the application list. Choose the event as “New or Updated Spreadsheet Row” to capture new entries.

  • Select Google Sheets as your trigger application.
  • Choose “New or Updated Spreadsheet Row” as the event.
  • Click on “Connect” to generate your webhook URL.

Copy the generated webhook URL and navigate to your Google Sheets. Install the “Pabbly Connect Webhooks” add-on from the Extensions menu. Once installed, refresh your sheet to see the new option. In the initial setup, paste the webhook URL and set your trigger column before submitting the test data.

3. Generating Images with Gemini via Pabbly Connect

After setting up Google Sheets, the next step is to generate images using Gemini within Pabbly Connect. Click on “Add New Action Step” and select Gemini as the action application. Choose the event as “Generate Image” to proceed with image creation.

To connect Gemini, you will need an API key from Google AI Studio. Click on “Get API Key” in Google AI Studio, create your key, and paste it into Pabbly Connect. After saving, select the model you want to use, such as “Nano Banana,” and enter your prompt based on the data from your Google Sheets.

  • Select the model for image generation.
  • Map your prompt with dynamic data from the previous step.
  • Click on “Save and Send Test Request” to generate the image.

Once the image is generated successfully, you will receive a response containing the image URL. You can now utilize this URL in your Google Sheets.

4. Updating Google Sheets with Generated Image URLs

With your images generated, the next step is to update Google Sheets with the image URLs using Pabbly Connect. Click on “Add New Action Step” and select Google Sheets again. This time, choose the event “Update Cell Value” to insert the image URL into the specified cell.

Authenticate your Google account and select the spreadsheet and sheet where you want to update the image URL. Specify the cell range, such as E2, and map the generated image URL from Gemini to this cell. Click on “Save and Send Test Request” to complete the update.

By mapping the cell range dynamically, each new response will update the next available cell automatically. This allows for seamless integration and continuous updates using Pabbly Connect.

5. Sending All Data to Generate Bulk Images

To generate multiple images at once, use the “Send All Data” feature in the Pabbly Connect Webhooks add-on. Navigate to the Extensions menu, select Pabbly Connect Webhooks, and click on “Send All Data”. This action will trigger the workflow to process all entries in Google Sheets simultaneously.

Ensure that the “Send on Event” option is enabled to allow automatic image generation whenever new details are added to your sheet. This feature enhances your workflow efficiency, allowing you to generate bulk AI images quickly with just a few clicks using Pabbly Connect.

Once the images are generated, you can view them in your Google Sheets, organized and ready for use. This method streamlines your image generation process significantly.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to integrate Google Sheets with Gemini for seamless AI image generation. By following these steps, you can automate your workflow effectively and generate bulk images in just minutes.