Back to Catalog

Comprehensive SEO Audit with GPT-4 Specialists using Analytics, Search Console & PageSpeed

Jimmy GayJimmy Gay
2917 views
2/3/2026
Official Page

πŸ€– Automated SEO Audit with a Team of AI Specialists

This workflow performs a comprehensive, automated monthly SEO and performance audit for any website. It uses a "team" of specialized AI agents to analyze data from multiple sources, aggregates their findings, and generates a final strategic report.

Every month, it automatically fetches data from Google Analytics, Google Search Console, and Google PageSpeed Insights, and also performs a live crawl of the target website's homepage.

Key Features

  • Fully Automated: Runs on a schedule to deliver monthly reports without manual intervention.
  • Multi-Source Analysis: Gathers data from four key marketing sources for a 360Β° view.
  • AI Agent Team: Uses a sophisticated multi-agent system where each AI specializes in one area (Analytics, Performance, Technical SEO).
  • Master Analyst: A final AI agent synthesizes all specialist reports into a single, actionable strategic plan.
  • Automated Storage: All individual and final reports are automatically saved to a designated Google Sheet.

βš™οΈ Setup Instructions

To use this template, you must configure your credentials and set your target website.

1. Set Your Target Domain (Crucial!):

  • Find the Set Target Website node at the beginning of the workflow.
  • In the "Value" field, replace https://www.your-website.com with the URL of the website you want to audit. This will update the URL across the entire workflow automatically.

2. Configure the Schedule Trigger:

  • Click on the Schedule Trigger node to set when you want the monthly report to run.

3. Connect Your Google Credentials:

  • Google Analytics: Select your credential in the Get a report node.
  • Google Search Console: Select your credential in the Search Console (HTTP Request) node.
  • Google Sheets: Select your credential in all Google Sheets nodes.
  • Google PageSpeed API Key:
    • Go to the "Credentials" tab in n8n and create a new "Generic Credential" with the type "API Key - Query Param".
    • Name it Google API Key.
    • The "Parameter Name" must be key.
    • Paste your PageSpeed API key into the "API Key" field.
    • Go back to the PageSpeed Insight node, select "API Key - Query Param" for Authentication, and choose your new credential.

4. Connect OpenAI Credentials:

  • This template uses multiple OpenAI Chat Model nodes. Configure each one with your OpenAI API key.

5. Set Your Google Sheet:

  • In each of the Google Sheets nodes, replace the hardcoded "Document ID" with the ID of your own Google Sheet where you want to store the reports.

πŸ”¬ Workflow Explained

  1. Phase 1: Data Collection: The Schedule Trigger starts the workflow. Four parallel branches collect data from Google Analytics, PageSpeed Insights, Search Console, and a direct website crawl.
  2. Phase 2: Data Processing & Specialist Analysis:
    • Each data source is processed by a dedicated Code node to format the data.
    • The formatted data is then sent to a specialized AI agent (ANALYTICS SPECIALIST, PERFORMANCE SPECIALIST, etc.) for in-depth analysis.
  3. Phase 3: Report Aggregation: A Merge node waits for all four specialist reports to be completed. A DATA AGGREGATOR node then combines them into a single, comprehensive package.
  4. Phase 4: Master Synthesis & Storage: The final MASTER ANALYST agent receives the aggregated data and produces a high-level strategic summary with actionable recommendations. This final report is then saved to Google Sheets.

Comprehensive SEO Audit with GPT-4 Specialists using Analytics, Search Console, & PageSpeed

This n8n workflow automates a comprehensive SEO audit process by leveraging Google Analytics, Google Sheets, and an AI Agent (likely powered by GPT-4) to analyze website performance data and provide actionable recommendations. It's designed to simulate a team of SEO specialists, each focusing on a specific aspect of the audit.

