Most small businesses never audit their own website. Not because they do not care — because doing it by hand takes hours: open Search Console, copy keyword positions, run PageSpeed, crawl the sitemap, check every link, then write it all up. So it never happens, and problems sit there for months.
This workflow does the whole job by itself. Every Monday at 9:00 AM it wakes up, audits the website, writes the report with AI, saves it to Google Sheets, and emails it to the owner. No one has to remember anything.
It is live and running on our own website, Rank Vai Creation. Here is exactly how it works.
What the workflow does
In one run it pulls keyword and position data from Google Search Console, checks the site's speed with the Google PageSpeed API, crawls the sitemap and tests every URL on the site, finds broken links (and reports zero when there are none), combines everything into one dataset, has an AI agent write a plain-language weekly report, saves the numbers to Google Sheets, and emails the report.
The 16 nodes, step by step
- Schedule Trigger — starts the run every Monday at 9:00 AM.
- Get GSC Keywords — calls the Search Console API and pulls the site's keyword rows: which queries the site shows for, and at which average position.
- PageSpeed Check — calls the Google PageSpeed API for the homepage and returns the performance score, Largest Contentful Paint and Cumulative Layout Shift.
- Set PageSpeed Metrics — keeps only the speed numbers the report needs.
- Get Sitemap — downloads the site's sitemap.xml.
- XML - Sitemap URLs — parses the sitemap and extracts every URL.
- Split In Batches — processes the URLs a few at a time so the run stays fast and stable.
- Check URL Status — opens every URL and records its HTTP status.
- IF - Broken? — sends any URL that returns an error down the broken-link branch.
- Code - Collect Broken Links — gathers the broken URLs into one list. When the site has no broken links, this branch simply does not run — which is the correct result.
- Code - Combine All Data — merges the keyword data, the speed metrics and the broken-link list into a single report dataset. It is written so the run still succeeds when there are zero broken links.
- AI Agent — reads the combined data and writes the weekly report: what improved, what dropped, the top 5 fixes in priority order, and what to do next week.
- OpenAI Chat Model (gpt-4o-mini) — the model behind the agent. It is the cheapest OpenAI model, so a weekly report costs almost nothing.
- Google Sheets - Save Report — appends one row per week: date, average position, broken links, speed score.
- Gmail Report — emails the finished report to the owner.
- Split Out - URLs — splits the sitemap URLs into individual items for the batch loop.
Live result from our own website
The first successful run took 22 seconds and checked 8 URLs: 8 URLs checked, 0 broken links, average position 4.31. The report was delivered to Gmail and saved to Google Sheets.
The report itself flagged what matters most right now: the site is fast, but it is not ranking for keywords yet — because Google has not indexed the pages. That is exactly what a weekly audit is for: it tells you the truth every Monday, so you fix the right thing instead of guessing.
Why this matters for a small business
A weekly audit turns SEO from a mystery into a routine. You see the average position move, you see new pages get indexed, you catch broken links the week they appear instead of six months later. And because the report lands in your inbox, you do not need to learn Search Console or PageSpeed to use it.
The same pattern works for any website: a store, a clinic, a real-estate agency, a restaurant. The data sources change, the shape stays the same — collect, check, combine, report.
Want this workflow for your website?
This workflow runs on our own site as a working sample. If you want the same weekly audit for your business, or the workflow JSON to run it yourself, message us on WhatsApp: https://wa.me/8801307261565 or email sohel.mirpur27@gmail.com.
We build AI agents, n8n workflows and chatbots for small businesses. Read more about our SEO services for small business and our WordPress development services, or start from the Rank Vai Creation homepage.
This article was written with AI assistance and reviewed by Sohel Ahmed.



