Watch Step By Step Video Tutorial Below
1. Accessing Pabbly Connect for Image Generation
To start using Pabbly Connect, first, you need to create an account if you don’t have one. Pabbly Connect is essential for integrating various applications like Google Sheets and Gemini. Simply sign up for free at the Pabbly website to get started.
Once logged in, navigate to the dashboard of Pabbly Connect. Here, you can create a new workflow by selecting the “Create Workflow” option. This is where you will set up the integration to automate the image generation process.
2. Setting Up the Integration with Google Sheets and Gemini
In this step, you will configure the integration to send image prompts from Google Sheets to Gemini using Pabbly Connect. Begin by clicking on “Create Using Quick Builder” in the workflow section. Enter a prompt that describes your automation needs.
- Select Google Sheets as your trigger application.
- Specify the event that will trigger the workflow.
- Connect to your Google account to access the necessary sheets.
After setting the trigger, you’ll need to connect to Gemini. This will allow Pabbly Connect to send the prompts directly to Gemini for image generation. Make sure to test the connection to ensure everything is working properly.
3. Configuring Google Sheets for Image Prompts
Now, you need to configure your Google Sheets to send data to Pabbly Connect. Open your spreadsheet and navigate to Extensions > Add-ons. Search for “Pabbly Connect Webhooks” and install it. After installation, refresh your spreadsheet to activate the add-on.
Next, go back to Extensions, select Pabbly Connect Webhooks, and set up the initial configuration. You’ll need to paste the webhook URL provided by Pabbly Connect and specify the trigger column where your image prompts will be entered. This setup will ensure that every time you add a new prompt, it will automatically send the data to Pabbly Connect.
4. Generating Images with Gemini AI
After setting up Google Sheets, the next step is to generate images using Gemini. In your Pabbly Connect workflow, add an action step that connects to Gemini. You’ll need to provide your API key from the Gemini Studio.
- Choose the model you want to use for image generation.
- Map the prompt data from Google Sheets to the Gemini action.
- Test the action to ensure images are generated correctly.
This integration allows you to create bulk images based on the prompts you provide in Google Sheets, streamlining your marketing efforts significantly.
5. Updating Google Sheets with Generated Image URLs
Once images are generated by Gemini, the final step is to update your Google Sheets with the image URLs. In your Pabbly Connect workflow, add another action that connects back to Google Sheets.
Specify the sheet and the column where you want the image URLs to be inserted. Map the image URL data received from Gemini to the corresponding cell in Google Sheets. This will automatically update your spreadsheet with the newly created image links.
Conclusion
Using Pabbly Connect to automate the process of generating images with Gemini and updating Google Sheets is a game-changer. This step-by-step guide demonstrates how to set up the integration effectively, enabling you to generate marketing images in bulk effortlessly.



