Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Reports, Analytics & Dashboards

Reports, Analytics & Dashboards

Export AI Agent Chat Logs from Postgres to Sheets

When you run it or on a schedule, it reads conversations by session from Postgres and writes them into a fresh Google Sheets copy.

Import it free Sign in to open it

What it does

## Add a datetime column If not already done, add a created_at column to store the datetime of the message 👉 Ideally, do it before your first interaction, otherwise all your previous conversations will be set as the time of the execution of this node. 💡 Replace the name of your chat memory before executing the request The table schema will at least contain the following fields: session_id, message.content, message.type, and created_at

The steps

  1. When clicking ‘Test workflow’
  2. add create_at column
  3. Get conversations by sessionId
  4. Duplicate template sheet
  5. Clear Sheet Content
  6. Rename Sheet
  7. Schedule Trigger
  8. Set session_id
  9. Postgres - Get session ids
  10. Loop Over Session IDs
  11. Add conversations

Similar automations

Data Sync & ETLExport a PostgreSQL Table to a CSV File4 stepsData Sync & ETLExport a PostgreSQL Table to a CSV File6 stepsData Sync & ETLExport Postgres Query Results to a Spreadsheet File5 stepsAI Agents & AssistantsChat with Search Console Data Using OpenAI and Postgres16 steps