Log Interactions to Postgres

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "name": "Interaction Logging Workflow",
  "nodes": [
    {
      "parameters": {},
      "id": "m3n4o5p6-q7r8-9012-mnop-321234567802",
      "name": "Execute Workflow Trigger",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "typeVersion": 1,
      "position": [
        240,
        300
      ]
    },
    {
      "parameters": {
        "operation": "insert",
        "schema": {
          "__rl": true,
          "value": "public",
          "mode": "list"
        },
        "table": {
          "__rl": true,
          "value": "voice_interactions",
          "mode": "list"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "interaction_id": "={{ $json.interactionId }}",
            "session_id": "={{ $json.sessionId }}",
            "user_input": "={{ $json.userInput }}",
            "ai_response": "={{ $json.aiResponse }}",
            "processing_time": "={{ $json.processingTime }}",
            "audio_format": "={{ $json.audioFormat }}",
            "audio_size": "={{ $json.audioSize }}",
            "created_at": "={{ $json.timestamp }}"
          }
        }
      },
      "id": "n4o5p6q7-r8s9-0123-nopq-432234567803",
      "name": "Insert Interaction Record",
      "type": "n8n-nodes-base.postgres",
      "typeVersion": 2.5,
      "position": [
        460,
        300
      ],
      "credentials": {
        "postgres": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "mode": "manual",
        "fields": {
          "values": [
            {
              "name": "log_status",
              "stringValue": "success"
            },
            {
              "name": "record_id",
              "numberValue": "={{ $json.id }}"
            },
            {
              "name": "timestamp",
              "stringValue": "={{ new Date().toISOString() }}"
            }
          ]
        }
      },
      "id": "o5p6q7r8-s9t0-1234-opqr-543234567804",
      "name": "Format Log Response",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        680,
        300
      ]
    }
  ],
  "connections": {
    "Execute Workflow Trigger": {
      "main": [
        [
          {
            "node": "Insert Interaction Record",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Insert Interaction Record": {
      "main": [
        [
          {
            "node": "Format Log Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "staticData": null,
  "tags": [],
  "triggerCount": 1,
  "updatedAt": "2025-06-25T00:00:00.000Z",
  "versionId": "1"
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• postgres

About this workflow

Interaction Logging Workflow. Uses executeWorkflowTrigger, postgres. Event-driven trigger; 3 nodes.

Source: https://github.com/161sam/n8n-voice-ai/blob/31a1dcdae2a2e19ef0e680ff0aa52c9c1e4a7c3b/workflows/Logging.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.