Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start generating marketing images using Pabbly Connect, you first need to access the platform. If you’re a new user, open a new tab and search for pabbl.com/connect to reach the Pabbly Connect landing page. Existing users can directly navigate to their workflow builder.

Once on the landing page, click on the ‘Sign up for free’ option in the top right corner. This allows you to explore Pabbly Connect with 100 free tasks every month, enabling you to generate up to 100 images for your marketing campaigns at no cost.

2. Setting Up Google Sheets Integration with Pabbly Connect

To automate image generation, the first step is to set up Google Sheets as the trigger application in 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”.

  • Copy the generated webhook URL.
  • 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 spreadsheet and select “Pabbly Connect Webhooks” from the Extensions tab. In the initial setup, paste the copied URL and define the trigger column (e.g., F for the final data column). Click submit to establish the connection.

3. Generating Images Using Gemini in Pabbly Connect

Next, you will set up Gemini as the action application to generate images. Click on ‘Add New Action Step’, search for Gemini, and select it. Choose the event as “Generate and Edit Image” and click on “Connect”.

If you have an existing connection, select it; otherwise, create a new one by providing your API key from Google AI Studio. Once connected, select the model as “Nano Banana” and specify the method as “Generate Content”.

For the prompt, you will need to map the required details from your Google Sheets. This includes campaign type, product/service, industry, visual style, and campaign goal. Mapping allows dynamic data insertion for each new response received.

4. Updating Google Sheets with Generated Images

After generating the images, the next step is to update your Google Sheets with the image URLs. Click on ‘Add New Action Step’ and select Google Sheets again. Choose the event as “Update Cell Value” and click on “Connect”.

For this step, select the spreadsheet and sheet you are working on. Specify the range (e.g., G2) that needs to be updated and map the row index dynamically. Ensure that the column remains constant while the row index changes with each new response.

  • Map the file URL generated by Gemini.
  • Click on ‘Save and Send Test Request’ to verify the update.

Upon successful execution, check your Google Sheets to see the images added in the specified cells. This setup allows for bulk updates when you use the “Send All Data” option in the Pabbly Connect Webhooks extension.

5. Conclusion: Automate Your Marketing Campaigns with Pabbly Connect

Using Pabbly Connect, you can efficiently automate the generation of marketing images. By integrating Google Sheets and Gemini, you can streamline your workflow, saving time and effort in your marketing campaigns. This automation not only enhances productivity but also ensures consistency in your marketing materials.

Now that you understand how to leverage Pabbly Connect for image generation, you can implement this process to enhance your marketing efforts. Start automating today and enjoy the benefits of seamless integration!