从Postgres导出AI代理对话日志到Google Sheets
高级
这是一个Engineering, AI领域的自动化工作流，包含 23 个节点。主要使用 Set, Postgres, HttpRequest, GoogleSheets, ManualTrigger 等节点，结合人工智能技术实现智能自动化。 从Postgres导出AI代理对话日志到Google Sheets
前置要求
- •PostgreSQL 数据库连接信息
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "f4f5d195bb2162a0972f737368404b18be694648d365d6c6771d7b4909d28167",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "0a03e403-4a72-4382-b648-602f4bd6ef87",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1720,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a421a477-bcee-460c-bc6a-8150a924fdd3",
"name": "添加created_at列",
"type": "n8n-nodes-base.postgres",
"position": [
-1640,
-100
],
"parameters": {
"query": "ALTER TABLE ONLY \"n8n_chat_histories\" ADD COLUMN \"created_at\" TIMESTAMP DEFAULT NOW();",
"options": {},
"operation": "executeQuery"
},
"credentials": {
"postgres": {
"id": "4E1voKcpNaIKnNJY",
"name": "PG - Chat Memory POC"
}
},
"typeVersion": 2.5
},
{
"id": "0cb5189e-857d-49a1-a8e9-923d4f955383",
"name": "按sessionId获取对话",
"type": "n8n-nodes-base.postgres",
"position": [
380,
480
],
"parameters": {
"table": {
"__rl": true,
"mode": "list",
"value": "n8n_chat_histories",
"cachedResultName": "n8n_chat_histories"
},
"where": {
"values": [
{
"value": "={{ $('Loop Over Session IDs').item.json.session_id }}",
"column": "session_id"
}
]
},
"schema": {
"__rl": true,
"mode": "name",
"value": "=public"
},
"options": {},
"operation": "select",
"returnAll": true
},
"credentials": {
"postgres": {
"id": "4E1voKcpNaIKnNJY",
"name": "PG - Chat Memory POC"
}
},
"executeOnce": false,
"typeVersion": 2.5
},
{
"id": "72d8c711-a3f9-4f95-b79a-a9190d2b4964",
"name": "复制模板工作表",
"type": "n8n-nodes-base.httpRequest",
"position": [
-400,
600
],
"parameters": {
"url": "=https://sheets.googleapis.com/v4/spreadsheets/{{ $('Clear Sheet Content').params.documentId.value }}/sheets/0:copyTo",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "predefinedCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "destinationSpreadsheetId",
"value": "={{ $('Clear Sheet Content').params.documentId.value }}"
}
]
},
"nodeCredentialType": "googleSheetsOAuth2Api"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ufBkeygvc1l17m5N",
"name": "Baptiste AS - Google Sheets account"
}
},
"typeVersion": 4.1
},
{
"id": "940fae1e-1ab7-4211-8d9f-fe5b9274e5e5",
"name": "清除工作表内容",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueErrorOutput",
"position": [
-760,
460
],
"parameters": {
"clear": "specificRange",
"range": "A2:C10000",
"operation": "clear",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $json.session_id }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "14bKI5J0h18Nv48jbe1IXpZWma6EtqYLFWnpKoCB5Bgc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/14bKI5J0h18Nv48jbe1IXpZWma6EtqYLFWnpKoCB5Bgc/edit?usp=drivesdk",
"cachedResultName": "Conversation logs"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ufBkeygvc1l17m5N",
"name": "Baptiste AS - Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "b16e85bc-a84b-4da0-85da-568a1c981e02",
"name": "重命名工作表",
"type": "n8n-nodes-base.httpRequest",
"position": [
-200,
600
],
"parameters": {
"url": "=https://sheets.googleapis.com/v4/spreadsheets/{{ $('Clear Sheet Content').params.documentId.value }}:batchUpdate",
"method": "POST",
"options": {},
"jsonBody": "={\n \"requests\": [{\n \"updateSheetProperties\": {\n \"properties\": {\n \"sheetId\": {{ $json.sheetId }},\n \"title\": \"{{ $('Clear Sheet Content').item.json.session_id }}\",\n \"hidden\": false\n },\n \"fields\": \"title, hidden\"\n }\n }]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleSheetsOAuth2Api"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ufBkeygvc1l17m5N",
"name": "Baptiste AS - Google Sheets account"
}
},
"typeVersion": 4.1
},
{
"id": "63ac37f4-1f80-4e5a-9af4-ec2e05cbaccb",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1720,
560
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 12
}
]
}
},
"typeVersion": 1.2
},
{
"id": "81cfed36-ee79-408f-8bad-0147a8acb0b3",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1740,
-480
],
"parameters": {
"color": 4,
"width": 320,
"height": 540,
"content": "## 添加日期时间列"
},
"typeVersion": 1
},
{
"id": "cecbaa6a-5d8b-4704-b249-bcd336875773",
"name": "设置session_id",
"type": "n8n-nodes-base.set",
"position": [
-20,
600
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3cc4ae1d-1693-4b30-9cbf-83fbb220813d",
"name": "session_id",
"type": "string",
"value": "={{ $('Clear Sheet Content').first().json.session_id }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "1f8b387b-52d0-4023-9d4b-4dd61272fe82",
"name": "Postgres - 获取会话ID",
"type": "n8n-nodes-base.postgres",
"position": [
-1380,
420
],
"parameters": {
"query": "select distinct(session_id) from n8n_chat_histories",
"options": {},
"operation": "executeQuery"
},
"credentials": {
"postgres": {
"id": "4E1voKcpNaIKnNJY",
"name": "PG - Chat Memory POC"
}
},
"typeVersion": 2.5
},
{
"id": "2ab2fc24-1c19-4c08-b20f-121bf22c6f9c",
"name": "循环遍历会话ID",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1060,
420
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "46763fb1-bf18-44a4-82b8-26e09325f159",
"name": "添加对话",
"type": "n8n-nodes-base.googleSheets",
"position": [
560,
640
],
"parameters": {
"columns": {
"value": {
"Who": "={{ $json.message.type }}",
"Date": "={{ $json.created_at.toDateTime().format('yyyy-MM-dd hh:mm:ss') }}",
"Message": "={{ $json.message.content }}"
},
"schema": [
{
"id": "Who",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Who",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": []
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Loop Over Session IDs').item.json.session_id }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "14bKI5J0h18Nv48jbe1IXpZWma6EtqYLFWnpKoCB5Bgc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/14bKI5J0h18Nv48jbe1IXpZWma6EtqYLFWnpKoCB5Bgc/edit?usp=drivesdk",
"cachedResultName": "Conversation logs"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ufBkeygvc1l17m5N",
"name": "Baptiste AS - Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "4b711779-938d-4a51-96dc-a3a629cfdcb3",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1400,
-480
],
"parameters": {
"color": 4,
"width": 360,
"height": 540,
"content": "## 对于Supabase用户"
},
"typeVersion": 1
},
{
"id": "2389393d-3e62-4349-a1cd-819d2b010f29",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1460,
140
],
"parameters": {
"color": 7,
"width": 280,
"height": 720,
"content": "## 获取所有会话"
},
"typeVersion": 1
},
{
"id": "eb323ee1-7afb-421d-86f4-02846782fb3e",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-500,
-620
],
"parameters": {
"color": 6,
"width": 440,
"height": 700,
"content": "## 重要 - 工作原理"
},
"typeVersion": 1
},
{
"id": "3ca21e1a-1c1c-4064-9e06-540aef692291",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1160,
140
],
"parameters": {
"color": 7,
"width": 280,
"height": 720,
"content": "## 循环遍历每个会话"
},
"typeVersion": 1
},
{
"id": "135eb659-31d5-4760-af09-938c3913bb6c",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1000,
-480
],
"parameters": {
"color": 4,
"width": 360,
"height": 540,
"content": "## Google Sheets模板"
},
"typeVersion": 1
},
{
"id": "6c329217-3f99-40bd-8ff5-57b2266f4012",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1780,
-620
],
"parameters": {
"color": 4,
"width": 1240,
"height": 700,
"content": "# 设置"
},
"typeVersion": 1
},
{
"id": "b06b11b7-e0c7-491c-b7ce-4e321187663c",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-860,
140
],
"parameters": {
"color": 7,
"width": 340,
"height": 720,
"content": "## 清除Google Sheets内容"
},
"typeVersion": 1
},
{
"id": "495026a8-4b3a-4ad8-8bf4-120cfa039a63",
"name": "### 替换 Airtable 连接",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
140
],
"parameters": {
"color": 7,
"width": 640,
"height": 720,
"content": "## 基于模板创建新的Google Sheet"
},
"typeVersion": 1
},
{
"id": "8eaba5f3-3455-43c0-bffa-6a0bbde39de7",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
140
],
"parameters": {
"color": 7,
"width": 620,
"height": 720,
"content": "## 在Google Sheets中存储转录稿"
},
"typeVersion": 1
},
{
"id": "6f802f26-e4b2-4787-bc0c-f3f800d79f74",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1800,
140
],
"parameters": {
"color": 7,
"width": 280,
"height": 720,
"content": "## Triggers\nTest it manually, then, once validated, create a scheduler for it to run hourly, daily, weekly... or even create an external trigger. \nYour choice!"
},
"typeVersion": 1
},
{
"id": "145ee4b6-d492-4533-83a0-2096aff97cca",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2740,
-620
],
"parameters": {
"color": 7,
"width": 860,
"height": 1480,
"content": "# Store n8n AI Agent Memory Logs in Google Sheets\n\n## Overview\nThis n8n workflow retrieves AI agent chat memory logs stored in Postgres and pushes them to Google Sheets, creating one sheet per session. It’s useful for teams building chat-based products or agents and needing to review or analyze session logs in a collaborative format.\n\n## Who is it for\n* Anyone with an AI Agent in Production storing the conversation logs in Postgres (or Supabase) who wants to see transcript and have control\n* Product teams building AI agents or assistants.\n* Teams that want to centralize conversation history for analysis or support.\n* Anyone managing AI chat memory and needing to explore it in a spreadsheet.\n\n## Prerequisites\n* A Postgres database with a `n8n_chat_histories` table with an AI Agent connected to it. If you need an example, you can follow [this tutorial](https://www.youtube.com/watch?v=JjBofKJnYIU)\n* Once done, you need to run the Postgresql query to add the `created_at` column (see Setup > Add a datetime column)\n* Google Sheets access and OAuth credentials connected to n8n.\n* A Google Sheets document set up as a template (see below).\n\n## Google Sheets Template\nThis workflow expects a Google Sheets file where each session will be stored in its own tab. \nA basic tab layout is duplicated and renamed with the session ID.\n👉 [Use this template as a starting point](https://docs.google.com/spreadsheets/d/14bKI5J0h18Nv48jbe1IXpZWma6EtqYLFWnpKoCB5Bgc/edit?usp=sharing)\nNote: You can hide the template after the first tabs have been created\n\n## How it works\n1. **Trigger**\n The workflow can be launched manually or on a schedule (e.g. daily at noon).\n\n2. **Retrieve sessions**\n Runs a SQL query to get distinct `session_id` values from the `n8n_chat_histories` table.\n\n3. **Loop over sessions**\nFor each session:\n * Clears the corresponding sheet (if it exists).\n * Duplicates the template tab.\n * Renames it with the current `session_id`.\n\n4. **Fetch messages**\n Selects all messages linked to the session from Postgres.\n\n5. **Append to sheet**\n Adds each message to the Google Sheet with columns:\n\n * **Who**: speaker role (`user`, `assistant`, etc.)\n * **Message**: text content\n * **Date**: timestamp from `created_at`, formatted `yyyy-MM-dd hh:mm:ss`\n\n## Notes\n* The sheet is **cleared and rebuilt** each run to ensure logs are up-to-date.\n* If a sheet for a session doesn’t exist, it will be created by duplicating the first tab (template)\n* You can group sessions under a persistent ID (like `user_id`) by overriding `session_id` in your memory config.\n* Works perfectly with Supabase by using PG credentials from the connection pooler.\n"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Rename Sheet": {
"main": [
[
{
"node": "Set session_id",
"type": "main",
"index": 0
}
]
]
},
"Set session_id": {
"main": [
[
{
"node": "Clear Sheet Content",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Postgres - Get session ids",
"type": "main",
"index": 0
}
]
]
},
"Add conversations": {
"main": [
[
{
"node": "Loop Over Session IDs",
"type": "main",
"index": 0
}
]
]
},
"Clear Sheet Content": {
"main": [
[
{
"node": "Get conversations by sessionId",
"type": "main",
"index": 0
}
],
[
{
"node": "Duplicate template sheet",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Session IDs": {
"main": [
[],
[
{
"node": "Clear Sheet Content",
"type": "main",
"index": 0
}
]
]
},
"Duplicate template sheet": {
"main": [
[
{
"node": "Rename Sheet",
"type": "main",
"index": 0
}
]
]
},
"Postgres - Get session ids": {
"main": [
[
{
"node": "Loop Over Session IDs",
"type": "main",
"index": 0
}
]
]
},
"Get conversations by sessionId": {
"main": [
[
{
"node": "Add conversations",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Postgres - Get session ids",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 工程, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
API架构提取器
API架构提取器
If
Set
Code
+22
88 节点Polina Medvedieva
工程
AI生成的WordPress文章摘要块
WordPress文章的AI生成摘要块
If
Set
Slack
+14
32 节点Dataki
人工智能
电话销售循环
AI驱动电话销售自动化，集成Vapi.ai、GPT-4o和Google Sheets
If
Set
Wait
+8
38 节点Amit Mehta
销售
使用Bright Data和LLMs自动化大规模超个性化外联
通过Bright Data和大语言模型实现大规模超个性化外联自动化
If
Set
Wait
+8
21 节点Yaron Been
销售
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
If
Set
Sort
+15
44 节点PollupAI
销售
多URL自动监控与宕机警报
多URL自动监控与宕机警报
Set
Code
Gmail
+8
18 节点Oriol Seguí
人工智能
工作流信息
难度等级
高级
节点数量23
分类2
节点类型8
作者
Agent Studio
@agentstudioWe are a product studio that helps organizations leverage no-code and generative AI to automate internal processes and launch new digital products. LinkedIn: https://www.linkedin.com/in/baptistej/
外部链接
在 n8n.io 查看 →
分享此工作流