SEO Sheets / Spreadsheets by Zeo
SEO Sheets
We share the spreadsheets and Google Script-based automations that our consultants use every day at the agency to solve problems they run into frequently. If there's an automation that would make your day easier, feel free to customize the sheets yourself, or tell us what you need and we'll add it to our waiting list.
How it works?
What do you need to use the tools?
Google Sheets is one of the easiest tools for any analyst to use, with an interface much like Excel. We build practical tools for your SEO work using both formulas and Google Scripts. You can use the sheets freely by following the user guide included with each one and creating a copy for yourself.
- Content Brief GeneratorBuild data-driven content briefs from live SERP data and AI.ContentSERP APIOpenAIMake a copy →
- 404 URL Mapper LiteMap broken URLs to the most relevant live page using SERP data.TechnicalSERP APIMake a copy →
- Title & H1 AnalyzerCompare your titles and H1s against the ranking pages.ContentSERP APIMake a copy →
- Cannibalization CheckerDetect pages competing for the same query across your site.ContentTechnicalSERP APIMake a copy →
- Sitemap FinderDiscover a site’s XML sitemaps from robots.txt and common paths.TechnicalMake a copy →
- Sitemap ScraperExtract every URL from an XML sitemap into a spreadsheet.TechnicalMake a copy →
- HTTP Version ControlCheck which HTTP protocol version each URL is served over.TechnicalMake a copy →
- Status Code CheckerBulk-check HTTP status codes and redirects for a list of URLs.TechnicalMake a copy →