Curated

(5/5)

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

Webhook - ChatInput This webhook serves as the endpoint for receiving ChatInput data. Ensure that you include: - chatInput – the content you wish to send (😉) - sessionId – a unique identifier for the session If you're using an interface such as Open WebUI, the sessionId will be generated automatically.

Integrations Used (7)

Workflow Structure (16 nodes)

100%

Webhook

Webhook - ChatInput

Set

Set fields

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.agent

AI Agent

Langchain.memory Postgres Chat

Postgres Chat Memory

Langchain.tool Workflow

Call Search Console Tool

Respond To Webhook

Respond to Webhook

Execute Workflow Trigger

Tool calling

Set

Set fields - Consruct API CALL

Switch

Http Request

Search Console - Get Custom Insights

Http Request

## Search Console - Get List of Properties

Set

Set fields - Create searchConsoleDataArray

Set

Set fields - Create searchConsoleDataArray 2

Aggregate

Array aggregation - response to AI Agent

Aggregate

Array aggregation - response to AI Agent1

Node Types:

action

default

transform

trigger

logic

http

Requires credentials

Prerequisites

Required Credentials (4)

HTTP Basic Auth

Used by: Webhook - ChatInput

Docs

OAuth2

Used by: Search Console - Get Custom Insights, ## Search Console - Get List of Properties

Docs

OpenAI

Used by: OpenAI Chat Model

Docs

Postgres

Used by: Postgres Chat Memory

Docs

Multiple services required

This workflow needs 4 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~55 min

Score: 70/100

Conditional Logic

5 Integrations

When to Use This Workflow

AI-Powered Content Creation

Automate content generation, summarization, or analysis using AI capabilities.

Save hours of manual work while maintaining quality and consistency.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "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"
      },
...