What it does:

  1. Triggers on Schedule: The workflow is initiated on a predefined schedule (e.g., daily, weekly, monthly) to ensure regular audits.
  2. Fetches Google Analytics Data: It retrieves key performance metrics from Google Analytics, providing insights into website traffic, user behavior, and content performance.
  3. Fetches Google Search Console Data: It pulls data from Google Search Console, focusing on search queries, impressions, clicks, and indexing status to understand organic search visibility.
  4. Fetches Google PageSpeed Insights Data: It queries Google PageSpeed Insights for performance scores and recommendations for both mobile and desktop versions of the website.
  5. Merges Data: All the collected data from Google Analytics, Search Console, and PageSpeed Insights is merged into a single dataset for comprehensive analysis.
  6. Prepares Data for AI Analysis: A "Code" node likely transforms and structures the merged data into a format suitable for the AI Agent, potentially creating a detailed prompt.
  7. AI Agent Analysis: An "AI Agent" node (configured with an OpenAI Chat Model) acts as a team of "specialists" (e.g., Technical SEO, Content SEO, Performance SEO). It processes the prepared data and generates audit findings and recommendations based on its specialized knowledge.
  8. Stores Results in Google Sheets: The AI-generated audit findings and recommendations are then written back to a Google Sheet, providing a centralized and organized report.
  9. Organizes Output: An "Edit Fields (Set)" node likely formats the final output before writing to Google Sheets, ensuring consistency and readability.

Prerequisites/Requirements:

  • n8n Instance: A running n8n instance.
  • Google Analytics Account: With access to the website's analytics data.
  • Google Search Console Account: With access to the website's search performance data.
  • Google Sheets Account: To store the audit results.
  • OpenAI API Key: For the AI Agent (likely GPT-4) to function. This will need to be configured as a credential in n8n for the "OpenAI Chat Model" node.
  • n8n Google Sheets Credential: Configured with appropriate access to read/write to your Google Sheets.
  • n8n Google Analytics Credential: Configured with appropriate access to your Google Analytics property.
  • n8n Google Search Console Credential: Configured with appropriate access to your Google Search Console property.

Setup/Usage:

  1. Import the workflow: Download the JSON and import it into your n8n instance.
  2. Configure Credentials:
    • Set up your Google Sheets, Google Analytics, and Google Search Console credentials in n8n.
    • Set up your OpenAI API key as a credential for the "OpenAI Chat Model" node.
  3. Update Node Parameters:
    • Google Analytics: Configure the "View ID" and desired date range/metrics.
    • HTTP Request (Google Search Console): Update the URL and parameters to fetch data for your specific website and desired metrics from the Search Console API.
    • HTTP Request (PageSpeed Insights): Update the URL with your website's URL for PageSpeed analysis.
    • Code Node: Review and potentially adjust the JavaScript code to tailor the prompt for the AI agent based on your specific audit requirements and data structure.
    • AI Agent: Configure the "OpenAI Chat Model" with your chosen model (e.g., gpt-4) and fine-tune the agent's instructions (the "system message" or "tools" it uses) to define the roles of your "SEO specialists" and the type of analysis you expect.
    • Google Sheets (Output): Specify the "Spreadsheet ID" and "Sheet Name" where the audit results should be written.
    • Schedule Trigger: Adjust the schedule to your preferred audit frequency (e.g., once a week, once a month).
  4. Activate the Workflow: Once all configurations are complete, activate the workflow. It will run automatically according to the defined schedule.
  5. Monitor Results: Check your designated Google Sheet for the generated SEO audit reports and recommendations.

Related Templates

Create verified user profiles with email validation, PDF generation & Gmail delivery

