Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start automating your image generation, access Pabbly Connect by visiting pabbly.com/connect. If you are a new user, click on the “Sign Up for Free” button in the top right corner. This will grant you access to 100 free tasks each month, allowing you to explore the capabilities of Pabbly Connect.

After signing up, you will be directed to the workflow builder. This is where you will create your automation. The workflow consists of triggers and actions, where a trigger initiates the process and actions are the results of that trigger. To begin, click on the “Add Trigger” button.

2. Setting Up Google Sheets with Pabbly Connect

For the trigger application, select Google Sheets and choose the event as “New or Updated Spreadsheet Row.” Click on “Connect” to generate a webhook URL. Copy this URL and head over to your Google Sheets.

  • Go to Extensions > Add-ons > Get Add-ons.
  • Search for Pabbly Connect Webhooks and install the extension.
  • Refresh your Google Sheets after installation.

Once refreshed, navigate to Extensions > Pabbly Connect Webhooks > Initial Setup. Here, paste the webhook URL you copied earlier and specify the trigger column. The trigger column will determine which data is sent to Pabbly Connect when updated.

3. Connecting Gemini with Pabbly Connect

Now that Google Sheets is set up, you need to add an action step to connect with Gemini. Click on “Add New Action Step” and search for Gemini. Select the event as “Generate and Edit Images” and click on “Connect.” If you have an existing connection, select it; otherwise, create a new connection.

To create a new connection, go to your Google AI Studio, navigate to “Get API Key,” and create a new key. Copy this key and paste it into Pabbly Connect. After saving, select the model you want to use, such as “Nano Banana,” and proceed to map the details from Google Sheets.

Mapping allows you to insert data dynamically. To do this, use a slash to search for the details from the previous step, ensuring that your automation responds to new data effectively. Once all details are mapped, click on “Save and Send Test Request” to generate the images.

4. Updating Google Sheets with Generated Images

After generating the images, you will need to add the image URLs back into Google Sheets. Add another action step and select Google Sheets, choosing the event “Update Cell Value.” Connect your Google Sheets account if you haven’t already.

In this step, you will specify the spreadsheet and the sheet you want to update. For the range, enter the cell where you want the image URL to appear. Make sure to keep the column constant (e.g., E) while mapping the row index dynamically. This allows you to update the correct row with each new image generated.

Click on “Save and Send Test Request” to update your Google Sheets with the image URL. You will see a confirmation that the image URL has been successfully added. This integration showcases the efficiency of Pabbly Connect in automating tasks between applications.

5. Bulk Image Generation Using Pabbly Connect

To generate images in bulk, return to your Google Sheets, navigate to Extensions > Pabbly Connect Webhooks, and click on “Send All Data.” This action will send all the data from your sheet to Pabbly Connect, allowing Gemini to generate images for each entry.

  • Click on “Send All Data” to initiate the process.
  • Gemini will generate images based on the data provided.
  • The images will be automatically added back to your Google Sheets.

This feature allows you to generate multiple images quickly and efficiently, demonstrating the power of automation through Pabbly Connect. You can also enable the “Send on Event” option to automatically generate images whenever new data is added.

Conclusion

In this tutorial, we explored how to integrate Google Sheets with Gemini using Pabbly Connect. By following these steps, you can automate image generation efficiently, enhancing your workflow.