Automate Google Ads Keyword Research Using Google Gemini

Learn how to automate Google Ads keyword research using Pabbly Connect and Google Gemini. Follow our detailed step-by-step tutorial for seamless integration. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Ads Keyword Research

To automate Google Ads keyword research, the first step is to access Pabbly Connect. If you are a new user, navigate to Pabbly.com/connect and click on the ‘Sign Up for Free’ option. This allows you to explore the capabilities of Pabbly Connect with 100 free tasks each month.

For existing users, simply log in to your account and open the workflow builder. This interface is crucial as it allows you to set up triggers and actions needed for your automation. Remember, the trigger is the event that starts the process, while the action is what happens as a result.

2. Setting Up Google Sheets Trigger in Pabbly Connect

In this step, you will set up Google Sheets as the trigger application in Pabbly Connect. Click on the ‘Add Trigger’ button and search for ‘Google Sheets’. Select the event ‘New or Updated Spreadsheet Row’ and connect it.

• Search for Google Sheets and select it as the trigger application.
• Choose the event ‘New or Updated Spreadsheet Row’.
• Connect to Google Sheets and copy the webhook URL provided.

After copying the webhook URL, open the Google Sheets you want to connect. Go to Extensions > Add-ons > Get add-ons, search for ‘Pabbly Connect Webhooks’, and install it. Refresh your spreadsheet to access the Pabbly Connect Webhooks option. In the initial setup, paste the copied webhook URL and define the trigger column where data will be sent.

3. Configuring the Pabbly Connect Webhook for Google Sheets

Once you have set up the webhook in Google Sheets, you must configure it properly in Pabbly Connect. In the extensions menu, go to Pabbly Connect Webhooks and select ‘Initial Setup’. Paste the webhook URL and specify the trigger column.

For example, if your trigger column is E, this means that when data is added to column E, it will trigger the webhook. After entering these details, click on ‘Submit’. A successful setup message will confirm the connection between Google Sheets and Pabbly Connect.

• Paste the webhook URL in the setup.
• Define the trigger column based on your spreadsheet layout.
• Click on ‘Submit’ to save your settings.

After this, click ‘Send Test’ to verify that Pabbly Connect has captured the response correctly. You will see the data captured in the workflow, indicating a successful connection.

4. Generating Keywords Using Google Gemini in Pabbly Connect

Now that you have set up the trigger, the next step is to generate keywords using Google Gemini. In your Pabbly Connect workflow, click on ‘Add New Action Step’ and search for ‘Google Gemini’. Select the event ‘Generate Content’ and click connect.

If you haven’t created a connection yet, you will need to enter your API token from Google AI Studio. To get this token, navigate to Google AI Studio, click on ‘Get API Key’, and create a new key. Copy this key and paste it into Pabbly Connect.

Add Google Gemini as an action step in your workflow. Enter your API token for authentication. Map the prompt using data from Google Sheets for dynamic keyword generation.

After entering the prompt, select the model of your choice and click ‘Save and Send Test Request’. This will generate the keywords based on the details provided from Google Sheets, which will now be added to your spreadsheet automatically.

5. Updating Google Sheets with Generated Keywords

The final step involves updating your Google Sheets with the keywords generated by Google Gemini. In your Pabbly Connect workflow, click on ‘Add New Action Step’ and select Google Sheets again. Choose the event ‘Update Cell Value’ and connect.

Sign in with your Google account to grant permissions. Select the spreadsheet and the specific sheet you want to update. For the range, specify the cell where the keywords will be inserted. Use a static column (e.g., F) and map the row dynamically to accommodate new entries.

Select the Google Sheets action to update cell values. Map the cell range to ensure it updates correctly. Click ‘Save and Send Test Request’ to finalize the update.

Now, every time you add a new product topic or audience in Google Sheets, the keywords will automatically be generated and populated in the designated cells, streamlining your Google Ads keyword research process.

Conclusion

In this tutorial, we explored how to automate Google Ads keyword research using Pabbly Connect and Google Gemini. By following the steps outlined, you can seamlessly integrate Google Sheets with Google Gemini to generate keyword suggestions in real-time, enhancing your advertising efficiency.