Process Inquiries with AI and Log Results to Spreadsheets
Workflow Description
An automation workflow that receives user inquiries through a chat interface, processes them using OpenAI language models, and automatically records responses and extracted data in Google Sheets for easy tracking and efficient analysis.
How it works
- 1.Activate chat trigger and receive user question
- 2.Process text through LLM chain and send to OpenAI
- 3.Retrieve response and extracted data from the model
- 4.Transform and format results as needed
- 5.Record inquiry and response in Google Sheets
Use cases
- Build an intelligent customer support system that auto-documents every interaction
- Collect user inquiry data and analyze trends systematically
- Automate responses to frequent questions while maintaining logs
Requirements
- Valid OpenAI API key with appropriate permissions
- Google account with edit access to spreadsheets
- Pre-configured Google Sheets with proper column headers
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (21)
Sticky Note
Sticky Note
Get Models
HTTP Request
Sticky Note1
Sticky Note
When chat message received
Chat Trigger
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Get timeDifference
Date Time
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Run Model with Dunamic Inputs
OpenAI
Analyze LLM Response Metrics
Code
Save Results to Google Sheets
Google Sheets
Capture End Time
Date Time
Capture Start Time
Date Time
Prepare Data for Analysis
Set
Extract Model IDsto Run Separately
Split Out
Sticky Note7
Sticky Note
Add System Prompt
Set
LLM Response Analysis
LLM Chain
Sticky Note8
Sticky Note