Home › Automations › Send a confirmation email when a Google Form is submitted
Trigger: Form response receivedAction: Send email

Send a confirmation email when a Google Form is submitted

Stop checking the responses sheet. The moment someone submits your Google Form, Sheet Automation sends a confirmation email — to the respondent, to you, or both.

Add to Google Sheets — free See the template

Installs in 30 seconds · No credit card · Works inside Google Sheets

★★★★★ 4.9/5 · 500+ reviews · 300,000+ installs

What it does

This automation watches the sheet linked to your Google Form. When a new response row arrives, it sends an email built from the response values using placeholders like {column_B}. Use the respondent's email column as the recipient to send instant confirmations, or your own address to get notified of every submission.

How to set it up

  1. Install Sheet Automation from the Google Workspace Marketplace and open it from your form's response sheet.
  2. Pick the “Send email on form response” template.
  3. Set the recipient — use a placeholder like {column_B} to email the address the respondent entered.
  4. Save. Submit a test response — the email arrives within seconds.

The ready-made template

Send email on form response — Trigger: a form response is received → Action: send a confirmation email built from the response. Edit it live below:

Loading preview…

How to use this template

The builder above is a live preview of this automation. To run it in your own spreadsheet:

  1. Click Add to Google Sheets to install Sheet Automation (free).
  2. Open it from your sheet: Extensions → Sheet Automation → Open.
  3. Open the Templates tab and choose “Send email on form response”.
  4. Adjust the fields to match your data, then click Save.
  5. Trigger it once to confirm the automation runs.

FAQ

Can it email the person who submitted the form?
Yes. If your form collects an email address, reference that column as the recipient, e.g. {column_B}.
Do I need Zapier or an add-on for Google Forms?
No. Sheet Automation runs inside the response sheet itself — no third-party connector required.
Can the email include the answers?
Yes. Use {row_values} for the whole response or {column_A}, {column_B}… for individual answers.

Related automations

Send a feedback poll on form response Create a unique ID for a form response Lock a row after a form submission Send an email when a column is updated