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.

Requirements

• n8n instance (self-hosted or cloud)
• Google Sheets account (to store website URLs and logs)
• Gmail account (for sending alerts)
• Google Drive account (to save SEO reports)
• PDF.co API Key (for HTML → PDF conversion)

How to customize

• Change performance threshold: Modify the IF node condition (default <50).
• Custom SEO rules: Edit the “SEO Health Check” Function node to add/remove checks (e.g., missing schema tags, page load times).
• Different output storage: Replace Google Drive with Dropbox, S3 or OneDrive.
• Alternate notification channels: Swap Gmail with Slack, Microsoft Teams or Telegram.

Add-ons

• Send Slack/Teams notifications for low scores.
• Add PageSpeed Insights API for performance scoring.
• Generate weekly summary reports per domain.
• Integrate with Notion/Confluence to log SEO health history.

Use Case Examples

• An SEO agency monitors 100+ client websites daily and sends alerts when a site has poor SEO signals.
• A company’s marketing manager gets a daily SEO health PDF report stored in Drive.
• A SaaS product team automatically logs performance changes for each release.

Common Troubleshooting

Need Help?

If you’d like assistance setting up, customizing or scaling this workflow for your use case, our n8n automation team at WeblineIndia can help you:

• Tailor SEO rules for your industry.
• Connect to additional APIs (Ahrefs, Semrush, PageSpeed).
• Automate weekly/monthly reporting with summary dashboards.