How to Create an AI Bot to Analyze the Monthly Performance of Google Ads Campaigns

Google Ads provides a series of highly relevant metrics about the active campaigns on the platform. Analyzing conversions, cost per click, impressions, and the amount spent helps identify opportunities and areas for improvement.

Using Albato, it is possible to create a bot that will notify you in Slack, at a specified time interval, about how your campaign is performing compared to the previous report.

Learn below how to create this automation in just a few steps.

Connecting the Applications

The first step before building this type of workflow is connecting the applications we will use.

Go to the Apps tab in Albato and click Add a Connection

Search for each application individually and follow the required steps indicated on the platform until you see the success message confirming that the connection has been created.

The apps we will need are: Google Ads, Google Sheets, and Slack.

Attention: if you do not have the Albato AI feature available in your plan, you will also need to connect an application capable of analyzing the data using AI, such as Gemini, Claude, Perplexity, OpenAI, among others.

Once all apps have been connected, we can create the automation.

How to Create the Automation

Go to the Automations tab in Albato and click Create New Automation.

Next, click on the first step to add the trigger for this automation:

Here, we will select the Google Ads app and the Ad Expenses event:

After adding this event, configure it as a Campaign report and choose the desired period (you can select daily, weekly, biweekly, or monthly, for example).

You will also need to add your Google Ads Customer ID, and finally, the campaign name and whether it is active.

If you do not add the campaign name, the report will provide a complete overview of all campaigns, but it will specify which campaign each metric belongs to.

Example:

Then, click here to add another step:

Select the Google Sheets app and then the Create/Update Row action.

We recommend creating a new blank spreadsheet beforehand with the desired columns, such as the campaign name and one column for each important metric you would like to analyze. The first column should be called Period.

Next, in this Albato step, fill in the first period column with the Period parameter received from the trigger:

Then, in the Rows section of Albato, fill in the remaining fields by mapping each metric to its corresponding column, like this:

Click here to add another action:

This time, select the Mathematical Operation tool:

This tool will help us find the number of the previously added row. This way, we will know both the current row and the previous row, giving the AI step the necessary data to properly analyze the reports.

Configure this step as follows:

Next, add another Google Sheets action, this time to find a row by its row number:

The value we will use is precisely the output from the Mathematical Operation, so it will look like this:

Now we will use the Albato AI Chat Completion step to analyze this information:

Attention: remember that if you do not have the Albato AI feature included in your plan, you should connect another application in this step that provides the same functionality, such as Gemini, OpenAI, Perplexity, Claude, among others.

Configure a prompt that clearly highlights which data should be analyzed and what type of result you want to obtain. Here is an example prompt that can be used:

Analyze the following data: (Here you add the data collected from the step where you inserted information into Google Sheets).

And compare it with the following information: (Here you add the data collected from the step that retrieves the previous row from Google Sheets).

Then, generate a detailed and in-depth analysis that considers the main metrics and outlines the campaign’s overall performance. Identify expenses and results, and highlight areas for improvement and attention. The response should be a complete analysis in one or two paragraphs that will be sent to the responsible team through Slack.

This step will look approximately like this:

Keep in mind that this is only a sample prompt. Feel free to customize it in whatever way you consider most useful for your company. It is also possible to modify this step further, adjusting the prompt according to your needs and optimizing the final report generated.

Finally, add another step, this time using Slack, to send a private message to a user.

If you prefer, you can also replace the Slack step with sending a message to a public or private Slack channel, a Telegram message, an email, or even adding a note to a CRM deal. The logic would essentially remain the same.

Fill in the Slack User field with your ID or the responsible person's ID.

Then, in the Unformatted Message field, add the response generated by the AI step.

Now simply activate your automation here:

Based on the time interval configured in the trigger, you will receive an analysis of your campaigns comparing the current results with the previous ones. This will help you make more strategic decisions in a fast, simple, and automated way.