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
- Runs when you click Test workflow or every day at 8:00.
- Reads the list of target sites from the Google Sheets tab named Sites.
- Normalizes and deduplicates the URLs, then caps the run to a maximum of 5 start URLs to limit costs.
- 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.
- Extracts and flattens per-page audit metrics (score, issues, metadata, performance, and status details) for writing to the Pages tab.
- Extracts site-level summary metrics (site score, top fixes, counts, broken pages, and report URL) for writing to the Summary tab.
- Upserts results back into Google Sheets, matching page rows by url in Pages and summary rows by site in Summary.
Setup
- Install the Apify community node (@apify/n8n-nodes-apify) and add an Apify API token credential.
- Add a Google Sheets OAuth2 credential and paste your spreadsheet ID into all three Google Sheets nodes.
- 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).