agent-image-lead-qualification-assistant
Japanese-to-English Review Sentiment Analysis with GPT and Telegram Alerts
Who is this for This template is designed for e-commerce businesses, customer support teams, and marketing professionals who need to monitor and analyze...
screenshot-daily-task-reminder-bot
Created by:
Asuka
Last Updated:

June 15th 2025

Agent Details:
n8n
OpenAI
general
Google Sheets
If
Edit Fields (Set)
Description
Who is this for This template is designed for e-commerce businesses, customer support teams, and marketing professionals who need to monitor and analyze customer reviews at scale. It's especially useful for teams dealing with multilingual reviews (Japanese to English) and those who want instant alerts for critical feedback. What it does This workflow automatically processes customer reviews stored in Google Sheets using OpenAI GPT. For each review, it performs: Translation from Japanese to English Sentiment analysis with a score from -1.0 to +1.0 Importance classification (High/Medium/Low) based on urgency Category tagging (Quality, Price, Shipping, Support, Features, Usability, Other) Key phrase extraction for quick summary Results are written back to the spreadsheet, and Telegram notifications are sent based on priority level. How to set up Connect your Google Sheets account and select your review spreadsheet Configure OpenAI API credentials Set up Telegram Bot and enter your Chat ID in both notification nodes Adjust the schedule trigger interval as needed Requirements Google Sheets with columns: ReviewID, Keyword (review text), ProcessStatus OpenAI API key Telegram Bot Token and Chat ID How to customize Modify the AI prompt in "AI Agent - Review Analysis" to change analysis criteria or add new fields Adjust the sentiment threshold (-0.5) in "Check Importance & Sentiment" node Customize notification messages in Telegram nodes Change the source/target language by editing the prompt

Build Dynamic AI Agents

Join a community of growing Agentic AI Developers.