Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To begin using Pabbly Connect, you need to access the Pabbly Connect platform. If you’re a new user, visit pabbly.com/connect and click on “Sign Up for Free” in the top right corner. You will get a free trial of Pabbly Connect, allowing you to explore its features.

For existing users, simply log in to your account. Once you are in the dashboard, you can start creating your workflow. This is where you will set up the integration with Google Sheets and other applications.

2. Setting Up Google Sheets with Pabbly Connect

In this step, we will connect Google Sheets to Pabbly Connect. Click on the “Add Trigger” button in your workflow builder, select Google Sheets as the application, and choose the event “New or Updated Spreadsheet Rows”. Click on “Connect” to generate the webhook URL.

  • Copy the webhook URL provided by Pabbly Connect.
  • Open your Google Sheets, go to Extensions, then Add-ons, and select “Get Add-ons”.
  • Search for and install the “Pabbly Connect Webhooks” extension.

After installing, refresh your spreadsheet to see the new options. Go back to the “Pabbly Connect Webhooks” menu and choose “Initial Setup”. Paste the webhook URL and specify the trigger column (e.g., column F). Click “Submit” to configure the setup successfully.

3. Generating Images Using Google Gemini

Now that you have connected Google Sheets to Pabbly Connect, it’s time to generate images using Google Gemini. Click on “Add Action Step” and search for Google Gemini. Select the event “Generate and Edit Image” and connect your Google AI Studio account.

If you haven’t created a connection before, you will need to enter your API key. To obtain the API key, go to Google AI Studio, navigate to “Get API Key”, and create a new key. Copy this key and paste it into your Pabbly Connect workflow.

  • Select the model (e.g., nano banana) and set the method to “Generate Content”.
  • Enter a specific prompt that details the image you want to generate.
  • Use mapping to insert data from your previous steps dynamically.

Once you have set up the image generation parameters, click “Save and Send Test Request”. This will generate the image based on the details provided in your spreadsheet.

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, this time choosing the event “Update Cell Value”.

Connect your Google account and select the spreadsheet you are working with. For the range, specify the column (e.g., G) and map the row index dynamically to allow updates for each new response. Map the value to the image URL generated in the previous step.

  • Choose the correct spreadsheet and sheet.
  • Map the row index to update the correct cell.
  • Click “Save and Send Test Request” to confirm the update.

Check your Google Sheets to see if the image has been successfully added. This process allows you to automate the image generation and updating process seamlessly using Pabbly Connect.

5. Generating Bulk Images with Pabbly Connect

To generate images for multiple brands at once, go back to your Google Sheets. Navigate to Extensions, select “Pabbly Connect Webhooks”, and click on “Send All Data”. This action will send all the data from your spreadsheet to Pabbly Connect, triggering the image generation process for each row.

After sending the data, wait for a few seconds as Pabbly Connect processes the requests. You will see the images being generated and added to your spreadsheet automatically. This bulk processing saves time and ensures consistency across your social media creatives.

If you want the images to be generated automatically whenever new brand details are added, enable the “Send on Event” option in the Pabbly Connect Webhooks menu. This will keep your process automated and efficient.

Conclusion

In this tutorial, we explored how to generate social media creatives for multiple brands using Pabbly Connect. By integrating Google Sheets and Google Gemini, you can automate image creation efficiently. This process not only saves time but also enhances your marketing efforts.