Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Ad Copy Generation

To start generating ad copies, first access Pabbly Connect by visiting the official website. If you’re a new user, click on the “Sign Up for Free” option in the top right corner to create your account. This will allow you to utilize the powerful features of Pabbly Connect.

Once logged in, navigate to the workflow builder within Pabbly Connect. This is your central hub for creating automated workflows. If you have an existing account, simply open your workflow builder and get ready to set up your automation.

2. Setting Up Google Sheets Trigger in Pabbly Connect

The first step in the workflow is to set up a trigger using Google Sheets. In the workflow builder, click on the “Add Trigger” button and select Google Sheets as the trigger application. Choose “New or Updated Spreadsheet Row” as the event.

  • Select Google Sheets as the trigger application.
  • Choose “New or Updated Spreadsheet Row” as the event.
  • Click on “Connect” to generate a webhook URL.

Copy the webhook URL provided by Pabbly Connect and proceed to your Google Sheets. Here, you will need to install the Pabbly Connect Webhooks add-on to facilitate the integration.

3. Installing Pabbly Connect Webhooks in Google Sheets

In your Google Sheets, go to the Extensions menu, then select Add-ons and click on “Get Add-ons”. Search for “Pabbly Connect Webhooks” and install the add-on. Once installed, refresh your spreadsheet to see the new option.

After refreshing, navigate to Extensions > Pabbly Connect Webhooks > Initial Setup. Here, paste the webhook URL you copied earlier and specify the trigger column (e.g., F for the sixth column). Click on “Submit” to finalize the setup.

  • Go to Extensions > Pabbly Connect Webhooks > Initial Setup.
  • Paste the webhook URL and enter your trigger column.
  • Click “Submit” to confirm the setup.

Once configured, you will see a message indicating that the setup was successful, confirming the connection between Google Sheets and Pabbly Connect.

4. Generating Ad Copies with Gemini AI via Pabbly Connect

Now that the trigger is set up, it’s time to generate ad copies using Gemini AI. In the workflow builder, click on the “Add New Action Step” and search for Gemini. Select it and choose “Generate Content” as the event.

If you haven’t connected Gemini to Pabbly Connect before, you will need to create a new connection. This requires an API key from Google AI Studio. Once you have the API key, paste it into the connection setup.

  • Click on “Add New Connection” and enter the API key.
  • Select the appropriate model and method for content generation.
  • Map the details from your spreadsheet into the prompt for dynamic content.

After mapping the details, click on “Save and Send Test Request” to generate the ad copy. The response will confirm that the ad copy has been successfully created.

5. Updating Google Sheets with Generated Ad Copies

After generating the ad copy, the next step is to update your Google Sheets with this information. Click on “Add New Action Step” again and select Google Sheets as the action application. Choose “Update Cell Value” as the event.

Connect to Google Sheets using the same account as before. Select the spreadsheet and the specific sheet where you want to update the data. For the range, enter the cell where the ad copy should go, such as G2.

  • Select the spreadsheet and the specific sheet to update.
  • Enter the range (e.g., G2) where the ad copy will be placed.
  • Map the generated ad copy to the value field.

Click on “Save and Send Test Request” to confirm that the cell value has been updated successfully. You can now view the generated ad copy in your Google Sheets.

Conclusion

In this tutorial, we learned how to automate the generation of ad copies using Pabbly Connect and Gemini AI. By following these steps, you can streamline your ad copy creation process efficiently.