Audit landing page SEO with GPT-5 and send Gmail reports to Google Sheets
Quick overview This workflow collects a landing page URL via an n8n form, fetches the page HTML, runs two OpenAI-powered SEO audits (technical and content/keyword), generates an overall score with a QuickChart gauge, emails a formatted report via Gmail, and logs results to Google Sheets.
How it works Receives an audit request through an n8n Form Trigger with the landing page URL, optional target keyword, and notification email. Fetches the landing page HTML via HTTP and checks the HTTP status code to confirm the page is accessible. If the page cannot be fetched, sends a failure notification to the requester via Gmail with the status code and URL. If the page is fetched successfully, uses OpenAI to generate a structured Technical SEO audit (score, critical issues, quick wins, opportunities) based on the raw HTML. In parallel, uses OpenAI to generate a structured Content & Keyword SEO audit (score, keyword usage, readability, recommendations) based on the same HTML and the provided keyword. Combines both audits, averages the scores into an overall score, and creates a QuickChart gauge image URL for the report. Uses OpenAI to compose a scannable HTML email containing the scores and recommendations, emails it via Gmail, and appends the audit details to Google Sheets.
Setup Add OpenAI API credentials and confirm the model ID set in the workflow configuration (default: gpt-5-mini) is available to your account. Connect a Gmail OAuth2 credential and set it on both email steps (failure notification and final report). Connect a Google Sheets OAuth2 credential, select the target spreadsheet and sheet, and ensure it has columns for audit_date, landing_page_url, target_keyword, technical_score, content_score, overall_score, and recipient_email. Publish the workflow and share the Form Trigger URL so users can submit landing page audits.
Additional info Audit on-page SEO of a landing page and email an AI-scored report š„ Open full documentation on Notion
Need help customizing? Contact me for consulting and support : Linkedin
MY NEW YOUTUBE CHANNEL š Subscribe to my new YouTube channel. Here I'll share videos and Shorts with practical tutorials and FREE templates for n8n.
Related Templates
AI Email Classifier & Auto-Delete for Gmail (SPAM/OFFER Cleaner)
This workflow is designed for freelancers, solopreneurs, and business owners who receive a high volume of irrelevant mes...
Instagram Full Profile Scraper with Apify and Google Sheets
šø Instagram Full Profile Scraper with Apify and Google Sheets This n8n workflow automates the process of scraping ful...
Generate Product Ad Copy & CTAs with GPT-4 for Slack and Airtable
ā” AI Copywriter Pro: Instant Ad Copy & CTA Generator Transform product details into compelling marketing copy in second...
š Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments