Monitor Google Sheets inputs, fetch Jenkins results via HTTP, summarize with Gemini AI, and email the daily report automatically.
Reads the daily Jenkins test details from Google Sheets and constructs a targeted HTTP query to fetch results. Generates a concise AI-assisted summary that emphasizes the most important metrics. Emails the professional report to all recipients listed in MailingList at a scheduled time.
A concise view of its capabilities
Pulls test run details from Google Sheets
Builds the Jenkins data request using the Google Sheets data
Fetches results from the Jenkins server via HTTP
Summarizes data with Gemini AI to a concise report
Formats the summary into an email-ready message
Distributes the email to recipients in MailingList
Before: manual data gathering and inconsistent formats slowed reporting. After: automated data collection, consistent formats, timely delivery, focused AI usage, and auditable trails.
A simple 3-step flow
Reads BaseUrl, Environment, FeatureClass, Feature, and MailingList from Google Sheets and builds the Jenkins URL for the HTTP request.
Sends an HTTP request to the Jenkins server and retrieves the selected test run data.
Uses Gemini AI to create a concise summary and emails it to the MailingList.
A realistic daily scenario
Scenario: At 07:00 every workday, the AI agent reads the Feature and MailingList from Google Sheets, builds the Jenkins query, fetches the latest results, generates a two-paragraph summary with key pass/fail metrics, and emails it to 6 recipients by 07:30.
Users who rely on daily Jenkins reports
needs reliable daily visibility into test outcomes for quick triage.
oversees multiple features and needs a single daily digest.
wants to verify CI health and minimize manual report steps.
requires an at-a-glance status update for releases.
needs evidence of test stability before approving deployments.
monitors test health as part of platform reliability.
Systems the AI agent works with
Reads test inputs and recipient lists to build the Jenkins query.
Fetches the relevant test results for the day.
Generates a concise, readable summary from the data.
Distributes the final report to MailingList recipients.
Where automated summaries save time and reduce risk
Common questions and detailed answers
Data stays within your environment. Access is controlled by your Google Sheets permissions, Jenkins credentials, and the AI API keys you provide. The workflow uses secure HTTP(S) endpoints and stores minimal transient data for the report. You can rotate credentials and restrict sheet access as needed. You’ll want proper network controls and least-privilege access for your integration.
Provide a Google Sheet with the required columns (BaseUrl, Environment, FeatureClass, Feature, MailingList). Configure the Jenkins endpoint and recipient list, then provide an AI API key for Gemini or another provider. Schedule the agent to run at your preferred time and specify any alert should there be failures. The setup is designed to be non-technical and follows a simple field mapping.
Yes. The MailingList column defines recipients for each run. You can update this list per row to target different teams or individuals. The agent reads the MailingList for each execution and delivers the exact set of recipients. It also supports grouping recipients by project for easier filtering.
The agent logs the failure and attempts a retry if configured. If the Jenkins data cannot be retrieved, a fallback summary is still generated using previously cached metrics or a minimal report. Email delivery is skipped or marked as failed when data is unavailable. You receive a notification of the failure and can re-run once Jenkins is back online.
The Gemini AI can be tuned to emphasize different metrics and formatting. You can specify which metrics to include in the summary (pass rate, duration, flaky tests) and adjust the email tone. The structure remains consistent for readability and downstream processing. Changes are saved to your configuration and apply on the next run.
Scheduling is defined by your Google Sheet trigger or external scheduler. The agent can run at a fixed time daily or inline with your CI/CD pipeline. It supports time zone adjustments and can skip days when no relevant data exists. You can modify the schedule without altering the core logic.
The agent is designed to fetch only the necessary data to minimize AI token usage. You can constrain data by filtering the Google Sheet inputs and choosing specific features. This keeps the summary focused and cost-effective while meeting audit requirements.
Monitor Google Sheets inputs, fetch Jenkins results via HTTP, summarize with Gemini AI, and email the daily report automatically.
