Classify the sentiment of tickets
Bulk data processingHardWhole-set scoringLatest run
Passed by 5 of 12 products on their best model: Autosheet in Excel, Autosheet in Sheets, Claude Code + Sheets MCP, Claude Code + Autosheet MCP and ChatGPT + Autosheet MCP.
Prompt
Analyze the sentiment of each ticket in column D (
body). Add a new column with the headersentimentin column G. The value must be exactly one of: - Positive - Negative - Neutral No row may be blank.
Starting spreadsheet
Sheet1 · rows 1–21 of 1,001| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m writing to request the cancellation of the auto-renewal for my GPT for Work subscription associated with order HB70… | high | Pending, |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regarding the GPT for Work add-on associated with my account, order reference KL826. For the past week, the add-on has be… | HIGH | Awaiting action |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m reaching out regarding the auto-renewal for my GPT for Work add-on. I’d like to request a cancellation of the auto-… | p2 | In queue |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy gestionando la facturación de GPT for Work para mi empresa y requiero revisar un cargo reciente que parece duplicad… | High priority | Awaiting resolution. |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m reaching out with a general inquiry about an add-on for GPT for Work that I recently started exploring. My goal is … | med | In progress |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cliente relata um erro persistente relacionado ao add-on do GPT for Work adquirido sob o pedido HQ191. Apesar de ter s… | LOW | Closed |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a recent billing concern related to GPT for Work tied to order HY329. They requested to cancel auto-renewal and sought cla… | p2 | Successfully concluded. |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق الدعم. موضوع التذكرة: Billing / Auto renewal cancel المرجِع: CP527 الوصف: أواجه مشكلة في إيقاف التجديد التلقائي لخدمة … | High priority | In review. |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处理我的 Add-on 订阅时遇到希望取消自动续订的需求。根据我的理解,该 Add-on 课程的自动续订在下月将再次扣费,但我希望暂停或取消未来的自动续订以避免额外支出。请以此邮件作为正式请求,确保从本次账单开始停止自动续订,并尽快出… | med | Awaiting resolution |
| 11 | 18245 | …@example.com | 2026-08-28 04:01 | أقدر فريق الدعم الموقر، أود الحصول على مساعدة متعمقة حول حالات الاستخدام الممكنة لـ GPT للجهات العاملة داخل شركتنا. نحن نعتمد على منصة GPT … | MEDIUM | Referred upward. |
| 12 | 18260 | …@example.com | 2026-08-28 03:01 | Hello Support Team, I’m reaching out regarding my GPT for Work subscription, specifically related to add-ons and how settings are managed w… | p3 | In progress |
| 13 | 18283 | …@example.com | 2026-08-28 01:58 | أكتب إليكم بشأن فاتورة وخدمة GPT for Work المرتبطة بالطلب HL245. بشكل عام أنا راضٍ عن النتائج التي نحصل عليها من النظام، لكن أواجه مسألة فو… | Low priority | No further action required |
| 14 | 18238 | …@example.com | 2026-08-28 01:45 | Descrição do problema: Somos usuários da ferramenta GPT for Work integrando o módulo de Use-case Help / Agent / Other em nosso fluxo de ate… | high | Awaiting resolution, |
| 15 | 18281 | …@example.com | 2026-08-28 01:41 | Bonjour, l’équipe billing. Je vous écris pour une vérification concernant la facturation liée à GPT for Work associée à ma commande RT384. … | LOW | In progress. |
| 16 | 18280 | N/A | 2026-08-28 01:36 | 你好,我们在使用 GPT for Work 的产品时遇到了与“附加组件”相关的持续性错误,具体表现为无法成功安装或启用所购买的附加组件。该问题始终在试图添加新插件时触发,界面显示错误消息,但没有给出可操作的解决方案,导致团队无法利用该附加插件提升工作流效率。 影响与业务影响 -… | p2 | Closed |
| 17 | 18282 | …@example.com | 2026-08-28 01:32 | Resumen del problema: El cliente solicita asistencia con un tema de facturación relacionado con el servicio GPT para Work. Aunque la priori… | Low priority | Awaiting resolution |
| 18 | 18203 | …@example.com | 2026-08-27 23:02 | Bonjour l’équipe Support, Je vous écris au sujet de l’addon GPT for Work que j’ai récemment acquis sous la référence de commande AL750. Tou… | low | Yet to commence, |
| 19 | 18204 | …@example.com | 2026-08-27 22:02 | I’m reaching out regarding some recurring mistakes I’ve observed while using GPT for Work, and I’d like to understand what support options … | LOW | Closed. |
| 20 | 18140 | …@example.com | 2026-08-27 22:02 | Ticket formatado com dados solicitados; informado o contexto, impacto, exemplos e resolução desejada. | p3 | Resolved |
| 21 | 18138 | …@example.com | 2026-08-27 22:02 | Description du problème: Le client a remarqué que son pack associé à son compte a expiré, ce qui a temporairement bloqué certaines fonction… | Low priority | In progress |
A passing output
Autosheet in Excel · Opus 5.5| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
Pass criteria
Each must be met on at least 98% of rows.G2:G1001, headed "sentiment": filled with "Positive", "Negative" or "Neutral", matching each row's reviewed reference
Passed 9
Autosheet in Excel Opus 5.5 · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
Autosheet in Excel GPT-6 Astra · Low
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
Autosheet in Sheets Opus 5.5 · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
Autosheet in Excel Sonnet 5.5 · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Neutral |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Negative |
10 of 1,001 rows
Claude Code + Sheets MCP Opus 5.5 · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Neutral |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
Autosheet in Excel GPT-6.1 Sol · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
Claude Code + Autosheet MCP Opus 5.5 · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
ChatGPT + Autosheet MCP GPT-6 · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Neutral |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
Autosheet in Excel GPT-6 Luna · High
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
Failed 13
Claude in Excel Opus 5.5 · High
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Neutral |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Neutral |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
| 29 | 18278 | …@example.com | 2026-08-27 19:07 | I am reaching out as a … | Low priority | Moved to a higher tier. | Neutral |
| 31 | 18276 | …@example.com | 2026-08-27 19:05 | Estimado equipo de sopo… | LOW | In queue, | Neutral |
| 43 | 18268 | N/A | 2026-08-27 15:27 | Prezado suporte, Gostar… | LOW | Not started | Neutral |
| 49 | 18265 | …@example.com | 2026-08-27 13:24 | Bonjour l’équipe, Je vo… | Low priority | In queue | Neutral |
14 of 1,001 rows
Why it failed: 89 cells didn't match the expected sentiment.
- Row 160 · Source
…The unexpected billing creates budget uncertainty for our department and undermines trust in the transparency of the billing process.
- Written
- Neutral
- Expected
- Negative
- Row 228 · Source
…A general sense of frustration given the perceived clerical error.
- Written
- Neutral
- Expected
- Negative
Autosheet in Excel Haiku 5.5 · High
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
10 of 1,001 rows
Why it failed: 23 cells didn't match the expected sentiment.
- Row 978 · Source
Procurement needs a quote for forty annual seats with centralized billing.
- Written
- Negative
- Expected
- Neutral
- Row 992 · Source
Finance wants separate invoices for two departments using the same workspace.
- Written
- Negative
- Expected
- Neutral
Claude in Sheets Opus 5.5 · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Neutral |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
| 27 | 18207 | …@example.com | 2026-08-27 21:02 | Bonjour, Je vous contac… | LOW | Resolved | Neutral |
| 31 | 18276 | …@example.com | 2026-08-27 19:05 | Estimado equipo de sopo… | LOW | In queue, | Neutral |
| 43 | 18268 | N/A | 2026-08-27 15:27 | Prezado suporte, Gostar… | LOW | Not started | Neutral |
13 of 1,001 rows
Why it failed: 163 cells didn't match the expected sentiment.
- Row 100 · Source
I’m reaching out regarding a recent billing note tied to the GPT for Work service, linked to the order BE943. Our team has been reviewing a recent invoice that…
- Written
- Neutral
- Expected
- Negative
- Row 101 · Source
I’m writing to report a billing-related issue associated with my GPT for Work subscription tied to order IR640. The primary concern is an unexpected…
- Written
- Neutral
- Expected
- Negative
Autosheet in Sheets Haiku 5.5 · High
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
| 30 | 18277 | …@example.com | 2026-08-27 19:06 | 您好,基于我们企业在日常工作流中对GPT fo… | med | Yet to commence. | Negative |
11 of 1,001 rows
Why it failed: 38 cells didn't match the expected sentiment.
- Row 501 · Source
尊敬的支持团队, 我正在为我的团队使用的 GPT for Work 产品提交一个关于信用转移的用例请求。背景是,我们的组织在不同项目之间需要将一定数量的系统使用信用在账户之间进行转移,以便更高效地分配资源和优化预算。当前流程看起来过于繁琐,且缺乏清晰的转移步骤,导致一些小额信用在跨团队使用时被错过或延迟释放。…
- Written
- Negative
- Expected
- Neutral
- Row 94 · Source
尊敬的客服团队: 您好!我在贵平台使用 GPT for Work 的过程中,遇到一次与账单相关的常规咨询,想请您协助确认和澄清。我的账户最近完成了数个按用量计费的操作,但我发现发票上的某些条目与我预期的用途并不完全一致,具体情况如下:第一笔月度结算中,某些功能调用计费与公开的价格表略有偏差,第二笔则显示了额外的试用期优…
- Written
- Negative
- Expected
- Neutral
ChatGPT in Excel GPT-6 Astra · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Positive |
10 of 1,001 rows
Why it failed: 41 cells didn't match the expected sentiment.
- Row 575 · Source
…I was charged for a plan tier or feature that does not align with what I signed up for, and I would like to understand the discrepancy and, if applicable, request a refund for the overcharged amount.
- Written
- Positive
- Expected
- Negative or Neutral
- Row 439 · Source
Hello Team, I’m writing to formally request the deletion of all personal data associated with my account and with the use of GPT for Work under my order reference EU101.
- Written
- Positive
- Expected
- Neutral
Claude in Excel Haiku 5.5 · High
G2=IF(SUMPRODUCT(--ISNUMBER(SEARCH(Pos_Terms,D2)))>SUMPRODUCT(--ISNUMBER(SEARCH(Neg_Terms,D2))),"Positive",IF(SUMPRODUCT(--ISNUMBER(SEARCH(Neg_Terms,D2)))>SUMPRODUCT(--ISNUMBER(SEARCH(Pos_Terms,D2))),"Negative","Neutral"))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Negative |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Neutral |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Negative |
| 24 | 18216 | N/A | 2026-08-27 21:02 | O cliente fica grato pe… | p1 | Resolved | Neutral |
| 36 | 18241 | …@example.com | 2026-08-27 19:02 | I’m reaching out with a… | p3 | Escalated | Negative |
| 37 | 18272 | …@example.com | 2026-08-27 19:01 | Bonjour l’équipe, et me… | Medium priority | Awaiting intiation | Negative |
| 41 | 18257 | …@example.com | 2026-08-27 18:02 | Customer reports a requ… | Low priority | Referred upward | Negative |
| 44 | 18184 | …@example.com | 2026-08-27 15:14 | تفصيل المشكلة والسبب: ا… | p2 | Successfully concluded, | Negative |
15 of 1,001 rows
Why it failed: 143 cells didn't match the expected sentiment.
- Row 41 · Source
Customer reports a request related to admin-level credit management for GPT for Work under their organization. They reference the order OD368 and seek guidance…
- Written
- Negative
- Expected
- Neutral
- Row 94 · Source
尊敬的客服团队: 您好!我在贵平台使用 GPT for Work 的过程中,遇到一次与账单相关的常规咨询,想请您协助确认和澄清。我的账户最近完成了数个按用量计费的操作,但我发现发票上的某些条目与我预期的用途并不完全一致,具体情况如下:第一笔月度结算中,某些功能调用计费与公开的价格表略有偏差,第二笔则显示了额外的试用期优…
- Written
- Negative
- Expected
- Neutral
Claude in Sheets Haiku 5.5 · High
G2=LET(p,SUMPRODUCT(('Sentiment Lexicon'!$A$2:$A$200<>"")*ISNUMBER(SEARCH('Sentiment Lexicon'!$A$2:$A$200,D2))),n,SUMPRODUCT(('Sentiment Lexicon'!$B$2:$B$200<>"")*ISNUMBER(SEARCH('Sentiment Lexicon'!$B$2:$B$200,D2))),IF(p>n,"Positive",IF(n>p,"Negative","Neutral")))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Neutral |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Neutral |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
| 24 | 18216 | N/A | 2026-08-27 21:02 | O cliente fica grato pe… | p1 | Resolved | Neutral |
| 27 | 18207 | …@example.com | 2026-08-27 21:02 | Bonjour, Je vous contac… | LOW | Resolved | Neutral |
| 37 | 18272 | …@example.com | 2026-08-27 19:01 | Bonjour l’équipe, et me… | Medium priority | Awaiting intiation | Negative |
| 41 | 18257 | …@example.com | 2026-08-27 18:02 | Customer reports a requ… | Low priority | Referred upward | Negative |
| 44 | 18184 | …@example.com | 2026-08-27 15:14 | تفصيل المشكلة والسبب: ا… | p2 | Successfully concluded, | Negative |
15 of 1,001 rows
Why it failed: 136 cells didn't match the expected sentiment.
- Row 160 · Source
…The unexpected billing creates budget uncertainty for our department and undermines trust in the transparency of the billing process.
- Written
- Neutral
- Expected
- Negative
- Row 175 · Source
Hello Support Team, I’m reaching out regarding a billing issue tied to my GPT for Work subscription, linked to order ID UL861. Despite already onboarding and…
- Written
- Neutral
- Expected
- Negative
Copilot in Excel Auto
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Positive |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Negative |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Neutral |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
| 12 | 18260 | …@example.com | 2026-08-28 03:01 | Hello Support Team, I’m… | p3 | In progress | Positive |
| 18 | 18203 | …@example.com | 2026-08-27 23:02 | Bonjour l’équipe Suppor… | low | Yet to commence, | Negative |
| 23 | 18214 | N/A | 2026-08-27 22:02 | مرحباً فريق الدعم، أواج… | MEDIUM | Awaiting action. | Neutral |
| 24 | 18216 | N/A | 2026-08-27 21:02 | O cliente fica grato pe… | p1 | Resolved | Neutral |
| 31 | 18276 | …@example.com | 2026-08-27 19:05 | Estimado equipo de sopo… | LOW | In queue, | Neutral |
15 of 1,001 rows
Why it failed: 148 cells didn't match the expected sentiment.
- Row 6 · Source
Hello Support Team, I’m reaching out with a general inquiry about an add-on for GPT for Work that I recently started exploring. My goal is to understand how…
- Written
- Positive
- Expected
- Neutral
- Row 12 · Source
Hello Support Team, I’m reaching out regarding my GPT for Work subscription, specifically related to add-ons and how settings are managed within my account…
- Written
- Positive
- Expected
- Negative or Neutral
ChatGPT + Drive MCP GPT-6 · Medium
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Neutral |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Negative |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Negative |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Negative |
| 30 | 18277 | …@example.com | 2026-08-27 19:06 | 您好,基于我们企业在日常工作流中对GPT fo… | med | Yet to commence. | Negative |
| 36 | 18241 | …@example.com | 2026-08-27 19:02 | I’m reaching out with a… | p3 | Escalated | Negative |
| 41 | 18257 | …@example.com | 2026-08-27 18:02 | Customer reports a requ… | Low priority | Referred upward | Negative |
| 44 | 18184 | …@example.com | 2026-08-27 15:14 | تفصيل المشكلة والسبب: ا… | p2 | Successfully concluded, | Negative |
| 45 | 18269 | N/A | 2026-08-27 15:14 | مرحبا فريق الدعم، أود ا… | Low priority | In progress. | Neutral |
15 of 1,001 rows
Why it failed: 148 cells didn't match the expected sentiment.
- Row 41 · Source
Customer reports a request related to admin-level credit management for GPT for Work under their organization. They reference the order OD368 and seek guidance…
- Written
- Negative
- Expected
- Neutral
- Row 45 · Source
مرحبا فريق الدعم، أود التعبير عن تقديري للخدمات المقدمة حتى الآن وأرغب في اقتراح ميزة إضافية قد تُحسن من تجربة فريقي بشكل كبير فيما يخص الفوترة وخدمات GPT for…
- Written
- Neutral
- Expected
- Positive
ChatGPT in Excel GPT-6 Luna · High
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Positive |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Positive |
| 11 | 18245 | …@example.com | 2026-08-28 04:01 | أقدر فريق الدعم الموقر،… | MEDIUM | Referred upward. | Negative |
| 18 | 18203 | …@example.com | 2026-08-27 23:02 | Bonjour l’équipe Suppor… | low | Yet to commence, | Negative |
| 41 | 18257 | …@example.com | 2026-08-27 18:02 | Customer reports a requ… | Low priority | Referred upward | Negative |
| 44 | 18184 | …@example.com | 2026-08-27 15:14 | تفصيل المشكلة والسبب: ا… | p2 | Successfully concluded, | Negative |
| 45 | 18269 | N/A | 2026-08-27 15:14 | مرحبا فريق الدعم، أود ا… | Low priority | In progress. | Neutral |
15 of 1,001 rows
Why it failed: 125 cells didn't match the expected sentiment.
- Row 160 · Source
…The unexpected billing creates budget uncertainty for our department and undermines trust in the transparency of the billing process.
- Written
- Neutral
- Expected
- Negative
- Row 41 · Source
Customer reports a request related to admin-level credit management for GPT for Work under their organization. They reference the order OD368 and seek guidance…
- Written
- Negative
- Expected
- Neutral
Gemini in Sheets Auto
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | |
| 11 | 18245 | …@example.com | 2026-08-28 04:01 | أقدر فريق الدعم الموقر،… | MEDIUM | Referred upward. | |
| 12 | 18260 | …@example.com | 2026-08-28 03:01 | Hello Support Team, I’m… | p3 | In progress | |
| 13 | 18283 | …@example.com | 2026-08-28 01:58 | أكتب إليكم بشأن فاتورة … | Low priority | No further action requi… | |
| 14 | 18238 | …@example.com | 2026-08-28 01:45 | Descrição do problema: … | high | Awaiting resolution, | |
| 15 | 18281 | …@example.com | 2026-08-28 01:41 | Bonjour, l’équipe billi… | LOW | In progress. |
15 of 1,001 rows
Why it failed: All cells were left empty.
ChatGPT in Sheets GPT-6 Astra · Medium
G47=LET(txt,LOWER(D47),intro,LEFT(txt,800),ending,RIGHT(txt,650),neutralTone,SUMPRODUCT(--ISNUMBER(SEARCH({"neutral tone","tone is neutral","tom neutro","tono neutro","ton neutre","نبرة محايدة","语气中性","中立语气","sentiment: neutral","sentimento: neutro"},txt)))>0,positiveTone,SUMPRODUCT(--ISNUMBER(SEARCH({"positive tone","tone is positive","positive follow-up","experience has been positive","experience remains positive","ton positif","globalement positive","tonalité positive","tonalidade é positiva","atitude positiva","actitud positiva","sentimento: positivo","sentiment: positive","tono positivo","整体体验良好","整體體驗仍然正向","تجربة إيجابية","نبرة إيجابية"},txt)))>0,negativeTone,SUMPRODUCT(--ISNUMBER(SEARCH({"sentiment: negative","sentimento: negativo","tono negativo","tom negativo","negative tone","ton négatif"},txt)))>0,negative,SUMPRODUCT(--ISNUMBER(SEARCH({"frustrat","disappoint","unacceptable","unreliable","dissatisfied","not satisfied","not happy","poor experience","underwhelming","counterproduc…
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Positive |
| 47 | 18255 | …@example.com | 2026-08-27 14:02 | Hello Support Team, I’m… | LOW | Pending kickoff | Neutral |
11 of 1,007 rows
Why it failed: 70 cells didn't match the expected sentiment.
- Row 160 · Source
…The unexpected billing creates budget uncertainty for our department and undermines trust in the transparency of the billing process.
- Written
- Neutral
- Expected
- Negative
- Row 281 · Source
We are requesting an immediate data deletion in relation to GPT for Work for our organization, referenced by order YV208. This is a legally driven data…
- Written
- Neutral
- Expected
- Negative
ChatGPT in Sheets GPT-6 Luna · High
G2=IF(OR(ISNUMBER(SEARCH("frustrat",D2)),ISNUMBER(SEARCH("disappoint",D2)),ISNUMBER(SEARCH("unreliable",D2)),ISNUMBER(SEARCH("error",D2)),ISNUMBER(SEARCH("fail",D2)),ISNUMBER(SEARCH("timeout",D2)),ISNUMBER(SEARCH("incorrect",D2)),ISNUMBER(SEARCH("inaccurac",D2)),ISNUMBER(SEARCH("mistake",D2)),ISNUMBER(SEARCH("inconsistent",D2)),ISNUMBER(SEARCH("blocked",D2)),ISNUMBER(SEARCH("unable",D2)),ISNUMBER(SEARCH("cannot",D2)),ISNUMBER(SEARCH("duplicate",D2)),ISNUMBER(SEARCH("overcharg",D2)),ISNUMBER(SEARCH("dissatisf",D2)),ISNUMBER(SEARCH("complaint",D2)),ISNUMBER(SEARCH("problem",D2)),ISNUMBER(SEARCH("discrep",D2)),ISNUMBER(SEARCH("frustr",D2)),ISNUMBER(SEARCH("fallo",D2)),ISNUMBER(SEARCH("problema",D2)),ISNUMBER(SEARCH("decepcion",D2)),ISNUMBER(SEARCH("erreur",D2)),ISNUMBER(SEARCH("problème",D2)),ISNUMBER(SEARCH("décev",D2)),ISNUMBER(SEARCH("échec",D2)),ISNUMBER(SEARCH("falha",D2)),ISNUMBER(SEARCH("atras",D2)),ISNUMBER(SEARCH("incorreto",D2)),ISNUMBER(SEARCH("preocup",D2)),ISNUMBER(SEARCH("cob…
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | sentiment |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | Positive |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | Negative |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | Positive |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | Negative |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Neutral |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | Negative |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | Positive |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Negative |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | Neutral |
| 12 | 18260 | …@example.com | 2026-08-28 03:01 | Hello Support Team, I’m… | p3 | In progress | Positive |
| 24 | 18216 | N/A | 2026-08-27 21:02 | O cliente fica grato pe… | p1 | Resolved | Neutral |
| 27 | 18207 | …@example.com | 2026-08-27 21:02 | Bonjour, Je vous contac… | LOW | Resolved | Neutral |
| 41 | 18257 | …@example.com | 2026-08-27 18:02 | Customer reports a requ… | Low priority | Referred upward | Negative |
| 44 | 18184 | …@example.com | 2026-08-27 15:14 | تفصيل المشكلة والسبب: ا… | p2 | Successfully concluded, | Negative |
15 of 1,001 rows
Why it failed: 120 cells didn't match the expected sentiment.
- Row 160 · Source
…The unexpected billing creates budget uncertainty for our department and undermines trust in the transparency of the billing process.
- Written
- Neutral
- Expected
- Negative
- Row 12 · Source
Hello Support Team, I’m reaching out regarding my GPT for Work subscription, specifically related to add-ons and how settings are managed within my account…
- Written
- Positive
- Expected
- Negative or Neutral