How to Send Email Reminders for Google Forms Automatically

Learn how to set up automatic send emails reminders for events created in Google Forms. The personalized reminders are sent to people who have filled out a form, ensuring timely notification as the event date approaches.

You are using Google Forms to collect registrations for an upcoming event and would like to send email reminders to all the registered attendees a few days before the event date to ensure maximum attendance.

This tutorial explains how you can use Google Sheets and Document Studio for sending automatic reminders to all the registered attendees. We’ll primarily us Gmail to send the reminders via email but you can also use contact the event registrants via SMS or WhatsApp.

The reminders can be scheduled for any future date and time, and the email body can be personalized for each recipient. Let’s get started.

Google Sheets - Event Reminders

Prepare the Google Sheet

Assuming that you have already set up a Google Form for event registration, the responses will be collected in a Google Sheet linked to the form. In the same sheet, add a new column labeled Event Date and this will contain the event date. You can either copy and paste the date manually for all the rows in the sheet or use a formula to copy down the date automatically.

Create Email Reminder Workflow

Install Document Studio and launch it inside the sheet associated with your Google Form. Inside the app, create a new workflow and provide a descriptive name for your workflow. Choose the specific worksheet in your Google Spreadsheet that contains the form responses. Click on Continue to move to the conditions page.

In the Conditions section, you can define specific criteria and the workflow will only run for Google Sheet rows that meet these conditions. For instance, you may want to send a reminder email only to attendees who have paid the registration fee. By default, the reminder workflow will run for all rows in the Google Sheet.

Configure the Email Task

Google Sheets - Event Reminders

On the tasks screen, choose the Send Email task since we want to send email reminders to the registered attendees. The email task will use the data from the Google Sheet to personalize the email message for each recipient.

Select Gmail as the email service provider though you can also use SendGrid, Amazon SES or any SMTP server for sending emails.

In the Send Email to field of Recipients section, select the question in your Google Form that contains the email addresses of the attendees.

Next, specify the email subject line and message body for your event reminders. You can create a personalized email template by using dynamic markers enclosed in double curly braces. These markers get replaced with actual cell values in the Google Sheet, ensuring each recipient gets a tailored message.

Save the email message and proceed to the next step.

Google Sheets - Event Reminders

Schedule Email Reminders

On the Trigger screen, uncheck the Run on Form Submit option since we want to schedule the email reminders for a future date and not immediately after the form is submitted.

Next, check the Add a time delay option and schedule the workflow accordingly. For this example, we have set the workflow to run 3 days before the event date. It is important that the event date column in your Google Sheets is formatted as a date else the configuration for comparing the event date to the current date may not work.

Click the Save button to activate your workflow. The workflow is now running in the background and will automatically send emails near the scheduled date to all the registered attendees.

Schedule Email Reminders

Also see:

  1. Send email reminders with Mail Merge
  2. How to send appointment reminders via SMS
  3. How to send reminders for due invoices
Amit Agarwal

Amit Agarwal

Google Developer Expert, Google Cloud Champion

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory


Awards & Titles

Digital Inspiration has won several awards since it's launch in 2004.

Google Developer Expert

Google Developer Expert

Google awarded us the Google Developer Expert award recogizing our work in Google Workspace.

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards in 2017.

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional (MVP) title for 5 years in a row.

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator title recognizing our technical skill and expertise.

Email Newsletter

Sign up for our email newsletter to stay up to date.

We will never send any spam emails. Promise.