The Scenario
You are a team lead in customer success. Over the past month, 30 customer escalation emails landed in your inbox from different senders, different threads, different dates. Your manager asked you today to loop her in on all of them.
You have the Gmail message IDs in column A of an Excel workbook, copied from your email client. Your manager's address is manager@company.com.
You need all 30 forwarded by 4 PM.
The bad version:
- You try to search Gmail by message ID — Gmail does not support that
- You find each email the long way, clicking into threads and scrolling
- You click the three-dot menu, click Forward, type the address, click Send
- Back to the workbook, next row
- Thirty times. You make it to 22 before 4 PM.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the message IDs in your workbook and calls Gmail's forward endpoint for each one, so you are not opening emails and clicking forward manually.
Open the SheetXAI sidebar and type:
Forward each Gmail message whose ID appears in column A of this workbook to manager@company.com. Write "forwarded" or "error" into column B for each row when done.
SheetXAI reads each message ID, fetches the message, forwards it to the specified address, and writes the status back into column B. Thirty rows, done before 4 PM.
What You Get
30 forwarded emails, with status written back to the workbook:
- Column B — "forwarded" or "error" per row
- Original sender preserved — your manager sees the original sender in the forward
- No Gmail compose required — you never opened a compose window
If a message ID is invalid, the row shows "error" instead of failing silently.
What If the Data Is Not Quite Ready
Forwarding operations often need more nuance than a flat column of IDs.
When you want to forward to different addresses per row
Some escalations go to your manager, some to a senior rep. Column B has the destination.
Forward each Gmail message whose ID is in column A to the email address in column B. Write "forwarded" or "error" into column C for each row.
When you want to add a custom note to each forward
Your manager asked for a one-liner context note in each forwarded message.
Forward each Gmail message whose ID is in column A to manager@company.com. Prepend the note from column C to the top of the forwarded message body. Write status into column D.
When some message IDs might be duplicates
Your list was assembled from two sources and may have overlaps.
Deduplicate column A by message ID before forwarding. Forward each unique ID to manager@company.com and write status into column B. Write "duplicate — skipped" for any repeated IDs.
When you want to preview what will be forwarded before anything is sent
Your manager wants a one-line summary before the 30 emails hit her inbox.
Before forwarding, fetch the subject line for each message ID in column A. Write subject lines into column B so I can review the list. When I confirm, I will ask you to forward them all.
The pattern: the message IDs are your trigger. SheetXAI reads them, operates via Gmail's API, and reports back — no manual email hunting required.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with Gmail message IDs, then ask it to forward them to any address you specify. The Gmail integration is included in every SheetXAI plan. For related workflows, see how to reply to open Gmail threads in bulk from Excel or the Gmail in Excel overview.