The Scenario
You are a PR manager. You have 40 journalist pitches to send this week, each one personalized to a different outlet. Recipient name, email, outlet, and a custom pitch body are all in an Excel workbook on OneDrive.
The rule is simple: nothing goes out without a human read. You want drafts in Gmail, not live sends.
The bad version:
- You open Gmail's compose window
- You paste in the email address from the workbook
- You type the subject from column B
- You paste the body from column C
- You click "Save Draft" and close compose
- Back to the workbook, next row
- Forty times. You hate your job by row twelve.
The fast version is one prompt and 40 drafts ready for your review.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the workbook and creates Gmail drafts via the API, so you are not opening a compose window 40 times.
Open the SheetXAI sidebar and type:
Create a Gmail draft for each row in this workbook — recipient email in column A, subject in column B, message body in column C. Create all 40 drafts now so I can review them before sending.
SheetXAI reads every row and creates a draft in Gmail for each one. When it finishes, you have 40 drafts in your Gmail Drafts folder, ready for review. Open them one by one, edit, and send when ready.
What You Get
40 Gmail drafts, pre-populated from the workbook:
- To field — email from column A
- Subject — from column B
- Body — from column C
- In Drafts — they appear in your Gmail Drafts folder like any manually composed draft
You can edit any of them before sending. Nothing went out without your review.
What If the Data Is Not Quite Ready
Pitch workbooks are rarely polished before the draft stage.
When the subject line needs to reference the outlet name
Column D has the outlet. You want the subject to say "Pitch for [outlet]: [subject]."
For each row, create a Gmail draft where the subject is "Pitch for [column D outlet]: [column B subject]". Recipient is column A, body is column C. Create all 40 drafts.
When some pitches need an HTML signature
Your agency requires an HTML signature block on all outbound emails.
For each row, create a Gmail draft — recipient in A, subject in B, body in C. Append the following HTML signature to the bottom of each body: [your HTML signature]. Create all 40 drafts.
When you want drafts only for rows marked "ready"
Column E has a status: "ready," "draft," or "hold." Only create drafts for the "ready" rows.
Create a Gmail draft for each row where column E says "ready". Recipient in A, subject in B, body in C. Skip rows where E is not "ready". Write "draft created" into column F for each row processed.
When you want a review summary before opening each draft
You want to see opening lines before clicking into each Gmail draft.
Create a Gmail draft for each row — recipient in A, subject in B, body in C. Create all 40 drafts. Then write the first 80 characters of column C into column D so I can quickly review the opening line without opening each draft.
The pattern: staging before sending. The drafts give you control and review without the manual compose-and-save loop.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with recipients and message bodies, then ask it to create Gmail drafts for your review. The Gmail integration is included in every SheetXAI plan. For related workflows, see how to send bulk emails from an Excel workbook or the Gmail in Excel overview.