AI Agent: Chat with Search Console Data via OpenAI & Postgres

This n8n workflow deploys an AI Agent that enables natural language interaction with your Google Search Console analytics data. Data is fetched via Search Console API, stored in Postgres, and queried conversationally using OpenAI's GPT models. A webhook serves as the chat entry point, making it easy to integrate into apps or use directly. Each node is fully documented for quick setup.

Key setup includes configuring Search Console OAuth2 credentials with precise scopes (https://www.googleapis.com/auth/webmasters.readonly) to prevent token refresh issues—screenshots provided in the template. Add your Google Cloud client ID/secret, OpenAI API key, and Postgres connection. The system prompt is optimized for cost-effective models like GPT-4o-mini, with tested variants linked in Notion for best performance.

Benefits include effortless SEO insights without SQL queries or dashboards: ask about top queries, impressions, clicks, trends, or custom reports in plain English. Ideal for marketers analyzing search performance, saving hours on reporting. Use cases span SEO monitoring, content optimization, competitor analysis, and business intelligence for websites in travel, e-commerce, or any data-driven field. High scalability for production use.