wowprompt

Multilingual customer review translation with sentiment tags

Translates product reviews and feedback written in Hindi, Hinglish, Tamil, Bengali or any language into clear English, keeping tone and sarcasm, then tags each one by sentiment, topic and urgency so the team can act on them. Use it after a festive sale when reviews pour in from many regions, or monthly for any store or app.

A table of reviews with the original, an English translation, sentiment, topic and urgency, a summary of themes by language, and reviews that need a reply
The output this prompt produced, unedited.

The prompt

What to give

  • Reviews: [paste rows: review ID, rating, text, date, product]
  • Product or service: [e.g. a sweets and snacks brand selling online]
  • Topics to tag: [e.g. taste, freshness, packaging, delivery time, price, quantity, support]
  • What counts as urgent: [e.g. health complaints, foreign objects, damaged seal, abuse of staff]

Check every review

  1. The translation keeps the reviewer's tone, including sarcasm, mixed feelings and regional expressions.
  2. Brand names, product names and quantities stay as written.
  3. Words with no clear English match keep the original word in brackets.
  4. Sentiment follows the text, not just the star rating; flag reviews where they disagree.
  5. Every review gets one main topic and at most two more.
  6. Urgent reviews are marked whatever their rating.

Output format

  1. | Review ID | Language | Original | English translation | Sentiment: positive, mixed, negative | Topics | Urgent: yes or no |
  2. Themes: the five most common topics with counts and one translated quote each.
  3. Differences by language or region, if any appear, stated as observations only.
  4. Reviews needing a reply, with a one-line reason.
  5. Phrases the translation was unsure about, with two possible meanings.

Example

Original: "Mithai toh badhiya thi par dabba aadha khaali laga, 500 gram ke paise mein." English: "The sweets were great, but the box felt half empty for the price of 500 grams." Sentiment: mixed. Topics: taste, quantity, price. Urgent: no.

Guardrails

  • Translate only; never soften or sharpen what the reviewer said.
  • Remove phone numbers, addresses and names of staff from the output.
  • Counts cover only the reviews pasted; state the total.
review translationmultilingual reviewssentiment analysiscustomer feedback translationhinglish to englishreview tagging

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity