The Scenario
You are a PR manager. You have 40 journalist pitches to send this week, each one personalized to a different publication. Recipient name, email address, outlet, and a custom pitch body are all in a Google Sheet.
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 sheet
- You type the subject from column B
- You paste the body from column C
- You click "Save Draft"
- You close compose, go back to the sheet, next row
- Forty times. You hate your job by row twelve.
The fast version is one prompt, 40 drafts ready for your review.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the sheet 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 sheet — 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. You can open them one by one, edit, and send when you are ready.
What You Get
40 Gmail drafts, each pre-populated from the sheet:
- To field — the email from column A
- Subject — the subject from column B
- Body — the message from column C
- In Drafts — they appear in your standard Gmail Drafts folder, same as if you had typed them
The drafts are real Gmail drafts. You can edit any of them before sending. You can send them one at a time, at your own pace, on your own schedule. Nothing went out without your review.
You can ask SheetXAI to write the Gmail draft URL for each row back into column D so you can click directly from the sheet into the draft.
What If the Data Is Not Quite Ready
Pitch sheets are rarely polished before the draft stage. SheetXAI handles prep and draft creation in the same prompt.
When the subject line needs to reference the outlet name
Column D has the outlet name. 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 now.
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 now.
When you want to create drafts only for rows that are marked "ready"
Column E has a status: "ready," "draft," or "hold." You only want drafts for the "ready" rows.
Create a Gmail draft for each row where column E says "ready". Use column A for recipient, B for subject, C for body. Skip any row where column E is not "ready". Write "draft created" into column F for each row processed.
When you want to create and immediately get a review summary
You want to see a subject-line summary before you open each draft individually.
Create a Gmail draft for each row in this sheet — recipient in A, subject in B, body in C. Create all 40 drafts. Then write a summary into column D: for each row, the first 80 characters of column C 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 sheet 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 a sheet or the Gmail in Google Sheets overview.