Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Automation

To start automating image generation, you need to access Pabbly Connect. If you’re a new user, visit pabbl.com/connect and sign up for free. This allows you to explore Pabbly Connect’s features with 100 free tasks per month.

Existing users can directly log into their Pabbly Connect dashboard. Once logged in, you can create workflows that integrate Google Sheets with Google AI to automate image generation.


2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, click on the ‘Create Workflow’ button. You will then be prompted to name your workflow and select a folder for organization. This is crucial for managing multiple workflows efficiently.

Once you have named your workflow, click on the ‘Create’ button. This opens the main workflow window where you’ll add triggers and actions. Here’s how to set it up:

  • Select Google Sheets as the trigger application.
  • Choose the event as ‘New or Updated Spreadsheet Row.’
  • Connect your Google Sheets account to Pabbly Connect.

After setting the trigger, you will be ready to capture data from your spreadsheet whenever a new row is added or updated.


3. Setting Up Google Sheets with Pabbly Connect

In your Google Sheets, you’ll need to install the Pabbly Connect Webhooks add-on. Go to Extensions > Add-ons > Get Add-ons, then search for and install Pabbly Connect Webhooks. Refresh your spreadsheet after installation.

Once refreshed, navigate to Extensions > Pabbly Connect Webhooks > Initial Setup. Here, paste the webhook URL provided by Pabbly Connect and specify the trigger column where data will be entered. For example, if your trigger column is E, input that in the setup. Click ‘Submit’ to finalize the setup.


4. Generating Images with Google AI Studio

To generate images, add a new action step in your Pabbly Connect workflow. Choose Google Gemini as the action application and select the event as ‘Generate and Edit Image.’ Connect your Google AI Studio account using the API key obtained from Google AI Studio.

Make sure to enter the necessary details in the action step, including the prompt for the image generation. Use dynamic mapping to insert data from the Google Sheets trigger. This ensures that each image generated corresponds accurately to the blog details entered in your spreadsheet.


5. Updating Google Sheets with Generated Images

After the image is generated, you need to update your Google Sheets with the image URL. Add another action step in Pabbly Connect and select Google Sheets again. Choose the event as ‘Update Cell Value’ to insert the generated image URL into the appropriate cell.

Map the spreadsheet range where the image URL should be placed, ensuring the column remains constant while the row updates dynamically. Click ‘Save and Send Test Request’ to verify that the image URL is correctly added to your Google Sheets. This completes the automation process using Pabbly Connect.


Conclusion

In this tutorial, we explored how to automate image generation using Pabbly Connect with Google Sheets and Google AI Studio. By following these steps, you can streamline your blogging process and save valuable time. Start using Pabbly Connect today to enhance your productivity!