See llms.txt for all machine-readable content.

Back to Templates

Run website SEO audits with Apify and Google Sheets

Quick overview

This workflow runs manually or daily and reads website URLs from Google Sheets, audits each site with the Apify SEO Audit Tool actor, and writes per-page scores plus a site-level summary and report link back to separate Google Sheets tabs.

How it works

  1. Runs when you click Test workflow or every day at 8:00.
  2. Reads the list of target sites from the Google Sheets tab named Sites.
  3. Normalizes and deduplicates the URLs, then caps the run to a maximum of 5 start URLs to limit costs.
  4. Runs the Apify actor hillcountrybots/seo-audit to crawl and audit each site (up to 20 pages per site and 40 pages total) and generates an HTML report link when available.
  5. Extracts and flattens per-page audit metrics (score, issues, metadata, performance, and status details) for writing to the Pages tab.
  6. Extracts site-level summary metrics (site score, top fixes, counts, broken pages, and report URL) for writing to the Summary tab.
  7. Upserts results back into Google Sheets, matching page rows by url in Pages and summary rows by site in Summary.

Setup

  1. Install the Apify community node (@apify/n8n-nodes-apify) and add an Apify API token credential.
  2. Add a Google Sheets OAuth2 credential and paste your spreadsheet ID into all three Google Sheets nodes.
  3. Create a Google Sheet with tabs named Sites, Pages, and Summary, and ensure Sites has a url column containing public http(s) URLs (or domains that can be normalized to URLs).