Skip to content

MassMailer Quick Reference Cheat Sheet

Key Features

  • ✉️ Send personalized mass emails with Google Sheets
  • 📊 Track email opens and replies
  • ⏱️ Schedule automatic followups
  • 🚦 Smart rate limit handling
  • 📈 Real-time progress tracking

Setup Quick Steps

  1. Install MassMailer on your Google Sheet
  2. Set up your spreadsheet with required columns
  3. Create Gmail draft template
  4. Configure settings
  5. Start sending

Essential Menu Commands

Menu Command What It Does
Mass Email > Setup Required Sheets Creates all needed spreadsheet columns
Mass Email > Configure Settings Opens the configuration panel
Mass Email > Start Sending Emails Begins the email campaign
Mass Email > View Progress & Stats Shows current campaign status
Mass Email > Process Scheduled Followups Manually sends due followups

Template Placeholders

  • {{FirstName}} - Recipient's first name
  • {{LastName}} - Recipient's last name
  • {{Name}} - Full name (FirstName + LastName)
  • {{CompanyName}} - Recipient's company

Email Status Codes

  • Sent - Email was successfully sent
  • Failed - Email sending failed
  • Sending - Email is in progress
  • FollowupScheduled - Followup is planned
  • FollowupSent - Followup was sent
  • RateLimited - Paused due to rate limits
Account Type Daily Email Limit Batch Size Interval
Gmail Free 100-150 40-50 2-5 min
Google Workspace 1,500-2,000 100 1-2 min

Troubleshooting Quick Fixes

  1. Emails not sending: Check daily quota or rate limits
  2. Missing personalization: Verify column names match placeholders
  3. Execution timeouts: Reduce batch size or increase interval

Need More Help?