Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, go to the Pabbly Connect homepage by entering ‘pabbly.com/connect’ in your browser. Here, you have options to sign in or sign up for a free account. New users can enjoy 100 free tasks monthly to explore the features.

If you’re an existing user, simply sign in. After logging in, navigate to the Pabbly Connect dashboard where you can create a new workflow. This is the first step in integrating Google Sheets with Gemini to automate image generation.

2. Creating a Workflow in Pabbly Connect

To create a new workflow, select the option to start from scratch or use the AI workflow builder. For this tutorial, we will use the AI workflow builder. Enter a prompt detailing your workflow: “When a new row is added in Google Sheets, send data to Gemini for generating an image, and then update the image link in Google Sheets.”

  • Select the trigger event as “New or Updated Spreadsheet Row” for Google Sheets.
  • Choose the action event as “Generate and Edit Images” for Gemini.
  • Select “Update Cell Value” for Google Sheets as the final action.

After reviewing the workflow, click on “Approve and Create” to finalize your setup. This step is crucial as it establishes the connection between Google Sheets and Gemini through Pabbly Connect.

3. Setting Up the Trigger for Google Sheets

In this step, you will set up the trigger for your workflow. After selecting the Google Sheets app and the event, you will receive a webhook URL. Copy this URL, as it will be used to connect Google Sheets with Pabbly Connect.

Next, log into your Google Sheets account and open the spreadsheet you wish to automate. You need to install the Pabbly Connect Webhooks add-on. Go to Extensions, select Add-ons, and then Get Add-ons. Search for “Pabbly Connect Webhooks” and install it. After installation, refresh your Google Sheets.

  • Click on Extensions again, then select Pabbly Connect Webhooks.
  • Choose Initial Setup and paste the copied webhook URL.
  • Set the trigger column to the final data column where you will add details.

Once you’ve set this up, click Submit. This connects your Google Sheets to Pabbly Connect, allowing for automated data transfer.

4. Connecting to Gemini for Image Generation

Now that your trigger is set, it’s time to connect to Gemini to generate images. In Pabbly Connect, select the Gemini app and provide the necessary API key. You can obtain this key from your Google AI Studio account.

Once you have the API key, select the model you wish to use, such as “Nano Banana Pro,” and set the method to “Generate Content.” Here, you will also need to enter a prompt for the AI to generate the image. Instead of manual entry, you can map data from the previous steps to make the process dynamic.

  • Enter the relevant prompt for image generation.
  • Use the mapping feature to dynamically insert data from Google Sheets.
  • Click on Save and Send Request to complete this step.

This will generate an image based on the details provided, completing the connection between Pabbly Connect and Gemini.

5. Updating Google Sheets with Generated Image Links

After generating the image, the next step is to update your Google Sheets with the newly created image link. Again, you’ll use Pabbly Connect to establish this connection. Select Google Sheets as the app and choose the action event to update the cell value.

In this step, specify the spreadsheet and sheet you are working with. For the range, enter the appropriate column and row index where the image link should be updated. After setting this up, click on Save and Send Request.

  • Select the spreadsheet as “AI Image Generation” and the sheet as “Sheet 1.”
  • Specify the column name and dynamically map the row index.
  • Click Save and Send Request to finalize the update.

After successfully updating the Google Sheets, you can verify that the image link has been added correctly. This completes the automation process, allowing you to generate images and update your Google Sheets seamlessly.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of generating images from Google Sheets using Gemini. By following these steps, you can streamline your workflow and enhance productivity.