GPT for Google Sheets, Docs AI, Slides, Forms

Event Invite Mail Merge from Google Sheets

Send personalized event invitations from Google Sheets through Gmail: guest list setup, invite templates, RSVP columns, test sends and separate reminders.

Event invitations work best when they feel relevant: the recipient understands why they were invited, what the event is, and what to do next. If your guest list is in Google Sheets, Mail Merge for Gmail and Google Sheets can help you send personalized Gmail invitations without copying and pasting every message by hand.

Send personalized event invites →

This guide covers a practical workflow for webinars, workshops, customer events, recruiting sessions, community meetups, school updates, nonprofit events, and partner briefings.

Why use Google Sheets for event invitations?

A Sheet is a simple event operations hub. You can keep each recipient, segment, invitation angle, RSVP status, and follow-up note in one place.

Useful event invite columns include:

Column Example Purpose
Email [email protected] Recipient address (header must be exactly Email).
First Name Sam Personal greeting.
Last Name Lee Required header; the cells can stay empty
Mail Merge (empty) Required status column. The add-on writes EMAIL_SENT and skips rows that already have a status, which prevents duplicate sends.
segment customer, candidate, donor, partner Helps tailor copy and avoid irrelevant invites.
event_name AI Sales Workflow Workshop The event name in the email.
event_date June 24 Clear timing.
personal_reason your team is scaling outbound Makes the invite feel specific.
registration_link https://... Main CTA.
rsvp_status not invited, invited, registered, declined Your own RSVP tracking (the add-on ignores it).

The add-on checks that the first four columns (A–D) are Email, First Name, Last Name and Mail Merge, and Launch creates them if they’re missing. Put your other columns after them.

Keep one event per Sheet, and send each segment from its own tab (or type SKIP in Mail Merge for rows that should not get this invite) so your team does not send the wrong invite to the wrong audience. The templates below also use company, topic, topic_summary, event_topic, resource_link, company_or_context, and sender_name: add a column for each placeholder you keep, because a placeholder with no matching column is sent as-is.

Prepare the guest list before sending

Before launching an event invite mail merge:

  1. Define the audience. Choose a specific segment that has a reason to care about the event.
  2. Remove ineligible contacts. Suppress opted-out recipients, bounced addresses, duplicates, and people who should not receive event marketing.
  3. Add personalization fields. Use fields like company, role, city, topic interest, or relationship context only when they are accurate.
  4. Create RSVP tracking columns. Include status, reply notes, registration link, and follow-up date.
  5. Check event details. Verify time zone, date, location, joining link, and registration page before sending.

Write an event invite Gmail template

Keep the invite short. The reader should understand the topic and next step in seconds.

Webinar invite template

Subject: Invite: {{event_name}} on {{event_date}}

Hi {{First Name}},

I thought this might be relevant because {{personal_reason}}.

We are hosting {{event_name}} on {{event_date}}. The session will cover {{topic_summary}} and include time for questions.

If you would like to join, you can register here: {{registration_link}}

Best, {{sender_name}}

Customer workshop template

Subject: Workshop for {{company}} teams using {{topic}}

Hi {{First Name}},

We are running a practical workshop about {{topic}} for teams like {{company}}. It may be useful if you are working on {{personal_reason}}.

Details:

  • Event: {{event_name}}
  • Date: {{event_date}}
  • Link: {{registration_link}}

Reply if you want help deciding whether it is a fit.

Thanks, {{sender_name}}

Community meetup template

Subject: {{First Name}}, join us for {{event_name}}

Hi {{First Name}},

We are inviting local {{segment}} contacts to {{event_name}} on {{event_date}}.

Why you may care: {{personal_reason}}.

You can RSVP here: {{registration_link}}

Hope to see you there, {{sender_name}}

Send event invites with Mail Merge for Gmail and Sheets

Use this launch checklist:

  1. Create the event Sheet. Put Email, First Name, Last Name and Mail Merge in columns A–D, then add merge fields, RSVP status, and internal notes.
  2. Write the invitation as a Gmail draft. Make the event value and CTA clear.
  3. Check the guest rows. Look over the Sheet for empty or wrong values, especially event date, time zone, and registration link.
  4. Send a test email. Send Test Email sends one message to you, filled with row 2’s data; forward it to a teammate if needed. Click the registration link from the test email.
  5. Send a small first batch. Confirm deliverability, replies, and registration behavior before sending the full list.
  6. Track outcomes. The add-on writes EMAIL_SENT in the Mail Merge column, and EMAIL_OPENED or EMAIL_CLICKED after you click Refresh Email Status. Update rsvp_status, replies, bounces, and follow-up notes yourself.
  7. Follow up respectfully. A reminder is a separate send you set up yourself: copy the relevant rows to a new tab, clear their Mail Merge cells, write a new draft, and launch again. Avoid emailing people who declined or opted out.

Use Mail Merge for Gmail and Sheets →

Event follow-up examples

Reminder before the event

Subject: Reminder: {{event_name}} is {{event_date}}

Hi {{First Name}},

A quick reminder that {{event_name}} is coming up on {{event_date}}. Here is the link again: {{registration_link}}.

See you there, {{sender_name}}

Replay or resources after the event

Subject: Resources from {{event_name}}

Hi {{First Name}},

Thanks for your interest in {{event_name}}. Here are the resources we mentioned: {{resource_link}}.

If you want help applying this to {{company_or_context}}, reply and I will point you in the right direction.

Best, {{sender_name}}

Non-registrant follow-up

Subject: Still interested in {{event_topic}}?

Hi {{First Name}},

I noticed you might be interested in {{event_topic}}. If the timing did not work, here is a short resource: {{resource_link}}.

No need to reply unless it is useful.

Thanks, {{sender_name}}

Compliance and deliverability cautions for event invites

Only invite people who have a reasonable relationship to the event or have consented to hear from you. Include opt-out handling where appropriate, avoid misleading urgency, do not hide commercial intent, test all links, respect Gmail/Workspace sending limits, and monitor bounces and replies. If the event includes attachments such as agendas or calendar files, test them carefully before sending broadly.

Event invite mail merge FAQ

Can I send event invitations from Gmail using Google Sheets?

Yes. A Gmail + Sheets mail merge workflow lets you use spreadsheet columns for recipient names, segments, event details, registration links, and RSVP status.

What fields should I include in an event invite Sheet?

Start with Email, First Name, Last Name and the Mail Merge status column in columns A–D, then segment, event name, date, time zone, personal reason, registration link, RSVP status, and internal notes.

How should I personalize event invitations?

Personalize the reason for the invite, the event topic, and the next step. Avoid fake familiarity or fields that may be inaccurate.

Should I send reminder emails?

Reminders can help when they are relevant and respectful. Send them to appropriate segments, suppress opt-outs and declines, and do not over-email people.

What should I test before sending an event mail merge?

Test the subject, merge fields, registration link, time zone, event details, signature, unsubscribe or opt-out language where applicable, and any attachments or calendar links.

Start your event invite campaign

If your guest list is in Google Sheets, use a focused Gmail mail merge workflow to send clear, personalized invitations and keep RSVP notes in the same spreadsheet.

Try Mail Merge for Gmail and Sheets →