Website SEO health analytics with Google Sheets, PDF reports & Gmail alerts

Automated SEO Health Monitoring & Reporting

This workflow automatically monitors the SEO health of websites stored in a Google Sheet. It fetches each website’s HTML, analyzes key SEO metrics (title, meta description, H1 count, canonical, robots, performance score, etc.) and updates results back into Google Sheets. If performance is poor (<50), it sends an alert email. For healthy sites, it generates a detailed PDF report and stores it in Google Drive.

Who’s it for

Digital marketing teams SEO agencies Website administrators who want automated SEO health checks Businesses with multiple websites or landing pages to monitor

How it works

1. Daily Trigger – Runs every day at 9 AM. 2. Fetch Website List – Reads website URLs from Google Sheets. 3. Crawl Websites – Uses HTTP requests to fetch each website’s HTML. 4. SEO Analysis – Extracts SEO-related metadata (title, meta description, H1, etc.). 5. Health Check – Scores SEO performance based on predefined rules. 6. Decision Node – If score < 50 → Send alert email; else → Generate full SEO report. 7. Update Logs – Logs results back into Google Sheets. 8. Generate PDF Reports – Converts HTML reports into PDFs via PDF.co API. 9. Save to Drive – Stores the PDF reports in Google Drive for long-term access.

How to set up

1. Open n8n and import the workflow. 2. Configure your Google Sheets credentials and specify the sheet containing your website URLs. 3. Add your Gmail account to allow automated alert emails. 4. Set up your Google Drive credentials for storing PDF reports. 5. Obtain an API key from PDF.co and configure the HTTP Request node. 6. Adjust the Schedule Trigger to the time that works best (default: 9 AM daily). 7. Test the workflow with a sample domain list.