(5/5)

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

Automated workflow: AI Agent to chat with you Search Console Data, using OpenAI and Postgres. This workflow integrates 13 different services: webhook, stickyNote, httpRequest, agent, memoryPostgresChat. It contains 39 nodes and follows best practices for error handling and security.

Integrations Used (3)

Webhook

Executeworkflow

HTTP Request

Workflow Structure (16 nodes)

100%

Webhook

Webhook - ChatInput

Set

Set fields

No Op

OpenAI Chat Model

No Op

AI Agent

No Op

Postgres Chat Memory

No Op

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:

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

6 Integrations

When to Use This Workflow

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.

Time Savings

Replace repetitive manual tasks with reliable automation.

Reclaim hours every week for higher-value work.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "id": "PoiRk5w0xd1ysq4U",
  "meta": {
    "instanceId": "workflow-479acc1d",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:08:01.309222",
    "updatedAt": "2025-09-29T07:08:01.309238",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "AI Agent to chat with you Search Console Data, using OpenAI and Postgres",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...

Related Workflows

🔌Utilities

Webhook Workflow

Automated workflow: Webhook Workflow. This workflow integrates 18 different services: webhook, stickyNote, httpRequest,...

31 nodesWebhook

🔌Utilities

Bitrix24 Open Chanel RAG Chatbot Application Workflow example with Webhook Integration

Automated workflow: Bitrix24 Open Chanel RAG Chatbot Application Workflow example with Webhook Integration. This workflo...

34 nodesWebhook

🔌Utilities

🔍🛠️Perplexity Researcher to HTML Web Page

Automated workflow: 🔍🛠️Perplexity Researcher to HTML Web Page. This workflow integrates 15 different services: webhook...

47 nodesWebhook

🔌Utilities

Slack Workflow

Automated workflow: Slack Workflow. This workflow integrates 13 different services: webhook, stickyNote, httpRequest, co...

34 nodesWebhook

🔌Utilities