Verified User Profile Creation - Automated Email Validation & PDF Generation --- Overview This comprehensive automation workflow streamlines the user onboarding process by validating email addresses, generating professional profile PDFs, and delivering them seamlessly to verified users. 🎯 What This Workflow Does: Receives User Data - Webhook trigger accepts user signup information (name, email, city, profession, bio) Validates Email Addresses - Uses VerifiEmail API to ensure only legitimate email addresses proceed Conditional Branching - Smart logic splits workflow based on email verification results Generates HTML Profile - Creates beautifully styled HTML templates with user information Converts to PDF - Transforms HTML into professional, downloadable PDF documents Email Delivery - Sends personalized welcome emails with PDF attachments to verified users Data Logging - Records all verified users in Google Sheets for analytics and tracking Rejection Handling - Notifies users with invalid emails and provides guidance ✨ Key Features: βœ… Email Verification - Prevents fake registrations and maintains data quality πŸ“„ Professional PDF Generation - Beautiful, branded profile documents πŸ“§ Automated Email Delivery - Personalized welcome messages with attachments πŸ“Š Google Sheets Logging - Complete audit trail of all verified users πŸ”€ Smart Branching - Separate paths for valid and invalid emails 🎨 Modern Design - Clean, responsive HTML/CSS templates πŸ”’ Secure Webhook - POST endpoint for seamless form integration 🎯 Perfect Use Cases: User registration systems Community membership verification Professional certification programs Event registration with verified attendees Customer onboarding processes Newsletter signup verification Educational platform enrollments Membership card generation πŸ“¦ What's Included: Complete workflow with 12 informative sticky notes Pre-configured webhook endpoint Email verification integration PDF generation setup Gmail sending configuration Google Sheets logging Error handling guidelines Rejection email template πŸ› οΈ Required Integrations: VerifiEmail - For email validation (https://verifi.email) HTMLcsstoPDF - For PDF generation (https://htmlcsstopdf.com) Gmail OAuth2 - For email delivery Google Sheets OAuth2 - For data logging ⚑ Quick Setup Time: 15-20 minutes πŸŽ“ Skill Level: Beginner to Intermediate --- Benefits: βœ… Reduces manual verification work by 100% βœ… Prevents spam and fake registrations βœ… Delivers professional branded documents automatically βœ… Maintains complete audit trail βœ… Scales effortlessly with user growth βœ… Provides excellent user experience βœ… Easy integration with any form or application --- Technical Details: Trigger Type: Webhook (POST) Total Nodes: 11 (including 12 documentation sticky notes) Execution Time: ~3-5 seconds per user API Calls: 3 external (VerifiEmail, HTMLcsstoPDF, Google Sheets) Email Format: HTML with binary PDF attachment Data Storage: Google Sheets (optional) --- License: MIT (Free to use and modify) --- 🎁 BONUS FEATURES: Comprehensive sticky notes explaining each step Beautiful, mobile-responsive email template Professional PDF styling with modern design Easily customizable for your branding Ready-to-use webhook endpoint Error handling guidelines included --- Perfect for: Developers, No-code enthusiasts, Business owners, SaaS platforms, Community managers, Event organizers Start automating your user verification process today! πŸš€

Jitesh DugarBy Jitesh Dugar
51

Automate Reddit brand monitoring & responses with GPT-4o-mini, Sheets & Slack

How it Works This workflow automates intelligent Reddit marketing by monitoring brand mentions, analyzing sentiment with AI, and engaging authentically with communities. Every 24 hours, the system searches Reddit for posts containing your configured brand keywords across all subreddits, finding up to 50 of the newest mentions to analyze. Each discovered post is sent to OpenAI's GPT-4o-mini model for comprehensive analysis. The AI evaluates sentiment (positive/neutral/negative), assigns an engagement score (0-100), determines relevance to your brand, and generates contextual, helpful responses that add genuine value to the conversation. It also classifies the response type (educational/supportive/promotional) and provides reasoning for whether engagement is appropriate. The workflow intelligently filters posts using a multi-criteria system: only posts that are relevant to your brand, score above 60 in engagement quality, and warrant a response type other than "pass" proceed to engagement. This prevents spam and ensures every interaction is meaningful. Selected posts are processed one at a time through a loop to respect Reddit's rate limits. For each worthy post, the AI-generated comment is posted, and complete interaction data is logged to Google Sheets including timestamp, post details, sentiment, engagement scores, and success status. This creates a permanent audit trail and analytics database. At the end of each run, the workflow aggregates all data into a comprehensive daily summary report with total posts analyzed, comments posted, engagement rate, sentiment breakdown, and the top 5 engagement opportunities ranked by score. This report is automatically sent to Slack with formatted metrics, giving your team instant visibility into your Reddit marketing performance. --- Who is this for? Brand managers and marketing teams needing automated social listening and engagement on Reddit Community managers responsible for authentic brand presence across multiple subreddits Startup founders and growth marketers who want to scale Reddit marketing without hiring a team PR and reputation teams monitoring brand sentiment and responding to discussions in real-time Product marketers seeking organic engagement opportunities in product-related communities Any business that wants to build authentic Reddit presence while avoiding spammy marketing tactics --- Setup Steps Setup time: Approx. 30-40 minutes (credential configuration, keyword setup, Google Sheets creation, Slack integration) Requirements: Reddit account with OAuth2 application credentials (create at reddit.com/prefs/apps) OpenAI API key with GPT-4o-mini access Google account with a new Google Sheet for tracking interactions Slack workspace with posting permissions to a marketing/monitoring channel Brand keywords and subreddit strategy prepared Create Reddit OAuth Application: Visit reddit.com/prefs/apps, create a "script" type app, and obtain your client ID and secret Configure Reddit Credentials in n8n: Add Reddit OAuth2 credentials with your app credentials and authorize access Set up OpenAI API: Obtain API key from platform.openai.com and configure in n8n OpenAI credentials Create Google Sheet: Set up a new sheet with columns: timestamp, postId, postTitle, subreddit, postUrl, sentiment, engagementScore, responseType, commentPosted, reasoning Configure these nodes: Brand Keywords Config: Edit the JavaScript code to include your brand name, product names, and relevant industry keywords Search Brand Mentions: Adjust the limit (default 50) and sort preference based on your needs AI Post Analysis: Customize the prompt to match your brand voice and engagement guidelines Filter Engagement-Worthy: Adjust the engagementScore threshold (default 60) based on your quality standards Loop Through Posts: Configure max iterations and batch size for rate limit compliance Log to Google Sheets: Replace YOURSHEETID with your actual Google Sheets document ID Send Slack Report: Replace YOURCHANNELID with your Slack channel ID Test the workflow: Run manually first to verify all connections work and adjust AI prompts Activate for daily runs: Once tested, activate the Schedule Trigger to run automatically every 24 hours --- Node Descriptions (10 words each) Daily Marketing Check - Schedule trigger runs workflow every 24 hours automatically daily Brand Keywords Config - JavaScript code node defining brand keywords to monitor Reddit Search Brand Mentions - Reddit node searches all subreddits for brand keyword mentions AI Post Analysis - OpenAI analyzes sentiment, relevance, generates contextual helpful comment responses Filter Engagement-Worthy - Conditional node filters only high-quality relevant posts worth engaging Loop Through Posts - Split in batches processes each post individually respecting limits Post Helpful Comment - Reddit node posts AI-generated comment to worthy Reddit discussions Log to Google Sheets - Appends all interaction data to spreadsheet for permanent tracking Generate Daily Summary - JavaScript aggregates metrics, sentiment breakdown, generates comprehensive daily report Send Slack Report - Posts formatted daily summary with metrics to team Slack channel

