Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start automating image generation, you need to access Pabbly Connect. If you’re a new user, visit pabbly.com/connect and click on the “Sign Up for Free” button in the top right corner. This allows you to explore the platform with 100 free tasks monthly, enabling you to generate up to 100 images without any cost.

Once logged in, navigate to the workflow builder within Pabbly Connect. This is where you will create your automation by setting up triggers and actions. A trigger is an event that starts the workflow, while an action is what happens as a result of that trigger.

2. Setting Up Google Sheets with Pabbly Connect

The first step in your automation is to set up Google Sheets as the trigger application. In the workflow builder of Pabbly Connect, 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 a webhook URL.

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

After installation, refresh your Google Sheets to see the Pabbly Connect Webhooks option under Extensions. Here, you will set up the initial configuration by pasting the webhook URL and defining the trigger column. This column will indicate when to send data to Pabbly Connect.

3. Generating Images Using Gemini AI

Once your Google Sheets is configured, it’s time to generate images using Gemini AI through Pabbly Connect. Click on the “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.

To establish this connection, you will need an API key from your Google AI Studio. Navigate to the “Get API Key” section in Google AI Studio, create a new API key, and copy it. Paste this key in the Pabbly Connect workflow to link Gemini with Pabbly Connect.

  • Select the model (e.g., Nano Banana) that you want to use for generating images.
  • Map the details from your Google Sheets to the prompt fields in Gemini.
  • Click on “Save and Send Test Request” to generate the image.

After testing, you will receive a file URL for the generated image, which you can then use in your Google Sheets.

4. Updating Google Sheets with the Image URL

After generating the image, you need to update your Google Sheets with the image URL. Add another action step in your workflow and select Google Sheets again. This time, choose the event “Update Cell Value” and connect it to your Google account.

In this step, specify the spreadsheet and the sheet where you want to add the image URL. For the range, map the cell where you want the image URL to appear. For example, if you want to add it to cell F2, you will map it accordingly.

  • Use a slash to map the row index dynamically.
  • Map the file URL generated by Gemini as the value to be updated.
  • Click “Save and Send Test Request” to confirm the update.

Once completed, the image URL will be successfully added to your Google Sheets, completing the automation process through Pabbly Connect.

5. Finalizing Your Automation in Pabbly Connect

To ensure your automation runs smoothly, make sure the “Send On Event” option in the Pabbly Connect Webhooks settings is enabled. This ensures that whenever a new event occurs in your Google Sheets, the details will be sent to Pabbly Connect, triggering the image generation process.

With everything set up, you can now enjoy automated image generation for your projects. Test the workflow by adding new data to your Google Sheets, and watch as Pabbly Connect seamlessly generates images and updates your spreadsheet in real time.

Don’t forget that you can explore more integrations with Pabbly Connect. With its user-friendly interface and powerful capabilities, you can automate various tasks across different applications.

Conclusion

In this tutorial, we explored how to automate image generation using Pabbly Connect, Google Sheets, and Gemini AI. By following these steps, you can streamline your workflow and enhance productivity with ease. Start using Pabbly Connect today for effective automation!