CSV Mail Merge in Gmail with Google Sheets

Turn a CSV export into a personalized Gmail mail merge with Google Sheets. Clean columns, match headers to placeholders, test, and send responsibly.

A CSV file is often the bridge between your CRM, form tool, event platform, ecommerce export, applicant tracker, or spreadsheet and a Gmail campaign. With Mail Merge for Gmail and Google Sheets, you can import a CSV into Sheets, clean the data, use the column headers as placeholders, and send personalized Gmail messages from a workflow your team can review.

Turn a CSV into a Gmail mail merge →

Before sending, make sure your recipients are permissioned or clearly relevant, remove duplicates, test every field, respect opt-outs, and stay within Gmail/Google Workspace limits. A CSV makes sending easier; it does not remove your responsibility to send useful, compliant email.

When to use a CSV for Gmail mail merge

CSV mail merge is useful when your recipient list starts outside Google Sheets:

• a CRM export for sales outreach;
• a recruiting or applicant-tracking export;
• a webinar, event, or conference registration list;
• a customer update list from billing, support, or ecommerce tools;
• a nonprofit donor or volunteer list;
• a manually prepared spreadsheet from another team.

The goal is to convert that static file into a clean Google Sheet with columns you can safely personalize.

Import and clean your CSV in Google Sheets

Start by importing the CSV into Google Sheets, then clean it before connecting any mail merge workflow.

1. Open Google Sheets and import the CSV. Use a new spreadsheet when possible so your campaign list is isolated.
2. Confirm header names. The add-on needs Email (capital E), First Name, Last Name and a Mail Merge status column in columns A–D. Rename other columns to clear field names such as First Name, company, role, segment, and custom_note.
3. Remove duplicates. Deduplicate by email address and, if needed, by company or account.
4. Validate required fields. Every send row needs a valid recipient email and any required merge field used in the template.
5. Filter risky rows. Remove bounced addresses, unsubscribed contacts, internal test rows you do not want to send, and contacts without a valid reason for outreach.
6. Add campaign-control columns. Add the empty Mail Merge column (the add-on writes EMAIL_SENT there; type SKIP to exclude a row), plus send_group, owner, or notes for your own tracking.

Match CSV columns to Gmail merge fields

After cleanup, your CSV columns become merge fields in the Gmail draft. There is no mapping step: type each placeholder exactly as the header is written (case and spaces). Keep names short and consistent.

Sheet column	Example value	Template use
First Name	Priya	Hi {{First Name}},
company	Northstar Labs	I noticed {{company}}...
use_case	webinar follow-up	Your {{use_case}} list...
custom_note	asked about pricing	You mentioned {{custom_note}}.
meeting_link	https://example.com/demo	Here is the link: {{meeting_link}}

Avoid over-personalization. If a field is empty, wrong, or creepy, it can hurt trust more than a simple message would.

Use Mail Merge for Gmail and Sheets →

Preview, test, and send the campaign

A safe CSV mail merge workflow should include these checks:

1. Check rows in the Sheet. Look at the first rows, last rows, empty-field rows, and unusual characters from the CSV import. An empty cell becomes empty text in the email.
2. Verify links and attachments. If your campaign includes files or custom links, confirm they match the right recipient.
3. Send a test email. Send Test Email sends one message to you, filled with row 2’s data. Forward it to a teammate if you want a second check.
4. Start with a small segment. A 25–50 recipient pilot can reveal data or copy problems before a full send.
5. Monitor bounces and replies. Pause if the list quality is poor.
6. Respect sending limits. Do not use CSV mail merge to bypass Gmail or Workspace limits.
7. Record campaign status. The add-on writes EMAIL_SENT in the Mail Merge column, and EMAIL_OPENED or EMAIL_CLICKED after you click Refresh Email Status. Note replies, bounces, and opt-outs in the Sheet yourself.

CSV mail merge examples

CRM export for sales outreach

Export accounts or leads with columns for Email, First Name, company, industry, pain_point, and owner. Segment by fit and send a concise message that references a real business reason.

Event registration list

Export registrants or invitees with First Name, event_name, event_date, registration_link, and attendance_status. Use separate segments for reminders, no-shows, and post-event follow-ups.

Recruiting list

Export candidates with First Name, role, location, relevant_background, and source. Keep messaging transparent and stop if a candidate declines.

Customer update list

Export customers with plan, product_area, account_owner, and deadline. Use CSV mail merge only when the message is relevant to the recipient’s account or product usage.

Related Mail Merge resources

• Mail Merge for Gmail and Google Sheets
• Gmail mail merge from Google Sheets
• Personalized email from Google Sheets
• Mail Merge privacy information

CSV mail merge FAQ

Can I send emails from a CSV in Gmail?

Yes. A practical workflow is to import the CSV into Google Sheets, clean and label the columns, then use a Gmail and Sheets mail merge tool to personalize and send messages.

What columns do I need for CSV mail merge?

At minimum, you need Email, First Name, Last Name and a Mail Merge status column in columns A–D. Most useful campaigns also include company, segment, custom context, and owner columns.

How do I avoid CSV formatting problems?

Check headers, encoding, blank rows, commas inside fields, broken links, and special characters after import. Look over several rows in the Sheet and send a test email before sending.

Can I use a purchased email list for CSV mail merge?

Avoid sending to people who did not give permission or have no clear reason to hear from you. Purchased lists often create deliverability, compliance, and reputation risks.

Should I send the whole CSV at once?

Usually no. Start with a small test segment, monitor bounces and replies, then scale carefully while respecting Gmail and Workspace limits.

Start from your CSV and send from Gmail

Import your list into Google Sheets, clean the data, write a useful template, send a test, and use Mail Merge for Gmail and Sheets to send a responsible personalized campaign.

Try Mail Merge for Gmail and Sheets →