{"product_id":"n8n-seo-audit-workflow-gmail-report-google-sheets","title":"n8n SEO Audit Workflow: Gmail Report + Google Sheets","description":"\u003ch3\u003eGet an instant SEO audit by email—powered by n8n, OpenAI, Gmail, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n SEO Audit Workflow\u003c\/strong\u003e submits a landing page URL, runs \u003cstrong\u003etwo OpenAI-powered SEO audits\u003c\/strong\u003e (technical + content\/keyword), calculates an \u003cstrong\u003eoverall score\u003c\/strong\u003e with a \u003cstrong\u003eQuickChart gauge\u003c\/strong\u003e, then emails a scannable HTML report via \u003cstrong\u003eGmail\u003c\/strong\u003e and logs results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives an audit request\u003c\/strong\u003e through an \u003cstrong\u003en8n Form Trigger\u003c\/strong\u003e with: landing page URL, optional target keyword, and notification email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches the landing page HTML\u003c\/strong\u003e using HTTP and checks the \u003cstrong\u003eHTTP status code\u003c\/strong\u003e to confirm the page is accessible.\u003c\/li\u003e\n  \u003cli\u003eIf the page \u003cstrong\u003ecan’t be fetched\u003c\/strong\u003e, it immediately sends a \u003cstrong\u003efailure notification via Gmail\u003c\/strong\u003e including the status code and URL.\u003c\/li\u003e\n  \u003cli\u003eIf accessible, generates a \u003cstrong\u003estructured Technical SEO audit\u003c\/strong\u003e using OpenAI (score, critical issues, quick wins, opportunities) based on the raw HTML.\u003c\/li\u003e\n  \u003cli\u003eIn parallel, generates a \u003cstrong\u003estructured Content \u0026amp; Keyword SEO audit\u003c\/strong\u003e using OpenAI (score, keyword usage, readability, recommendations) based on the same HTML and the provided keyword.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAverages both scores\u003c\/strong\u003e into an overall score and creates a \u003cstrong\u003eQuickChart gauge image\u003c\/strong\u003e for the report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComposes and emails\u003c\/strong\u003e a formatted HTML report using OpenAI, then \u003cstrong\u003eappends audit details to Google Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRun SEO checks for new landing pages submitted by marketing teams using an n8n Form.\u003c\/li\u003e\n  \u003cli\u003eAutomate recurring SEO evaluations for SaaS product pages and send stakeholders a Gmail report.\u003c\/li\u003e\n  \u003cli\u003eTrack technical and content SEO improvements over time by logging results into Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e n8n Form Trigger, HTTP (fetch HTML), if, set, code, merge, gmail, Google Sheets (append), and QuickChart gauge generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e OpenAI-powered technical and content\/keyword audits; workflow default model ID is \u003cstrong\u003egpt-5-mini\u003c\/strong\u003e (confirm it’s available in your account).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail:\u003c\/strong\u003e Gmail OAuth2 credential required.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eCategory:\u003c\/strong\u003e n8n automation workflow for SEO audits. Perfect for n8n users, automation engineers, and SaaS operators who want reliable, repeatable SEO reporting.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45785663635635,"sku":"N8N-17912","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/k3xvkc8QrX4o8bTndcy8z_LIiEd34R.png?v=1786180163","url":"https:\/\/buyflowscripts.com\/products\/n8n-seo-audit-workflow-gmail-report-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}