Sending an Email Automatically from a Google Forms Response

Google Forms does not include a built-in rule system for sending different emails based on a respondent’s answer, but you can still make it happen with a linked Google Sheet and a small Apps Script. This is useful when you want to send different follow-up messages depending on a choice in the form, such as support requests, event registrations, or internal approvals.

The method below is the most flexible option because it lets you inspect the form response and send the right email automatically. If you only need a simple confirmation message to every respondent, Google Forms and add-ons may be enough, but response-based email logic usually needs a script.

What You Need Before You Start

• A Google Form already created
• A linked Google Sheet for form responses
• Permission to use Google Apps Script
• An email account that can send messages through Google Workspace or Gmail
• A clear idea of which form answers should trigger which email

Set Up the Google Form and Response Sheet

1. Open your Google Form.
2. Make sure the question you want to use for email routing is clearly worded and uses consistent answer choices, such as Support, Sales, or Billing.
3. Go to the Responses tab.
4. Click the green Sheets icon to create or open the linked response spreadsheet.
5. Confirm that new submissions are appearing in the sheet.

Add the Email Logic in Google Apps Script

The script watches for new form submissions in the response sheet, checks the value from the chosen question, and sends a different email depending on the answer.

1. In the response spreadsheet, click Extensions, then Apps Script.
2. Delete any placeholder code in the editor.
3. Paste in a script that reads the latest form submission and checks the answer in the target column.
4. Update the question names and email addresses so they match your form and workflow.
5. Save the project.

Example Script for Sending Different Emails

The example below shows the general approach. You will need to adjust the column names, routing answers, subject lines, and message text to fit your form.

```javascript function onFormSubmit(e) { const responses = e.namedValues; const requestType = responses['Request Type'] ? responses['Request Type'][0] : ''; const email = responses['Email Address'] ? responses['Email Address'][0] : ''; if (!email) return; let subject = ''; let body = ''; if (requestType === 'Support') { subject = 'We received your support request'; body = 'Thanks for contacting support. Our team will review your request and reply soon.'; } else if (requestType === 'Sales') { subject = 'Thanks for your sales inquiry'; body = 'Thanks for your interest. A member of our sales team will follow up with you.'; } else if (requestType === 'Billing') { subject = 'Billing request received'; body = 'We received your billing question and will get back to you shortly.'; } else { subject = 'We received your form submission'; body = 'Thanks for submitting the form. We will review your response.'; } MailApp.sendEmail(email, subject, body); } ```

Create the Trigger so the Script Runs Automatically

A script like this will not run automatically until you attach an installable trigger.

1. In Apps Script, click the Triggers icon on the left side.
2. Click Add Trigger.
3. Choose the function name, such as onFormSubmit.
4. Set the event source to From spreadsheet.
5. Set the event type to On form submit.
6. Save the trigger and approve the permissions when prompted.

How to Route Emails Based on Different Answers

Once the trigger is in place, you can expand the logic to send different emails for different choices. Common examples include:

• A support form that sends one email for technical issues and another for account problems
• An event form that sends attendees different instructions depending on ticket type
• An internal request form that notifies different departments based on the selected category
• A lead form that sends tailored follow-up messages based on product interest

You can also send notifications to internal staff instead of, or in addition to, the respondent. For example, one branch can email your support team while another branch confirms the submission to the customer.

Testing and Troubleshooting

1. Submit a test response through the actual Google Form.
2. Check the linked spreadsheet to confirm the response arrived in the expected columns.
3. Review the Apps Script execution log if no email was sent.
4. Make sure the recipient address is being captured correctly from the form.
5. Confirm that the answer text in your script matches the exact form response, including capitalization and spacing.

If emails are not sending, the most common causes are a wrong column name, an incorrect trigger setup, or a mismatch between the form answer and the script’s comparison text. A missing or blank email field can also stop delivery.

When an Add-On May Be Simpler

If you only need a straightforward automatic reply, a Google Forms add-on can be easier than writing script. Add-ons are more convenient for simple confirmation emails, but they often have less flexibility than Apps Script when you need branching logic.

• Simple confirmation emails to every respondent
• Basic autoresponders with little or no customization
• Users who do not want to edit code
• Quick setups where response-based branching is not necessary

A Practical Setup to Remember

The easiest reliable workflow is: collect a clean answer in Google Forms, send responses to Google Sheets, use Apps Script to read the submitted row, and send the correct email with a trigger. That setup gives you the most control and works well for forms that need different follow-up messages.