How To Automatically Get An Email After a Google Form Submission?

Google Forms aims to simplify data collection, allowing you to easily collect all types of data, such as leads, customer inquiries, job applications, event registrations, and more.

But keeping track of incoming form responses? That’s not quite so straightforward!

Luckily, there are two ways you can receive automatic email notifications for your Google Form responses:

1. Use the built-in Google Form feature (for basic email notifications).
2. Insert an Apps Script (for custom email notifications).

Thanks to these handy email notifications, you’ll wave goodbye to manual follow-ups and missed responses, and say hello to smooth, clear communication so you never miss a beat.

So, how can you automatically get email notifications after a Google Form submission?

Read more: Can Google Forms generate an invoice?

If you simply want to receive a perfectly timed (basic) email letting you know once someone has filled out a form, this is the method for you.

Thanks to the Google Forms built-in email notifications feature, you’ll get notified with an email every time someone fills out your form.

Here’s how you can set it up in just four easy steps:

1. Open your Google Form.
2. Click the ‘Responses’ tab.
3. Select the three vertical dots at the top right of the Responses panel.
4. Select ‘Get email notifications for new responses’.

And that’s it! This sends an email to you (the form owner) each time a new response has been submitted.

While this is a perfectly fine solution for teams with just a few responses, it can be difficult to navigate through once you start receiving many form responses.

Plus, the email you receive is pretty basic, meaning most users must go back into the Google Form or Google Sheets spreadsheet for the finer details.

So, what if I told you that you could enhance these Google Form email notifications to make managing and reviewing many entries easier?

Read more: Can Google be used as a CRM?

In order to send personalized emails directly to your inbox after a successful Google Form submission, you must set up a Google Apps Script inside Google Sheets.

Follow the step-by-step process below to learn how: 

1. Go to Google Sheets.
2. Select ‘Tools > Create a form’ from the top menu.
3. Fill out and customize the Google Form.
4. Select ‘Responses’ and disable ‘Get email notifications for new responses’.
5. Go back to Google Sheets.
6. Click ‘Extensions > Apps Script’ to open up Apps Script.
7. Copy this code and paste it into Apps Script.
8. Save the script.
9. Click ‘Triggers’ on the left-hand side bar.
10. Select ‘Add Trigger’.
11. Choose the correct function you want to run (the sendEmailsUponFormSubmit’ function).
12. Under ‘Select event source’, click ‘From spreadsheet’.
13. Below ‘Select event type’, click ‘On form submit’.
14. Click ‘Save’.
15. Select ‘Allow’ from the pop-up window.

And that’s it! Now, when users submit a response, you’ll receive a detailed email including all the information from the form directly inside your inbox.

You no longer need to go directly to your Google Sheets spreadsheet or Google Form submissions and scroll through multiple form responses!

This method gives you so much flexibility.

You can edit the code to add more features to your email notification, such as styling, the Sheet URL, multiple email addresses or items, and more.

And get this: If you want to add more items to your form responses, you don’t need to even touch the code!

For a visual walkthrough of this process, check out this step-by-step video here.

Attention all Sheetify CRM users!

Did you know that Sheetify CRM has a new feature that automatically sends sales status updates and client task updates to your team?

Thanks to the built-in Apps Script, when you update a sales status or a client task within Sheetify CRM, the assigned team member will receive a personalized email notification!

Here’s how you can set this up inside Sheetify CRM:

1. Inside your Sheetify CRM template, select ‘Sheetify > Set Up Sheetify’ from the top menu.
2. Select ‘Enable Sales Email Notifications’ to enable sales notifications.
3. Go back to ‘Set Up Sheetify’ from the top menu.
4. Click ‘Enable Client Task Email Notifications’.
5. Go to the ‘Settings’ tab at the bottom of your spreadsheet.
6. Scroll across to ‘Team Email Notification Settings’.
7. Add your team members' names and their email addresses.
8. Go to the ‘Email Templates’ tab at the bottom of your spreadsheet.
9. Scroll down to ‘Email Notification Templates (Sales)’ and ‘Email Notification Templates (Tasks)’ and amend the email subject or body of the emails if you like.

And there you go! Now, every time you update a sales status or client task, an email notification will automatically be sent to the relevant assignee’s email address.

Check out this in-depth video guide on this process here. 

Want to know more about Sheetify CRM? Check out this comprehensive guide here.