The Scenario
Your sales pipeline lives in a Google Sheet: 150 rows, each with a first name, email address, and deal stage. The quarter ends Friday. You need a personalized follow-up in every inbox before then.
You know what the bad version looks like.
The bad version:
- Open Outlook, compose a new message, copy the first name from the sheet into the greeting, copy the email address into the To field, adjust the body to mention the deal stage, send
- Repeat 149 more times, checking back to the sheet after every send to grab the next row's values
- Lose your place around row 60, send the wrong deal stage to two people, and spend 20 minutes finding and apologizing
You have 150 contacts and a deadline, not an afternoon to spend playing copy-paste relay between two browser tabs. The work here is sending the emails — not manually threading the data from one tool to the other.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the data, connects to your Outlook account, and sends each email for you. Open the sidebar and describe what you want.
Send a personalized Outlook email to every row in this sheet — use column A as the recipient email, column B as the first name in the greeting, and column C as the deal stage mentioned in the body
What You Get
- One email dispatched per row through your Outlook account, using each row's values for recipient, greeting, and body
- The subject line is inferred from context, or you can specify it in the prompt
- Rows where column A is blank are skipped automatically
- A confirmation in the sidebar listing how many emails were sent and flagging any delivery failures
What If the Data Is Not Quite Ready
The first name column has mixed formatting — some rows are "JOHN", some are "john"
Before sending, normalize column B so every first name is title case, then send a personalized Outlook email to every row using column A as the recipient and the normalized name in the greeting
Some rows are missing an email address
Send a personalized Outlook email to every row where column A contains a valid email address — skip blank rows and flag skipped rows by writing "Skipped — no email" in column D
The deal stage values use old terminology that needs updating in the email body
Substitute any deal stage in column C that says "Prospect" with "Priority Follow-Up" in the email body only — do not change the sheet — then send the personalized email to every row using column A and column B
Clean the list, standardize the body copy, and send in one shot
Remove any duplicate email addresses in column A keeping the first occurrence, title-case column B, replace "Prospect" with "Priority Follow-Up" in the body language only, then send a personalized Outlook email to every remaining row
One prompt handles the cleanup and the send together — you don't need two passes.
Try It
Get the 7-day free trial of SheetXAI and open your prospect sheet, then tell SheetXAI which columns hold the recipient address, name, and any personalization data. See also: Import Outlook inbox messages into a sheet and the Outlook hub overview.