Get an email with every answer the moment someone fills in your Google Form

Short answer: Use a free Google Apps Script that emails you each new Google Form entry with all the answers in the message, so you can reply straight to the person, and can send them a thank-you email too. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Link the form to a sheet; Make a Settings tab; Paste the script; Turn on alerts; What the alert looks like.

How to set it up

1. Link the form to a sheet. In your Google Form, open the Responses tab and choose Link to Sheets. If you want to reply from the alert or send a thank-you, include questions titled Name and Email.
2. Make a Settings tab. In the sheet, add a tab called Settings. In B1, put who gets the alert (leave it blank to send it to yourself). In B2, put the thank-you text for the person who filled in the form, or leave it blank for none.
3. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Form alerts menu appears.
4. Turn on alerts. Choose Form alerts, then Turn on alerts, and allow the permissions.
5. What the alert looks like. Each alert's subject is New form entry from the person's name, and it lists every question and answer, plus a link to the sheet. Hit Reply and your email goes to the person who filled in the form.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• Google Forms can already email you that a response came in, but without the answers. This puts them all in the email.
• For a form on your own website rather than a Google Form, see website form to Google Sheets.

Questions

What does this script do?

It is a free Google Apps Script that emails you each new Google Form entry with all the answers in the message, so you can reply straight to the person, and can send them a thank-you email too.

How do I set it up?

In 5 steps: 1. Link the form to a sheet; 2. Make a Settings tab; 3. Paste the script; 4. Turn on alerts; 5. What the alert looks like. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want this connected to the rest of your tools? Send us a short brief.