Automated SEO Reporting and GPT-4 Analysis - n8n Workflow

Markdown-formatted text:

SEO Managers and Specialists needing automated, recurring performance reports.
Marketing Agencies looking to streamline client reporting with data and AI commentary.
Data Analysts who want a sophisticated example of connecting multiple APIs (GSC, OpenAI, Slack, Pdforge) within a single n8n node framework.
Users seeking powerful n8n templates for advanced data compilation and delivery.

Generating detailed SEO performance reports often involves tedious manual data extraction, compilation, and interpretation. This specialized n8n workflow solves this by providing a hands-free, end-to-end automation solution.

The automation begins with an n8n trigger set for a weekly schedule. It retrieves comprehensive organic search data from Google Search Console (GSC) for both the current and previous reporting periods. The data is then synthesized into a single structure. Crucially, a GPT-4 powered AI agent analyzes this structured data to generate concise, actionable insights. The final structured data, including the AI narrative, is passed to the Pdforge service to instantly render a professional, branded PDF report. Finally, the complete report is delivered directly to a specified Slack channel, completing a highly efficient n8n automation loop. This robust n8n workflow significantly reduces manual effort and increases reporting speed and accuracy.

Markdown-formatted text:

1. Start (n8n Trigger): The process is initiated by the Weekly at monday 8am n8n trigger, ensuring timely report generation.


2. Configuration: The initial Configuration n8n node sets the siteurl and calculates dynamic date ranges for the current month and the previous month.


3. Data Retrieval: Multiple HTTP Request n8n nodes connect to the Google Search Console API to fetch metrics for the current and previous periods across various dimensions (Overview, Date, Query, Page, Device, Country).


4. Data Structuring: The raw API outputs are processed by Split Out nodes and then standardized using various Format Set n8n nodes.


5. Compilation & Analysis: The highly customized Format data Code n8n node aggregates all nine distinct datasets. It calculates metrics like ranking distribution (Top 3, 4-10), identifies top-performing content, keywords, pages with the largest traffic loss, and newly ranking keywords, preparing the final data structure.


6. AI Insight Generation: The LangChain Agent (Generating Insights for SEO Results) uses the configured OpenAI Chat Model (GPT-4) to analyze the complex dataset and produce a single, actionable 300-400 character SEO insight based on the biggest identified changes.


7. Variable Generation: The Generate variables Code n8n node merges the compiled report data with the AI-generated insight.


8. PDF Report Creation: The Pdforge n8n node utilizes the template ID templateseo_report to generate the PDF report using the rich JSON data input.


9. File Download: A final Download Binary HTTP Request node retrieves the actual PDF file using the signed URL provided by Pdforge.


10. Delivery: The Slack - Send Message with File n8n node delivers the binary PDF file to the team, concluding the scheduled n8n automation run.

Markdown-formatted text:

1. Import the n8n workflow: Copy the provided JSON data and paste it directly into your n8n instance using the 'New' > 'Import from JSON' function.


2. Google Search Console Credentials: Create an OAuth2 credential named 'Google OAuth2' in n8n. You must enable the Search Console API in the Google Cloud Console and use the scope https://www.googleapis.com/auth/webmasters.readonly.


3. OpenAI Credentials: Set up your OpenAI API key credential in n8n. The workflow uses the powerful GPT-4 model via the OpenAI Chat Model n8n node.


4. Pdforge Credentials: Obtain and configure your API credentials for Pdforge, a necessary service for dynamic PDF generation.


5. Slack Credentials: Create a Slack OAuth2 credential. Configure the target Channel ID in the Slack - Send Message with File n8n node where the report should be delivered.


6. Update Site URL: In the starting Configuration Set n8n node, update the site_url parameter from sc-domain:your-domain.com to your actual Search Console domain property.

Markdown-formatted text:

Weekly at monday 8am (Schedule Trigger): This serves as the primary n8n trigger, initiating the report generation process exactly once per week.
Configuration (Set n8n node): Defines the target site_url and dynamically calculates the start and end dates for the current reporting period and the previous comparison period using n8n expressions.
HTTP Request - Google Search Console (Multiple Nodes): These are core data collection nodes. They execute API calls against the GSC API to retrieve data segmented by dimension (Overview, Date, Query, Page, Device, Country). Authentication is handled via the Google OAuth2 credential.
Format data (Code n8n node): The central data transformation piece of this n8n workflow. It uses JavaScript to aggregate inputs from multiple upstream nodes, calculate comparative metrics (e.g., traffic changes vs. previous month), and structure all data points into a single, cohesive JSON object optimized for report templating.
Generating Insights for SEO Results (Langchain Agent n8n node): This crucial n8n node leverages the underlying OpenAI Chat Model (GPT-4) to analyze the complex JSON structure generated by the previous step and distill the key findings into a short, actionable text summary.
Pdforge (n8n node): Generates the final PDF report. It takes the comprehensive JSON data (including AI insights) and applies it to a predefined SEO report template, generating a download URL for the document.

• Slack - Send Message with File (n8n node): The final delivery node. It uploads the newly generated PDF report to a specified Slack channel, completing the automated n8n workflow execution.