THE NUMBERS
What Changed After Implementation
FULL WORKFLOW
Complete 20-Node Map
| Node | Type | Function |
|---|---|---|
| Form Submission Webhook | webhookTrigger | Receives POST from Tally / Typeform |
| Validate & Normalize Input | code (JS) | URL normalization, field validation, order_id generation |
| Acknowledge Receipt | respondToWebhook | Instant confirmation JSON to form submitter |
| Fetch Homepage HTML | httpRequest | Raw HTML fetch of target URL |
| PageSpeed API | httpRequest | Google Core Web Vitals — mobile strategy, free |
| Scrape Homepage | code (JS) | Parses HTML for all on-page SEO signals |
| Merge All Site Data | code (JS) | Combines crawl + PageSpeed + form data |
| Build AI Audit Prompt | code (JS) | Assembles full structured prompt with all site data |
| Claude AI — Generate Audit | httpRequest → OpenRouter | Claude Opus 4, 4096 tokens, strict JSON schema output |
| Parse AI Audit JSON | code (JS) | Validates schema, extracts scores and labels |
| Build HTML Report | code (JS) | Full branded HTML, all CSS inline, 5 print-ready pages |
| Convert to PDF (PDFCrowd) | httpRequest | Server-side PDF rendering, consistent output |
| PDF Success? | if | Routes to Google Drive upload or HTML fallback |
| Upload to Google Drive | googleDrive | Stores PDF organised by domain + order ID |
| Prepare HTML Attachment | code (JS) | Converts HTML to binary attachment for email |
| Email Owner — Review | gmail | Score + client info + report attached for review |
| Wait 2h for Review | wait | Buffer window before client delivery |
| Email Client — Final Report | gmail | Branded PDF delivery with order reference |
| Error Trigger | errorTrigger | Global error catcher for the entire workflow |
| Notify Owner of Error | gmail | Error details with domain + context sent to owner |
TECH STACK
Tools Used in This Workflow
OPSPILOTS VERDICT
Highest ROI Automation for Agencies
At $0.80–$0.90 per audit in API costs, this workflow pays for itself in the first 10 minutes of time saved — every single time you run it.
Scalability: High. Want Ahrefs DR data? Add one HTTP node. GSC integration? Same. The prompt builder assembles whatever data you feed it. The AI and reporting pipeline require zero changes.
Prerequisites
Self-hosted n8n, OpenRouter API key, PDFCrowd account (free tier available), Google Drive OAuth2, Gmail OAuth2. PageSpeed is completely free — no key required.
Primary Risk
Heavily JS-rendered sites may return thin crawl signals. Pair with Ahrefs or GSC data for more complete prompts on complex sites.
If you're selling audits — or giving them away as lead magnets — and you're still doing them by hand, you're leaving hours and margin on the table every single week.
BOTTOM LINE
Your team is doing manually what this system does in seconds.
We build and deploy automation exactly like this — configured for your stack, running on your infrastructure, delivering results from day one. Most projects go live in 5–10 days.
Frequently Asked Questions
What data sources does the audit pull from?
The system pulls data from Google Search Console, Screaming Frog, and PageSpeed Insights in one automated run. It checks technical issues (broken links, indexation gaps, page speed), keyword performance gaps, and content opportunities — then compiles everything into a prioritized report with severity scores and specific fix recommendations.
How much faster is this versus doing audits manually?
Manual tools require you to export, cross-reference, and interpret data across multiple platforms — typically 4–6 hours for a full audit. This automation connects all sources, runs comparisons automatically, and outputs a complete action list. The same audit completes in under 30 minutes, scheduled weekly without any human input.
Does this replace an SEO analyst?
It replaces the data-gathering and reporting work — typically 60–70% of an analyst's time. The system handles collection, analysis, and report generation. Strategic decisions still require human judgment, but the analyst spends that time acting on insights rather than pulling spreadsheets from five different tools.
How often should audits run?
As frequently as needed. Most clients run weekly automated audits for ongoing monitoring and a deeper monthly analysis for trend tracking. The system sends a Telegram alert if a critical issue appears between scheduled runs — for example, a sudden drop in indexed pages or a spike in 404 errors.
What does it cost to deploy?
Single-workflow deployments start from $500. A full SEO audit pipeline with GSC integration, Screaming Frog API, and automated Telegram reporting typically runs $1,500–$2,500 depending on the data sources and report complexity required. All workflows are self-hosted — no per-month SaaS fees after deployment.
Skip the trial-and-error. We've already mapped what works.
We map exactly which workflows cost your team the most time and give you a specific deployment plan — in one 30-minute call.
Book Free 30-Min Process Audit →