Run automated SEO audits with Screaming Frog CLI, PageSpeed, PDF and Excel fixes

💡 What this workflow does Type Audit https://clientsite.com in Slack. Walk away. Get a professional PDF report and a structured Excel fix sheet delivered to Google Drive and posted back in your Slack thread — fully automated, zero manual work.

Built for SEO agencies and freelancers who deliver technical audits at scale.

👇 Check out the deliverables: 📄 [View Sample PDF Report](https://drive.google.com/file/d/1BAXRB73bEg2G1kiE1trb9-j3nwBYJgxu/view?usp=sharing) 📊 [View Sample Excel Fix Sheet](https://docs.google.com/spreadsheets/d/1qDcqcGBwF6UXbv2zYOwr0QNTc0qQ9VGC/edit?usp=sharing&ouid=117021044678312583918&rtpof=true&sd=true)

---

📦 What You Get 20–50 page PDF report: Includes a health score, Core Web Vitals, broken links, On-Page SEO, issue cards with fix explanations, a priority action plan, and an SEO glossary. Excel fix sheet: 18 tabs (one per issue type), containing every URL and exact fix instructions — ready to hand off to a developer. Cloud Storage: Both files are saved to your Google Drive /SEO Audits folder automatically. Slack Delivery: Links to the generated files are posted directly back into your original Slack thread.

---

⚙️ How It Works 1. A Slack message containing Audit and a URL triggers the workflow. 2. A POST request starts the crawl via your self-hosted Screaming Frog CLI API (built with Python + FastAPI, exposed publicly through a Cloudflare Tunnel — no static IP needed). 3. The workflow polls the API every 2 minutes until the status is done, timeout, or failed. 4. The crawl ZIP is downloaded and decompressed, triggering two simultaneous branches: Branch A (Executive Report): SEO Audit Parser → PageSpeed Insights → PSI Parser → Report Builder → HTML to PDF → Google Drive. Branch B (Developer Sheet): Full Data Parser → Tab Builder → Excel File Builder → Google Drive. 5. Both Google Drive links are merged, logged to a Google Sheet, and posted back into the Slack thread.

---