Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Event Automation

To start creating AI posters for your events, first, access Pabbly Connect. If you’re a new user, visit pabbl.com/connect and click on “Sign up for free” in the top right corner. This allows you to explore the platform with 100 free tasks each month.

After signing up, log in to your Pabbly Connect account. Here, you will use the workflow builder to automate your poster creation process. This automation will link Google Sheets and Gemini to generate posters based on the event details you input.

2. Setting Up Google Sheets with Pabbly Connect

Next, you need to set up Google Sheets to collect event details. In your Google Sheet, enter the event name, type, date, venue, theme style, and main highlight. This data will be sent to Pabbly Connect for processing.

  • Open your Google Sheet and go to Extensions > Add-ons > Get add-ons.
  • Search for “Pabbly Connect Webhooks” and install it.
  • After installation, refresh your Google Sheet.

Once refreshed, navigate to Extensions > Pabbly Connect Webhooks > Initial Setup. Here, paste the webhook URL from your Pabbly Connect workflow and set the trigger column to F. This column will send all event details to the webhook when updated.

3. Creating the Poster Using Gemini via Pabbly Connect

Now that your Google Sheet is ready, the next step is to create the poster using Gemini. In your Pabbly Connect workflow, click on “Add New Action Step” and select Gemini as the action application. Choose the event “Generate and Edit Image”.

If you haven’t connected Gemini to Pabbly Connect, enter your API key. To get the API key, go to Google AI Studio, navigate to “Get API Key”, create a new key, and copy it back to Pabbly Connect.

  • Search for the model “Nano Banana” and select it.
  • Set the method to “Generate Content”.
  • Map the event details from Google Sheets into the prompt for dynamic content.

After mapping the necessary details, click “Save and Send Test Request”. This will generate the poster based on the input from your Google Sheet.

4. Updating Google Sheets with the Generated Poster URL

Once the poster is generated, the next step is to update your Google Sheet with the poster URL. In your Pabbly Connect workflow, click “Add New Action Step” and select Google Sheets again. Choose the event “Update Cell Value”.

Connect your Google Sheets account to Pabbly Connect if you haven’t done so already. Select the spreadsheet and specify the range where the poster URL will be added, such as G2. Use the mapping feature to dynamically set the row index based on the new entry.

  • Map the file URL from the previous step to update the cell.
  • Click “Save and Send Test Request” to verify the update.

After the test request, check your Google Sheet to confirm that the poster URL has been successfully added. This completes the integration process.

5. Finalizing the Automation with Pabbly Connect

To finalize your automation, ensure the “Send on Event” button is activated in the Pabbly Connect Webhooks settings. This ensures that any new entry in your trigger column will automatically initiate the poster generation process.

With this setup, every time you enter new event details into your Google Sheet, Pabbly Connect will trigger the workflow, generate the poster, and update the sheet with the new URL. This automation saves time and streamlines your event management process.

Now you can easily create AI posters for any event without manual intervention. This powerful automation can significantly enhance your productivity and efficiency.

Conclusion

In this tutorial, we explored how to create AI posters for events using Pabbly Connect, Google Sheets, and Gemini. This automation simplifies the process, allowing you to generate posters quickly and efficiently.