Export AI Agent Conversation Logs from Postgres to Google Sheets

This n8n workflow automates the export of AI agent conversation histories stored in a Postgres database (like Supabase) to Google Sheets. It queries distinct session IDs from the n8n_chat_histories table, loops through each session to fetch detailed logs, and creates or updates a dedicated sheet tab per session in a predefined Google Sheets template. This enables collaborative analysis of chat transcripts without manual data handling.

Key benefits include centralized log access for product teams, support staff, and analysts; time savings on data export; and scalability for high-volume AI interactions. It supports scheduled runs (e.g., daily) or manual triggers, ensuring fresh data availability. Prerequisites are a Postgres DB with chat history table (add created_at column), Google Sheets OAuth in n8n, and a template spreadsheet.

Use cases: Review customer support sessions for agent improvements; analyze user engagement patterns in AI assistants; audit conversations for compliance; or share insights with non-technical stakeholders via familiar Sheets interface. Perfect for AI product teams transitioning from dev to production monitoring.