Extract order IDs from tickets
Bulk data processingMediumWhole-set scoringLatest run
Passed by 10 of 12 products on their best model. Failed: Copilot in Excel and ChatGPT + Drive MCP.
Prompt
Extract the order ID from each ticket body in column D. Order IDs are short alphanumeric references such as
HB709. Add a new column with the headerorder_idin column G. If the body does not contain an order ID, returnN/AorUnknown. Do not leave any row 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 الوصف: أواجه مشكلة في إيقاف التجديد التلقائي لخدمة GPT for Work. ق… | 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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
Pass criteria
Each must be met on at least 98% of rows.G2:G1001: filled with text, matching the expected answers
Passed 17
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
Claude 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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
Claude 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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
Gemini in Sheets Auto
G2=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(REGEXEXTRACT(D2, ""(?i)(?:\border|commande|ordre|pedido|orden|ordem|订单|طلب)[^\n\.\?!]{0,60}?([A-Z]{2}[0-9]{3})""), IFERROR(REGEXEXTRACT(D2, ""(?i)([A-Z]{2}[0-9]{3})[^\n\.\?!]{0,50}?(?:order|commande|ordre|pedido|orden|ordem|订单)""), ""N/A""))"),"HB709")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Astra · Medium
G2=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(REGEXEXTRACT(REGEXEXTRACT(UPPER(D2),""(?:ORDER|PEDIDO|ORDEN|ORDEM|ORDRE|COMMANDE|BESTELL[A-Z]*|ORDINE|الطلب|طلب|订单|訂單|注文|주문|ЗАКАЗ)[^.!?\r\n。]{0,100}?[A-Z]{2}[0-9]{3}|[A-Z]{2}[0-9]{3}[^.!?\r\n。]{0,65}?(?:ORDER|PEDIDO|ORDEN|ORDEM|ORDRE|COMMANDE|BEST"&"ELL[A-Z]*|ORDINE|الطلب|طلب|订单|訂單|注文|주문|ЗАКАЗ)""),""[A-Z]{2}[0-9]{3}""),""N/A"")"),"HB709")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,002 rows
Failed 5
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | Unknown |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | Unknown |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
| 12 | 18260 | …@example.com | 2026-08-28 03:01 | Hello Support Team, I’m… | p3 | In progress | HR905 |
11 of 1,001 rows
Why it failed: 57 cells didn't match the expected value.
- Row 12 · body
The previous support ticket ID for this issue is HR905.
- Written
- HR905
- Expected
- N/A
- Row 65 · body, translated from French
The ID of the previous support ticket related to this issue is UM281.
- Written
- UM281
- Expected
- N/A
Copilot in Excel Auto
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | N/A |
| 13 | 18283 | …@example.com | 2026-08-28 01:58 | أكتب إليكم بشأن فاتورة … | Low priority | No further action requi… | N/A |
| 40 | 18240 | …@example.com | 2026-08-27 18:02 | 尊敬的客服团队, 我是贵平台“GPT for … | p2 | Pending | N/A |
12 of 1,001 rows
Why it failed: 128 cells didn't match the expected value.
- Row 10 · body, translated from Chinese
Background: I ordered this add-on under order JL246…
- Written
- N/A
- Expected
- JL246
- Row 13 · body, translated from Arabic
I’m writing about the GPT for Work invoice and service linked to order HL245.
- Written
- N/A
- Expected
- HL245
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | CP527 |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
| 12 | 18260 | …@example.com | 2026-08-28 03:01 | Hello Support Team, I’m… | p3 | In progress | HR905 |
| 14 | 18238 | …@example.com | 2026-08-28 01:45 | Descrição do problema: … | high | Awaiting resolution, | OP656 |
| 22 | 18217 | …@example.com | 2026-08-27 22:02 | I’m writing to report a… | med | Need management review | WL059 |
| 30 | 18277 | …@example.com | 2026-08-27 19:06 | 您好,基于我们企业在日常工作流中对GPT fo… | med | Yet to commence. | ZY441 |
14 of 1,001 rows
Why it failed: 159 cells didn't match the expected value.
- Row 12 · body
The previous support ticket ID for this issue is HR905.
- Written
- HR905
- Expected
- N/A
- Row 22 · body
The diagnostic trace ID captured during the failure is WL059.
- Written
- WL059
- Expected
- N/A
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 | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
10 of 1,001 rows
Why it failed: 23 cells didn't match the expected value.
- Row 784 · body
أود تسجيل تذكرة دعم رسمية بخصوص أمر الشراء OB234. الوصف المفصل: في إطار استخدام فريقنا لـ GPT for Work لإعداد تقارير إدارية أسبوعية، واجهنا رسالة خطأ عند…
- Written
- N/A
- Expected
- OB234
- Row 152 · body
Descrição do ticket Sou cliente do GPT for Work e estou entrando em contato para esclarecer uma divergência de cobrança que impacta meu atendimento. O…
- Written
- N/A
- Expected
- VH968
ChatGPT in Sheets GPT-6 Luna · High
G2=IFERROR(IF(VALUE(MID(D2,SEARCH("order reference ",D2)+18,3))>=0,MID(D2,SEARCH("order reference ",D2)+16,5),1/0),IFERROR(IF(VALUE(MID(D2,SEARCH(" is ",D2,SEARCH("order reference",D2))+6,3))>=0,MID(D2,SEARCH(" is ",D2,SEARCH("order reference",D2))+4,5),1/0),IFERROR(IF(VALUE(MID(D2,SEARCH("order ref ",D2)+12,3))>=0,MID(D2,SEARCH("order ref ",D2)+10,5),1/0),IFERROR(IF(VALUE(MID(D2,SEARCH("order id: ",D2)+13,3))>=0,MID(D2,SEARCH("order id: ",D2)+10,5),1/0),IFERROR(IF(VALUE(MID(D2,SEARCH("order id ",D2)+11,3))>=0,MID(D2,SEARCH("order id ",D2)+9,5),1/0),IFERROR(IF(VALUE(MID(D2,SEARCH("order number ",D2)+15,3))>=0,MID(D2,SEARCH("order number ",D2)+13,5),1/0),IFERROR(IF(VALUE(MID(D2,SEARCH("order ",D2)+8,3))>=0,MID(D2,SEARCH("order ",D2)+6,5),1/0),IFERROR(IF(VALUE(MID(D2,SEARCH("pedido: ",D2)+10,3))>=0,MID(D2,SEARCH("pedido: ",D2)+8,5),1/0),IFERROR(IF(VALUE(MID(D2,SEARCH("pedido ",D2)+9,3))>=0,MID(D2,SEARCH("pedido ",D2)+7,5),1/0),IFERROR(MID(D2,SEARCH("订单",D2)-6,5),"N/A"))))))))))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | ticket_id | customer_email | created_at | body | priority_raw | status_raw | order_id |
| 2 | 18285 | …@example.com | 2026-08-28 10:29 | Hello Support Team, I’m… | high | Pending, | HB709 |
| 3 | 18190 | …@example.com | 2026-08-28 10:03 | I am reaching out regar… | HIGH | Awaiting action | KL826 |
| 4 | 18249 | …@example.com | 2026-08-28 10:03 | Hello Support Team, I’m… | p2 | In queue | OV677 |
| 5 | 18234 | …@example.com | 2026-08-28 08:01 | Resumen del caso: Estoy… | High priority | Awaiting resolution. | MN673 |
| 6 | 18263 | N/A | 2026-08-28 08:01 | Hello Support Team, I’m… | med | In progress | N/A |
| 7 | 18284 | N/A | 2026-08-28 07:36 | Resumo do problema O cl… | LOW | Closed | HQ191 |
| 8 | 18247 | …@example.com | 2026-08-28 05:28 | Customer reports a rece… | p2 | Successfully concluded. | HY329 |
| 9 | 18261 | …@example.com | 2026-08-28 05:01 | سعيد للتواصل مع فريق ال… | High priority | In review. | N/A |
| 10 | 18262 | …@example.com | 2026-08-28 04:53 | 尊敬的客服团队, 我是贵司的长期用户,最近在处… | med | Awaiting resolution | JL246 |
| 13 | 18283 | …@example.com | 2026-08-28 01:58 | أكتب إليكم بشأن فاتورة … | Low priority | No further action requi… | N/A |
| 15 | 18281 | …@example.com | 2026-08-28 01:41 | Bonjour, l’équipe billi… | LOW | In progress. | N/A |
| 18 | 18203 | …@example.com | 2026-08-27 23:02 | Bonjour l’équipe Suppor… | low | Yet to commence, | N/A |
| 27 | 18207 | …@example.com | 2026-08-27 21:02 | Bonjour, Je vous contac… | LOW | Resolved | N/A |
| 35 | 18242 | N/A | 2026-08-27 19:02 | Bonjour, Je vous contac… | MEDIUM | Pending | N/A |
| 40 | 18240 | …@example.com | 2026-08-27 18:02 | 尊敬的客服团队, 我是贵平台“GPT for … | p2 | Pending | 的企业用户 |
16 of 1,001 rows
Why it failed: 293 cells didn't match the expected value.
- Row 13 · body, translated from Arabic
I’m writing about the GPT for Work invoice and service linked to order HL245.
- Written
- N/A
- Expected
- HL245
- Row 40 · body
尊敬的客服团队, 我是贵平台“GPT for Work”的企业用户,订单号为 YJ961。最近在对本月账单进行对账时,发现与我当前订阅方案相关的几处异常,特此提交工单以寻求协助与澄清。 背景与问题 - 账单金额与上月相比出现不一致,尤其在按使用量计费的服务条目上,单价与数量的乘积未能与内部报表相匹配。 -…
- Written
- 的企业用户
- Expected
- YJ961