The Scenario
Your team is launching a partner campaign next Thursday. The marketing coordinator built the outreach sheet — 80 rows, each with a partner contact's name, email, subject line, and body copy. The brief says nothing goes out until the content lead and the account manager both sign off on the messaging.
The bad version:
- Copy the subject and body from row 2, open Zoho Mail, click Compose, paste the subject, paste the body, add the recipient from column B, save as draft. Close the compose window. Go back to the sheet. Copy from row 3.
- Repeat 79 more times, keeping track in your head which rows you've already drafted so you don't double-create or skip one.
- Send the review link to the content lead and explain that the 80 drafts are sitting in the Zoho Mail drafts folder waiting for them to check each one.
The review process itself is straightforward. Getting 80 individual emails into draft state without spending the afternoon on it is the problem. You are supposed to be managing the campaign, not manually feeding content into a compose window.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sheet data and talks to Zoho Mail directly — no compose window, no row-by-row copying, no manual draft creation. Open the sidebar, describe what you need.
Save a Zoho Mail draft for each contact in this Sheet using the Subject column as the email subject, the HTMLBody column as the body, and the Email column as the recipient — then write the resulting draft ID into column D for each row
What You Get
- One Zoho Mail draft created per row in the sheet, staged in the drafts folder for review.
- Each draft carries the exact subject and body from the sheet row, addressed to the correct recipient.
- The Zoho Mail draft message ID for each created draft is written back into column D, so the team can reference or retrieve specific drafts by ID later.
- Rows where the email field is empty get a note in column D instead of a draft ID.
What If the Data Is Not Quite Ready
Some body fields contain HTML but others are plain text
Before creating drafts, check the HTMLBody column — for any row where the value does not contain an HTML tag, wrap the plain text in basic paragraph tags so all drafts render consistently, then save a Zoho Mail draft for each row using Subject, the normalized HTMLBody, and Email columns
Subject lines are missing from some rows
Create Zoho Mail drafts for all rows in this Sheet where the Subject column is not empty — skip rows missing a subject and write "Missing subject" into column D for those rows
The recipient list spans two tabs and needs to be joined before drafting
Join the Partners tab (Email, ContactName) with the CampaignContent tab (Subject, HTMLBody) on the ContactName column, then create one Zoho Mail draft per matched row using the joined subject, body, and email — write each resulting draft ID into column E of the CampaignContent tab
Deduplicate, normalize, and create all drafts in one shot
Check the Sheet for duplicate email addresses in column B — keep only the first occurrence of each, mark duplicates "Skipped" in column D, strip any HTML formatting from rows in the HTMLBody column that are missing tags, then create a Zoho Mail draft for every remaining valid row and write the draft ID back into column D
One prompt handles the audit and the draft creation together, so the review set the team receives is clean from the start.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with outreach or campaign content ready to stage, then ask it to create the draft batch. See also: Bulk send emails from a sheet. Or return to the Zoho Mail hub.