Reporting & automation

Search data and website checks in one report

A workflow combining Google Search Console data and website checks in an organized email, with scheduling and review of automated flags.

PythonGitHub ActionsSearch Console API

Explore the work Contact

Search data → Python → Email report

Python · Search Console

WeeklyScheduled frequency

Python 3.11Workflow runtime

EmailReport delivery

Reading the results

The documented output is a configured schedule and a received report. Its 30 automated critical flags need validation; they are not confirmed or resolved defects. No time savings or search-performance improvement were measured.

From idea to execution

THE WORK / 07

01 /

The goal

Bring recurring search data and website checks together so they can be reviewed and issues selected for further investigation.

02 /

My contribution

Report planning, Python development with AI assistance, data-source connections, scheduling and review of the output.

03 /

Tools used

PythonGitHub ActionsSearch Console APIClaude

Client / organisationStudienkolleg Düsseldorf

Period2026 · sample report 7 September

What the work shows

An automated workflow still needs its output reviewed. I treated flags as prompts to investigate and refined the checks rather than accepting every warning as a confirmed defect.

What I did and why

01
Defined the report’s page, search-query and country data alongside selected website checks.
02
Used Python and the Google Search Console API to collect and organize data, with AI tools assisting code development.
03
Configured GitHub Actions for Mondays at 05:00 UTC and added a manual-run option.
04
Reviewed the report received on 7 September 2026 and refined checks after identifying false positives.

Work samples

Received weekly audit with search performance and flagged checks.

GitHub Actions configuration with schedule and manual trigger.

Search queries and average positions in the email report.

Sources, dates and measurement notes

Evidence: workflow configuration and a received report dated 7 September 2026. The report shows 799 clicks, 121,840 impressions, 0.7% rounded CTR and an average position of 10.0 for its displayed seven-day view. These describe the report output, not an improvement caused by the automation. Its 30 critical findings are automated flags, not confirmed or resolved defects. No time-saving estimate is claimed.

Next projectGoogle Ads and a landing page for study enquiries All projects

LET’S TALK

Working on a similar project?

I can help turn recurring data collection and reporting into a workflow whose output can be reviewed.

Email metamerrashed5@gmail.com