1. Help center
  2. Elite Mail Suite features
  3. Campaigns, documents, and advanced features

Elite Mail Suite features

Everyday email toolsCampaigns, documents, and advanced featuresiPhone, Android, and mobile Gmail
A little more help?

Tell us what you’re trying to do.

Contact support

Campaigns, documents, and advanced features

Mail merge with Google Sheets

Elite support2 min readUpdated October 13, 2026

The quick answer

In Outreach, choose the owned Google identity, connect selected Sheets with drive.file, and open Google Picker. Choose a spreadsheet, preview rows and import. Pasted spreadsheet IDs and global Drive listing are unavailable. Cancel, expiry or revoked access preserves existing contacts; choose again or use CSV/manual entry.

PREFER TO WATCH?

See it in action

Elite Mail Suite · Video walkthroughEnglish narration & captionsWatch on YouTube
Read the English video transcript

Hi there! Welcome to Elite Mail Suite. Let's prepare a personal campaign, without rushing the important checks.

Want to reach several contacts while still sounding like yourself? A campaign gives each person an individual message, with room for their name, company, and a considered follow-up.

Let's create a draft called Partner briefings. Start with a draft so you can review everything before anyone receives it. Check the sender and business details, then continue. Use a name that will be easy to find later, and check who the message will come from.

Add first-name and company fields, with fallback text. A fallback keeps the greeting readable when a contact has no first name. Write your message, add a three-day follow-up, then continue to recipients. Keep the message focused on one useful next step; the follow-up gives people time to respond.

Choose Maya and Jon, then continue. Choose the people this message is relevant to. Take a moment to check both recipients and the follow-up timing. Review the audience and timing together before moving on, especially when a follow-up is included.

Next, run preflight and read through the results. Preflight shows what still needs attention before a send. This draft needs sender setup before it can launch. Here, sender setup is incomplete, so keep the draft and finish that connection rather than trying to launch it.

Head back to Campaigns. Your draft is saved here. The saved draft means you can come back without losing your work. Finish the flagged checks before approving a live send. Once the flagged checks are resolved, review it again before approving the live campaign.

Your draft is saved, so you can finish those checks when you're ready. The linked campaign guide walks through each step. Thanks for joining me!

Prepare personalized emails

  1. 1

    Prepare a clean source

    Use fresh Contacts/Lists, CSV, or a spreadsheet selected in Google Picker. Connect the selected Google identity with selected-file permission; choose the sheet, range, headers and email column. Pasting an ID does not grant access.

  2. 2

    Check the fields

    Match the import headers to the fields used in your message. Use a fallback such as {{first_name|there}} or {{company|your team}}.

  3. 3

    Preview representative rows

    Inspect at least one complete record and one record with missing optional fields. Check subject, body, links, and punctuation.

  4. 4

    Review delivery scope

    Use a campaign for separate emails with recipient-level tracking. Confirm the final audience and suppression checks before launch.

IN YOUR WORKSPACE

What it looks like

The actual campaign message editor uses supported personalization fields.

  1. 1
    Setup steps

    Move through setup, message, recipients, and review.

  2. 2
    Personalization

    Use supported merge fields and fallback text in the subject and body.

  3. 3
    Continue

    Preview the audience and message before approving a launch.

The actual campaign message editor uses supported personalization fields.123

The actual campaign message editor uses supported personalization fields.

  1. 1
    Setup steps

    Move through setup, message, recipients, and review.

  2. 2
    Personalization

    Use supported merge fields and fallback text in the subject and body.

  3. 3
    Continue

    Preview the audience and message before approving a launch.

Good to know

Google Sheets imports accept up to 5,000 rows. Avoid changing the source mid-review without rechecking the imported audience. Cloud Gmail uses identity and gmail.send; selected Sheets uses Picker and drive.file. Gmail mailbox history and replies stay browser-local or device-only. Gmail sequences WILL NOT automatically stop on replies or bounces. Outlook and contextual Gmail add-on permissions remain separate.

Build a campaignRead the complete product guide
Was this article helpful?Find the answer you were looking for?

Related articles

  • Mail merge from a contact list
  • Add fallback text to merge fields
  • Split a group message into individual emails
  • Set up a branded tracking domain
  • Use a professional custom-domain email address

IN THIS ARTICLE

The quick answerVideo walkthroughPrepare personalized emailsProduct screenshotGood to knowYour next step
All Campaigns, documents, and advanced features articles
Elite Mail Suite
Product docsSecurityPrivacyTerms
Skip to content
Elite Mail SuiteHelp center
HelpVideo guidesPricingContact support