AI Agent to chat with you Search Console Data, using OpenAI and Postgres

n8n template #2541

Summary

Edit 19/11/2024: As explained on the workflow, the AI Agent with the original system prompt was not effective when using gpt4-o-mini. To address this, I optimized the prompt to work better with this model. You can find the prompts I’ve tested on this Notion Page. And yes, there is one that works well with gpt4-o-mini. AI Agent to chat with you Search Console Data, using OpenAI and Postgres This AI Agent enables you to interact with your Search Console data through a chat interface. Each node is documented within the template, providing sufficient information for setup and usage. You will also need to configure Search Console OAuth credentials. Follow this n8n documentation to set up the OAut

How to set it up

Open template #2541 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 2 credentials under Credentials → Add credential: OpenAI Chat Model, Postgres Chat Memory. Then open each of those nodes and pick the credential.
Check the model in the AI Agent node. The template may point at a model your account can't use; swap it for one you have access to.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "AI Agent to chat with you Search Console Data, using OpenAI and Postgres" (https://n8n.io/workflows/2541). It uses: HTTP Request, AI Agent, OpenAI Chat Model, Call n8n Workflow Tool, Postgres Chat Memory. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

HTTP Request AI Agent OpenAI Chat Model Call n8n Workflow Tool Postgres Chat Memory

Questions

Yes. Dataki published it free on n8n.io as a verified creator, and it has 8,199 views. It runs on n8n Cloud or a self-hosted n8n instance.

OpenAI Chat Model, Postgres Chat Memory. The other 3 nodes are built into n8n.

Similar workflows

NameViews