Free SEO audit template
Crawl your site, merge in Search Console, and know what to do with every page
It runs in Google Sheets, so there’s nothing to install. Give it your sitemap and a Search Console export, and it crawls every page, puts clicks, impressions, CTR and position beside each one, and gives every URL a decision with the reason written next to it.
What you get, page by page
- Status code, title and indexability for every URL, with its clicks, impressions, CTR and average position right beside them
- A score for every page against your own site-wide averages, using a quarter-of-average threshold for clicks and impressions
- A decision for every URL, with a short reason and the technical flags to act on, like missing meta descriptions
- Duplicate flags and AI recommendations, all run from one Content Audit menu
It’s the same sheet we run our own audits in. Every row carries the decision, the evidence and the traffic at stake, so it can go straight to whoever ships the fix.
You’ll need a Gemini API key for the AI recommendations. And it can’t see commercial value, so check your money pages by hand before you cut anything.
Get the template
The link appears on this page the moment you submit, and a copy lands in your inbox. Add your sitemap and Search Console export, choose Run Full Audit, and the sheet fills itself in.