Stop Manually Replying to Google Form Submissions — Automate It Instead

If you use Google Forms for registrations, surveys, or contact forms, you’ve probably run into this problem:

Someone fills out your form…
But nothing happens afterward.

No confirmation email.
No notification.

For businesses, this creates a bad experience.

Users expect email like:

“Thanks for your submission. We received your request.”

Fortunately, you can automate this completely using Google Apps Script connected to Google Sheets.

Once set up, every form submission will automatically trigger an email — without any manual work.

Let’s walk through the full process.

If you have any questions about this, please submit the form below.

See also: Mastering the Linux Command Line — Your Complete Free Training Guide

If you need a more advanced workflow, we can customize it for you.

---

How the Automation Works

The automation works through the following workflow:

1️⃣ Someone submits a form in Google Forms
2️⃣ The response is saved in Google Sheets
3️⃣ A script written in Google Apps Script detects the new submission
4️⃣ The script automatically sends an email

The result:

User submits form
        ↓
Google Sheets receives response
        ↓
Apps Script trigger runs
        ↓
Email sent automatically

This entire process runs in the background.

---

Step 1: Connect Google Forms to Google Sheets

First, open your form in Google Forms.

Then:

1. Click Responses
2. Click the Sheets icon
3. Create a new spreadsheet

Now every submission will automatically appear in Google Sheets.

For example:

Timestamp	Email	Name
2026-03-12	[email protected]	John

This spreadsheet is what our script will use.

---

Step 2: Open Google Apps Script

Inside the response spreadsheet:

1. Click Extensions
2. Click Apps Script

This opens the automation editor.

Google Apps Script is a scripting environment built into Google Workspace that lets you automate tasks across Google products.

---

Step 3: Add the Email Automation Script

Replace the default code with this script:

function sendEmailOnFormSubmit(e) {

  var responses = e.values;

  var timestamp = responses[0];
  var email = responses[1];
  var name = responses[2];

  var subject = "Thanks for your submission";

  var message =
    "Hi " + name + ",\n\n" +
    "Thanks for submitting the form.\n" +
    "We have successfully received your response.\n\n" +
    "Submission time: " + timestamp + "\n\n" +
    "Best regards.";

  MailApp.sendEmail(email, subject, message);
}

What this script does:

• Reads the form responses
• Extracts the email and name
• Generates a message
• Sends an email automatically

---

Step 4: Add a Form Submit Trigger

Next we tell the script when to run.

1. Click the Triggers icon (clock)
2. Click Add Trigger

Use these settings:

Option	Value
Function	sendEmailOnFormSubmit
Event Source	From spreadsheet
Event Type	On form submit

Now the automation is active.

Whenever a new form response arrives, the script runs instantly.

---

Step 5: Test the Automation

Submit a test response in your form:

Name: Sarah
Email: [email protected]

Within seconds, the user receives:

Subject: Thanks for your submission

Hi Sarah,

Thanks for submitting the form.
We have successfully received your response.

Best regards.

Your workflow is now fully automated.

A Small Automation That Saves Hours

A properly configured form workflow can save teams a surprising amount of time.

Instead of manually replying to every submission, the system handles it automatically.

For businesses that receive dozens — or hundreds — of form submissions per week, this automation becomes incredibly valuable.

Sometimes the simplest tools in the Google Workspace ecosystem turn out to be the most powerful.

---