/
Mailmeteor - Google Sheets

Mailmeteor - Google Sheets

Before You Start

If this is your first time using Mailmeteor in Sheets, the Receive a test email option in Preview emails won’t work. Before you try to create a real campaign, you should create a test mail merge that sends an email to yourself and send the email without previewing it. This will cause Google to prompt you to authorize Mailmeteor to act on behalf of your account. After completing this step, sending test emails to yourself will work as expected.

  • Be signed into google chrome with your SUNY Geneseo credentials.

  • Google Workspace accounts can send 2,000/day per account.

  • Mailmeteor is already available in Google Sheets as an extension provided by SUNY Geneseo.

  • Have a Google Sheet ready with recipient data (e.g., First Name, Email Address, etc.).

Prepare Your Spreadsheet

  • Create columns with headers like: First Name | Email Address | Company | Custom Message

  • Fill in your data for each contact.

  • Make sure the Email Address column contains valid emails.

Open Mailmeteor in Google Sheets

  1. In the Google Sheet, click Extensions → Mailmeteor- Mail merge → New campaign.

  2. The Mailmeteor window will open.

Write Your Email

  1. Compost your email or select a previously saved template.

    1. Use merge tags matching your column headers to write your Subject and Body:

    2. image-20250814-175005.png

Preview or Send Emails

  1. Choose whether to Preview email or Send emails:

    • Preview emails

      • Receive a test email (sends only to you for review).

      • Send emails (goes out to all rows with valid emails).

    • Send emails (goes out to all rows with valid emails).

  2. Watch the progress in the sidebar.

Track Your Emails (Optional)

  • Mailmeteor shows open, click, and reply tracking (if enabled in settings).

More Information

https://mailmeteor.com/docs/google-sheets/

Related articles