Dive in ↓
From the Blog

Latest Articles

AI automation tips, n8n workflows, SEO guides and WordPress tutorials. New posts you publish in Blogger appear here automatically.

← All articles

AI SEO Audit Workflow (n8n): Automate Your Weekly SEO Report


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

  1. Schedule Trigger — starts the run every Monday at 9:00 AM.
  2. 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.
  3. PageSpeed Check — calls the Google PageSpeed API for the homepage and returns the performance score, Largest Contentful Paint and Cumulative Layout Shift.
  4. Set PageSpeed Metrics — keeps only the speed numbers the report needs.
  5. Get Sitemap — downloads the site's sitemap.xml.
  6. XML - Sitemap URLs — parses the sitemap and extracts every URL.
  7. Split In Batches — processes the URLs a few at a time so the run stays fast and stable.
  8. Check URL Status — opens every URL and records its HTTP status.
  9. IF - Broken? — sends any URL that returns an error down the broken-link branch.
  10. 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.
  11. 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.
  12. 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.
  13. OpenAI Chat Model (gpt-4o-mini) — the model behind the agent. It is the cheapest OpenAI model, so a weekly report costs almost nothing.
  14. Google Sheets - Save Report — appends one row per week: date, average position, broken links, speed score.
  15. Gmail Report — emails the finished report to the owner.
  16. 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.

Rank Vai Creation

Rank Vai Creation — AI automation, SEO, digital marketing and WordPress development services in Bangladesh. AI agents, n8n workflows, chatbots and websites that grow your business.

Search This Blog

Powered by Blogger.

Blog Archive

About Us

About Rank Vai Creation

Sohel Ahmed - Founder and CEO, Rank Vai Creation
Sohel Ahmed
Founder & CEO, Rank Vai Creation

The Agency

Rank Vai Creation is an AI automation, SEO and WordPress agency founded in 2017 in Mirpur, Kushtia, Bangladesh. We help small businesses save time and win more customers with practical automation — AI agents, n8n workflows, chatbots, websites and search optimisation that fit a small-business budget.

Sohel Ahmed outdoors in a rooftop garden

Meet the Team

Behind every project is a small specialist team: Tania Begum leads WordPress and AI automation, Md Lutfar Rahman designs and builds websites, Atik Zaman works on UI/UX and Facebook AI automation, MD Abdullah Alif Noyon handles Facebook and website AI automation, and Nazmus Sakib builds with Python.

Our vision: make AI automation practical and affordable for small businesses — in Bangladesh and worldwide — so a small team can work like a big one.

Tools & Skills We Use

n8nAI AgentsWordPressWooCommerceSEOPHP / LaravelHTML / CSS / JavaScriptRAG & PineconeGoogle Sheets APIMeta Graph APIPhotoshopVideo Editing
Get Your Project Started

Let’s Build Something Together

Tell us about your project — AI automation, SEO, or a new website. Our team will reply with a clear plan and honest pricing.

Phone / WhatsApp: +8801307261565

Email: sohel.mirpur27@gmail.com

Website: rankvaicreation.com · Mirpur, Kushtia, Bangladesh

Email Us Chat on WhatsApp 📅 Book a Call on WhatsApp
About Me

My Profile

AI Automation Specialist, founder of Rank Vai Creation and live trainer — his story and how to reach him.

Chat on WhatsApp