How to Send Personalized Bulk Emails with Gmail Using YAMM and Google Sheets

Modern professionals face two persistent challenges when it comes to outreach: collecting contact information efficiently and following up in a timely, personalized way. Too often, business cards pile up after events, data entry gets delayed or skipped entirely, and promising connections go cold before a follow-up ever happens.

Manually typing business cards into a spreadsheet is time-consuming, error-prone, and easy to procrastinate. Sending individual follow-up emails one at a time is just as inefficient. As a result, many professionals struggle to maintain consistent communication with the people they meet.

This guide solves those problems by showing how to:

  • Save hours by scanning business cards instead of typing them manually
  • Capture contacts on the go using your phone’s camera
  • Store contacts instantly in Google Sheets with a clean, usable structure
  • Send personalized bulk emails without complex marketing software
  • Follow up faster and more consistently after meetings and events

By combining ScanCardPro, Google Sheets, Gmail, and Yet Another Mail Merge (YAMM), you can build contact lists faster and turn them into effective, personalized outreach campaigns using tools you already trust.

Why Gmail + Google Sheets + YAMM + ScanCardPro Works So Well

This workflow works because every step stays inside the Google ecosystem:

  • Gmail sends emails directly from your own account
  • Google Sheets stores and organizes your contact data
  • YAMM handles personalized bulk sending at scale
  • ScanCardPro lets you scan business cards with your phone’s camera and saves contact details directly into Google Sheets

This approach removes manual data entry, reduces delays, and makes it possible to collect contacts and prepare follow-up emails while you are still in the middle of networking.

Step 1: Create Your Contact Sheet with ScanCardPro

Sign Up and Connect Google

  1. Visit ScanCardPro.com
  2. Click “Get Started” or “Try For Free”
  3. Sign in using your Google account

This allows ScanCardPro to securely create and update Google Sheets on your behalf, without requiring any app downloads or browser extensions.

Create Your First Google Sheet

  1. From the ScanCardPro dashboard, click “+ New Sheet”
  2. Name your sheet (for example, “Trade Show Leads 2025”)
  3. The sheet is created instantly in your Google Drive

ScanCardPro automatically sets up clean, consistent columns optimized for outreach, including name, email, company, notes, and tags.

Step 2: Scan Business Cards with Your Phone and Save Them to Google Sheets

ScanCardPro uses your phone’s camera, allowing you to scan a business card the moment you receive it. Each scan typically takes 5–10 seconds, making it practical to build a contact list while you are still at an event.

  1. Click “Start Scanning Cards” in ScanCardPro
  2. Position the business card inside the camera frame
  3. Capture the image or upload an existing photo
  4. Review the extracted contact information
  5. Add notes or tags for context
  6. Click “Save Contact”

Each scan instantly adds a new row to your Google Sheet. There is no exporting, copying, or cleanup required.

Step 3: Install Yet Another Mail Merge (YAMM)

  1. Open your Google Sheet
  2. Go to Extensions → Add-ons → Get add-ons
  3. Search for “Yet Another Mail Merge”
  4. Install and approve permissions

You can also install YAMM directly from the Google Workspace Marketplace:
Install Yet Another Mail Merge

Step 4: Prepare Your Google Sheet for Mail Merge

Your sheet must include at least the following columns:

  • Email
  • First Name

ScanCardPro creates these columns automatically, which reduces setup errors and ensures compatibility with YAMM.

Step 5: Write a Personalized Gmail Draft (Understanding Merge Tags)

Your Gmail draft must include both a subject line and a message body. YAMM uses this draft as the template for every email it sends.

Adding a Subject Line (Merge Tags Work Here Too)

You can use merge tags in the subject line just like you do in the email body. This allows each recipient to see a subject line that feels relevant and personal.

Example subject line:

Great meeting you at {{Company}}

The merge tag must exactly match the column header in your Google Sheet. Merge tags are case-sensitive and space-sensitive.

Note: Merge tags are optional. You can send a mail merge with a static subject line if you prefer, or start simple and add personalization later.

Writing the Email Body

You are welcome to copy and paste the example below. Just replace “Your Name” with your own information and adjust the wording as needed.

Hi {{First Name}},

It was great meeting you at the event. I enjoyed our conversation about {{Company}} and wanted to follow up.


Best,
Your Name

Save this email as a draft in Gmail. Do not send it manually.

Step 6: Send Your First Mail Merge with YAMM

When you are ready to send your mail merge, return to the Google Sheet that contains your contacts.

If you can’t find the sheet:

  • Open Google Sheets and look in your recent files, or
  • Open ScanCardPro, go to your dashboard, and click “Open Sheet” next to the connected spreadsheet
  1. With the sheet open, click Extensions → Yet Another Mail Merge → Start Mail Merge
  2. Select the Gmail draft by the subject line you just created
  3. Confirm sender details

Pro Tip: Send a Test Email First

Before sending a full campaign, send a test email to yourself to confirm merge tags, subject line formatting, and content.

Many users go from scanning a business card on their phone to sending a personalized follow-up email in under five minutes.

Tracking Results

YAMM automatically adds tracking columns such as:

  • Email Sent
  • Opened
  • Replied

This allows you to manage responses and follow-ups directly in Google Sheets.

Why ScanCardPro Completes This Workflow

Effective outreach depends on fast, accurate contact capture. ScanCardPro ensures:

  • No manual typing — just scan with your phone
  • Consistent, structured contact data
  • Immediate availability in Google Sheets
  • Contacts ready for mail merge and follow-up

The faster contacts enter your system, the more likely you are to follow through.

Bonus: Learn Outreach Best Practices

If you want to avoid common mistakes and improve response rates, ContactHoarder.com provides practical guidance on building and using high-quality contact lists.

Final Thoughts

This workflow turns real-world networking into organized, scalable outreach using tools you already rely on.

Start scanning business cards for free and send your first mail merge today.

Share this article: