This blog will educate you on the actionable steps to send Google Form responses to multiple team members.
Table of Contents
How to send Google form responses to multiple emails with Google Sheet?
From Google form’s response section, click ‘Link to sheets, then choose ‘Select an existing spreadsheet’ and then get to the spreadsheet that receives the data and follow these steps to set the notification rules - Tools → Notification settings → Edit notification → Choose a user who submits a form under ‘Notify me at example@gmail.com when…’ → Choose ‘email straightaway’ under ‘Notify me with…’ → Click ‘Save.’
Step 1: Log into your Google Forms, Click the forms you plan to share, and collect the responses. Then, navigate to the ‘Response’ section.
Step 2: Click ‘Link to sheets’
Step 3: You can choose ‘Create a new spreadsheet’ to send the form responses to
or choose ‘Select existing spreadsheet’ to pick any of your already created spreadsheets to send form responses to.
Step 4: After choosing the spreadsheet to send the responses, share the spreadsheet link with your team members or people who want to get notified along with the responses when a user submits the form.
Step 5: Ask each person who will receive the form responses to ‘Set notification rules.’
This way, they’ll receive an email notification whenever someone submits the response to the form.
Here’s how you do it in Google Sheets,
Tools → Notification settings → Edit notification → Choose a user who submits a form under ‘Notify me at example@gmail.com when…’ → Choose ‘email straightaway’ under ‘Notify me with…’ → Click ‘Save.’
That’s it.
How to send Google form responses to multiple emails using an add-on?
Click the three dots at the top right corner of your Google Forms. Install the ‘Email notification for Google Forms add-on.’ Open the app. Create a notification. Add email addresses in the ‘To recipient’ box. Click ‘Continue’ and give ‘Save.’
Step 1: Click the created Google Form and navigate to the top right corner. You can see ‘3 dots’ near your Gmail profile icon. Click it.
Step 2: Click ‘Get add-ons’
Step 3: Search for ‘Email notification for Google Forms’ from the Google Workspace Marketplace.
Step 5:
Step 6: Click ‘Create’ from there and select ‘Email notification.’
Step 7: From the dashboard, give the ‘Notification name’ and mention the Sender’s name, email address, and reply-to-email address.
Then, scroll below, change the email message’s subject line and body copy if you want to, and click ‘Continue.’
Step 8: After clicking ‘Continue,’ you’ll reach the recipient section.
In the ‘TO recipient’ box, list all the people you must notify once the form is submitted.
Step 9: After mentioning all the email addresses, click ‘Continue’ and ‘Save and continue.’
Outcome: From now on, whenever people submit responses to your forms, the people you’ve mentioned in the ‘TO recipient’ will be notified about the form submissions and response data.
How to send GoZen Forms responses to multiple emails?
Create a GoZen form, navigate to ‘setting,’ click ‘email notification,’ and enable ‘Notify me.’ Under send copy, add email addresses to send the form notification along with the responses.
Step 1: Log in to GoZen Forms AI and create a form you’ll send to your respondents to collect the data. (You can use AI to finish this job quicker)
Step 2: From the form creation page, navigate to ‘Settings’ and click ‘Email notification’.
Step 3: Enable ‘Notify me,’ and under ‘Send copy,’ you can add 5 email addresses to send the form notification along with the responses.