The Scenario
You are a customer success manager. The quarter closed two weeks ago and your churn report is sitting in an Excel workbook: 150 rows, one per churned customer, with their name in column A, email in column B, and a personalized win-back message your team drafted in column C.
The campaign should have gone out Monday. It is Wednesday.
The bad version of this morning:
- You save the workbook as CSV
- You look for a mail merge add-in that works with Excel and Gmail
- You spend 45 minutes on the configuration because the add-in expects Outlook, not Gmail
- The send runs — including three rows where column C is blank — because you forgot to filter
- Three customers get an empty email body
- You explain to your VP why the win-back landed with no message.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the data and fires one personalized Gmail per row, so you never touch a mail merge wizard.
Open the SheetXAI sidebar and type:
Send a Gmail email to each row in this workbook — recipient email in column B, subject line "We miss you, [name in column A]", message body from column C. Skip any row where column C is blank. Send all valid rows now and write send status into column D.
SheetXAI reads every row, builds the personalized email from the column values, skips the blank ones, fires the send, and writes "sent" or "error" into column D. You did not open Gmail once.
What You Get
150 sent emails, each personalized to the recipient, with:
- Subject — "We miss you, [name]" built from column A
- Body — the message from column C, verbatim
- Skip logic — blank rows in column C do not get sent
- Status column — column D shows "sent" or an error code per row
The skip logic is in the prompt, not a filter you configure separately. Add conditions — skip rows where churn date is more than 90 days ago — and SheetXAI applies them inline.
What If the Data Is Not Quite Ready
Win-back workbooks are rarely clean. SheetXAI handles cleanup and the send in the same prompt.
When the names have inconsistent capitalization
Column A has "john smith," "JANE DOE," and "Bob jones." You do not want the subject line to look wrong.
Normalize the names in column A to title case. Then send a Gmail to each row — subject "We miss you, [name]", body from column C — skip blank C rows, write status to column D.
When the message bodies need a personalization pass
Column C has the base message but every customer's industry is in column E. You want the opening line to reference it.
For each row, prepend a one-sentence intro to the column C message that references the industry in column E. Then send the combined message as a Gmail to column B, subject "We miss you, [name in A]". Write status to column D.
When you only want to target customers who churned in the last 45 days
Column F has churn date. Older churns are lower priority.
Filter to rows where column F is within the last 45 days. For those rows only, send a Gmail with subject "We miss you, [name]" and body from column C. Write status to column D.
When you want to preview the full send list before anything goes out
You have 150 rows but want to sanity-check before firing.
Read all rows where column C is not blank. For each one, build the email subject and body from columns A, B, and C — but instead of sending, write the composed subject into column E and the first 100 characters of the body into column F so I can review. When I confirm, I will ask you to send.
The pattern: the prompt is your send configuration. Add conditions, previews, or transformations, and SheetXAI handles them before anything reaches Gmail.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with recipient emails and message bodies, then ask it to send from your Gmail account. The Gmail integration is included in every SheetXAI plan. For related workflows, see how to create Gmail drafts before sending from Excel or the Gmail in Excel overview.