Daniel ShashkoBy Daniel Shashko
679

Automate financial transaction tracking with Gmail, GPT, Notion & Telegram alerts

πŸ“© Automatically Log Transactions from Gmail into Notion and Get Telegram Alerts Who’s it for This workflow is for individuals or entrepreneurs who receive bank alerts, invoices, and payment emails in Gmail and want them to be automatically organized in Notion β€” while also receiving quick Telegram notifications for each transaction. If you manage personal or business finances and find it tedious to manually record every debit, credit, or invoice β€” this automation does it all for you. --- How it works The workflow acts as an AI-powered Accountant Agent that reads incoming Gmail messages and decides whether each email represents a Debit Transaction, Credit Transaction, Debit Invoice, or Credit Invoice. The Gmail Trigger watches your selected inboxes (like forwarding@bayesian-labs.com, support@bayesian-labs, anoop.karnik@bayesian-labs). The Classifier (GPT-5-nano) determines the correct transaction type. The appropriate Agent (GPT-5) then extracts amount, currency, and description details. The Agent uses Notion API tools to log structured data into your Personal Finance System Notion template (Financial Transactions & Income databases). Finally, a Telegram notification is sent summarizing the entry (From, To, Subject, Snippet). In short: every time your bank emails you β€” Notion gets updated, and you get notified. --- How to set up Duplicate the Personal Finance System Notion template into your workspace. Create a Telegram Bot with BotFather β†’ copy the bot token and your chat ID. Generate an OpenRouter API key for GPT-5 / GPT-5-nano. Create a Notion Integration Token and connect it to your duplicated finance databases. Add your Gmail accounts (forwarding@, support@, and/or personal Gmail) under Gmail OAuth2 credentials in n8n. Import the workflow JSON into n8n β†’ fill in the credential names as listed below: n8ncloudregular_usage β†’ OpenRouter Notion account β†’ Notion API Accountant AI β†’ Telegram Bot Gmail OAuth2 for each inbox trigger Once active, n8n polls Gmail every minute, classifies emails, updates Notion, and sends Telegram updates. --- Requirements n8n instance (self-hosted or cloud) Gmail accounts connected via OAuth2 OpenRouter API key Telegram bot token & chat ID Notion integration token Your duplicated Personal Finance System Notion template --- How to customize the workflow You can extend this workflow to: Track credit card statements, subscriptions, or payroll notifications. Add Slack or WhatsApp alerts alongside Telegram. Include live FX rates for USDβ†’INR conversion using an API node. Connect Google Sheets as a backup ledger or export target. Add error-handling branches to mark Gmail messages as processed or label them β€œLogged to Notion”.

AnoopBy Anoop
92