Analyze and classify Google Sheets data with AI intelligence
Workflow Description
Automates analysis of Google Sheets rows using OpenAI models to classify content, detect sentiment, and extract key information. Results are automatically written back to the spreadsheet, enabling large-scale data processing without manual intervention.
How it works
- 1.Trigger the automation manually or via scheduled event
- 2.Extract and split Google Sheets rows for parallel processing
- 3.Send each row to OpenAI for content analysis and information extraction
- 4.Apply sentiment analysis to detect emotional tone in text
- 5.Update the spreadsheet with analysis results and classifications
Use cases
- Automatically analyze customer feedback and survey responses for sentiment
- Classify emails and text data by priority, category, or sentiment
- Extract structured information from unstructured data in bulk
- Generate automated summaries for large spreadsheet datasets
Requirements
- Active OpenAI account with valid API key
- Google Sheets spreadsheet with data ready for analysis
- Read and write access permissions on the target sheet
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 (16)
Split Out
Split Out
OpenAI Chat Model
OpenAI
No Operation, do nothing
No Op
Get Video Urls from Google Sheet
Google Sheets
check next fetch time is available or not
If
check next fetch time is before the current time
If
Get Comments for video urls
HTTP Request
Analyze sentiment of every comment
Sentiment Analysis
Format fields as required to save in google sheet
Set
Insert and update comment in google sheet
Google Sheets
Update last fetched time and next_fetch_time
Google Sheets
No Operation, do nothing1
No Op
When clicking ‘Test workflow’
Manual Trigger
Sticky Note1
Sticky Note
Check Success Response
If
Sticky Note2
Sticky Note