{"product_id":"chatgpt-ai-agent-for-search-console-data-n8n-postgres","title":"ChatGPT AI Agent for Search Console Data (n8n + Postgres)","description":"\u003ch3\u003eChat with your Google Search Console data using an n8n AI Agent—powered by OpenAI + Postgres\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow turns your Google Search Console reports into a conversational experience. Instead of manually digging through Search Console screens, you can ask questions in chat and have the agent respond using your Search Console data—while storing\/organizing information in \u003cstrong\u003ePostgres\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProvides an \u003cstrong\u003eAI Agent\u003c\/strong\u003e inside n8n that you can use as a chat interface to query your \u003cstrong\u003eSearch Console data\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIncludes \u003cstrong\u003enode-by-node documentation within the template\u003c\/strong\u003e so you can configure setup and understand how each step works.\u003c\/li\u003e\n  \u003cli\u003eRequires you to configure \u003cstrong\u003eGoogle Search Console OAuth credentials\u003c\/strong\u003e so the workflow can make Search Console API calls.\u003c\/li\u003e\n  \u003cli\u003eUses a tested\/optimized \u003cstrong\u003esystem prompt\u003c\/strong\u003e for compatibility—note that an earlier original prompt was not effective with \u003cstrong\u003egpt4-o-mini\u003c\/strong\u003e, and the workflow includes prompts you can test from the provided Notion page (including one that works well with \u003cstrong\u003egpt4-o-mini\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eHighlights an important setup detail: you must set the \u003cstrong\u003ecorrect OAuth scopes\u003c\/strong\u003e to avoid issues with refresh tokens and frequent re-authentication.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eQuickly answer questions like “Which pages saw the biggest clicks increase last week?” without leaving your workflow.\u003c\/li\u003e\n  \u003cli\u003eSearch Console reporting support for SaaS operators who want faster insights for clients.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an internal “SEO data assistant” using n8n and OpenAI with persistent storage in Postgres.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI + OpenAI\u003c\/strong\u003e (including updated prompt compatibility for \u003cstrong\u003egpt4-o-mini\u003c\/strong\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Search Console\u003c\/strong\u003e via OAuth credentials (configure per n8n OAuth guidance)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePostgres\u003c\/strong\u003e for storing\/working with data\u003c\/li\u003e\n  \u003cli\u003en8n nodes used: \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003eaggregate\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764337008819,"sku":"N8N-2541","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/smg0qaKl6rWDenQ4Ev0dS_2WW1bQGW.png?v=1786007758","url":"https:\/\/buyflowscripts.com\/products\/chatgpt-ai-agent-for-search-console-data-n8n-postgres","provider":"N8N Commerce","version":"1.0","type":"link"}