AutomatingSEO.com was born out of a need to aggregate commonly used automations during SEO work. Automating SEO’s Sheet of Sheets aims to take the most common functions and combine them into an easy to use custom menu inside of Google Sheets.
If there are functions you’d like to see developed that could save you time in your SEO work, please don’t hesitate to reach out to me for possible inclusion.
Here are the current & proposed capabilities of Automating SEO’s Sheet of Sheets:
Sheet of Sheets — Overview
A curated hub of Google Sheets + Apps Script tools for SEO automation. Connect your own API keys, run audits, and get reproducible outputs in minutes.
| Capability | Status | What it does (1-liner) | Inputs | Outputs / Tabs | SEO value |
|---|---|---|---|---|---|
| Sitemap Importer | LIVE | Parses index & leaf sitemaps; imports URLs + image/video/news nodes; handles gzip/redirects. | Sitemap / Index URL | Sitemap_Import_* |
Full crawl source; image/news coverage auditing. |
| Settings / API Keys | LIVE | Per-user keys in UserProperties with mask/reveal + connection tests. | API keys | — | Safe collaboration; faster setup. |
| Batch Processing & Triggers | LIVE | Time-boxed batch runner with progress + re-entry; trigger helpers. | Any long task | Processing Status |
Reliable long jobs without quota blowups. |
| Keyword Clustering (baseline) | BETA | Shared-term grouping; adds Topic column. | Keyword list | Updates Topic column | Fast topical buckets for briefs/IA. |
| Content Extraction Utility | BETA | Attempts to capture main content via common wrappers. | Page URL(s) | Content_Extract |
Quick diffing & briefs. |
| Competitor Research Menu | IN DEV | One-click SERP snapshots & content-gap seeds (Ahrefs/SEMrush). | Domain(s), seed KWs | SERP_*, Gap_* |
Faster competitive briefs. |
| Visual SEO: Image Coverage & Dedupe | IN DEV | Image discovery via sitemap + page checks; dedupe & counts. | Domain / sitemap | Image_Coverage |
Image search + PDP hygiene. |
| GA4 MoM “Movers” Report | PLANNED | MoM diffs with purchases, CVR, engagementRate, avgSessionDuration; clean URLs; page-type buckets. | GA4 export/API | GA4_Movers |
Find wins/losses tied to revenue. |
| Hreflang Extractor (sitemaps) | PLANNED | Pulls <xhtml:link hreflang> sets; flags conflicts/missing. |
Sitemap URL | Hreflang_Audit |
Intl health & duplication control. |
| Canonical / Indexability Sanity | PLANNED | Spot-checks HTML canonical vs. sitemap <loc>; basic robots/meta. |
URLs | Canonical_Checks |
Prevents split signals & soft 404s. |
| SERP Diff & Snapshot Archive | PLANNED | Save SERP HTML/positions over time for keywords/topics. | KW list | SERP_Diff_* |
Proves changes; speeds RCA. |
| Internal Link Map (lite) | PLANNED | Extracts internal links; counts, anchor diversity. | URLs | Internal_Links |
Improves crawl paths & hubs. |
| Alt-Text Coverage & Suggestions | PLANNED | Audit alt coverage; LLM suggestions with adapter choice. | URLs / images | Alt_Audit, Alt_Suggest |
Accessibility + image SEO lift. |
| Provenance Stamp | PLANNED | Auto “how this was generated” box (filters, user, time, script version). | — | Box in each output tab | Trust, repeatability, team sharing. |
How it works
- Connect keys (Settings → API Keys) and run Test Connections.
- Run a tool from the menu (e.g., Sitemap Importer or Keyword Clustering).
- Review outputs in new tabs; long jobs use the batch runner automatically.
FAQ
- Team-safe? Yes—API keys are per-user via UserProperties.
- Big sites? Imports chunked; batch runner avoids timeouts/quota spikes.
- Best first step? Start with Sitemap Importer; it feeds multiple audits.
- Paid APIs? Some features work without; competitor/GA features shine with Ahrefs/SEMrush/GA4 exports.