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

Manual

High

Nodes

Manual

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

memory Postgres Chat

Postgres Chat Memory

1 node

lm Chat Open Ai

OpenAI Chat Model

1 node

set

Set fields, Set fields - Consruct API CALL, Set fields - Create searchConsoleDataArray, Set fields - Create searchConsoleDataArray 2

4 nodes

sticky Note

Sticky Note, Sticky Note1, Sticky Note2, Sticky Note3, Sticky Note4, Sticky Note6, Sticky Note5, Sticky Note7, Sticky Note8, Sticky Note9, Sticky Note10, Sticky Note11, Sticky Note12, Sticky Note13

14 nodes

webhook

Webhook - ChatInput

1 node

respond To Webhook

Respond to Webhook

1 node

tool Workflow

Call Search Console Tool

1 node

execute Workflow Trigger

Tool calling

1 node

switch

Switch

1 node

agent

AI Agent

1 node

http Request

Search Console - Get Custom Insights, ## Search Console - Get List of Properties

2 nodes

aggregate

Array aggregation - response to AI Agent, Array aggregation - response to AI Agent1

2 nodes

Workflow JSON

29.37 KB

{
  "id": "PoiRk5w0xd1ysq4U",
  "meta": {
    "instanceId": "b9faf72fe0d7c3be94b3ebff0778790b50b135c336412d28fd4fca2cbbf8d1f5",
    "templateCredsSetupCompleted": true
  },
  "name": "AI Agent to chat with you Search Console Data, using OpenAI and Postgres",
  "tags": [],
  "nodes": [
    {
      "id": "9ee6710b-19b7-4bfd-ac2d-0fe1e2561f1d",
      "name": "Postgres Chat Memory",
      "type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
      "position": [
        1796,
        220
      ],
      "parameters": {
        "tableName": "insights_chat_histories"
      },
      "credentials": {
        "postgres": {
          "id": "",
          "name": "Postgres"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "eb9f07e9-ded1-485c-9bf3-cf223458384a",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1356,
        240
      ],
      "parameters": {
        "model": "gpt-4o",
        "options": {
      ...

Showing first 1000 characters. Click "Expand" to view the full JSON.