Summarize daily Jenkins test runs with Google Sheets, HTTP and Gemini AI

Description

Automate daily Jenkins test reports with AI and HTTP Requests
As a test automation engineer, staying on top of daily test runs in Jenkins is essential. This workflow automates that process: it pulls specific test details from a Google Sheet, retrieves data from your local Jenkins environment, and uses AI to generate a concise summary report to be sent via email.

Who's it for
Test automation engineers using Jenkins.
QA teams looking to streamline daily reporting.

How it works
Scheduled Trigger: The workflow runs automatically at a pre-defined time.
Dynamic Data Retrieval: It constructs an HTTP request based on the data in your Google Sheet to fetch specific Jenkins results.
AI Optimization: Only relevant data is extracted to minimize AI token usage and focus on the most important metrics.
Summarization: The AI groups the results and formats them into a clear, professional email.
Distribution: The report is sent to every recipient listed in the MailingList column.


How to set up
In the Google Sheet, set the BaseUrl, Environment, FeatureClass and Feature in order to build up the Jenkins url in their corresponding columns, for example:
BaseUrl | Environment | FeatureClass |Feature |MailingList |
<BaseUrl> |<environment> | <FeaturClassName> |<Featurename> | <mail> |
Define Recipients: In the MailingList column, add the email addresses of the people who need to receive the report. If there are multiple recipients, ensure they are separated by commas.


Requirements
Access to your Jenkins server.
An AI API key (e.g., Gemini, OpenAI).
A Google Cloud project with the Google Sheets API enabled.