In this article:

Send Google Forms Responses to Multiple Email Addresses (2024)

In this article, we will show you how to send Google Form responses to multiple email addresses. Simply follow the steps below:

Step 1: Connect Google Form Responses to a Google Sheet

Follow these steps to use Google Forms’ built in feature:

  1. Open your form in Google Forms
  2. Click Responses in the top bar
  3. Click on the spreadsheet icon in the top right
  4. Select Create a new spreadsheet
  5. Click Create. This will create a new Google Sheet

Step 2: Connect Google Form Responses Spreadsheet to Lido

You cannot send emails using Google Sheets.  We will use a free software calledLido to do this instead.  You can create a free account at:  

Then follow these steps:

  1. Create a fresh Lido file
  2. Next, click on 'Connect Data,' and opt for 'Google Sheets.'
  3. Paste the URL of the Google Sheet obtained in Step 1, which contains your Google Form responses.  You'll be prompted to log in to a Google account with access to that particular Google Sheet.
  4. Now, select the specific columns you want to import into Lido. Each column should correspond to a question from your Google Form. Make sure to choose all the columns you intend to include in your emails.

google form responses to multiple emails

Click Add Data. This will create a Lido table of your Google Form responses. 

Step 3: Write Email Templates

In this step we'll tailor our email content, including which details from the Google Form responses should be incorporated into our email.

Set up a new worksheet for your email templates.  Utilize the [@Column] syntax to reference various columns as variables. This method allows you to easily insert information from new Google Form responses directly into your emails.

google forms notifications to multiple emails

Step 4:  Configure Dynamic Emails

Next, let's connect our recently crafted templates with our form response table. Return to your table and add a new computed column named “Subject”.

google forms notify multiple emails

In the new column, enter the formula:


Replace Sheet1!$B$1 with the actual cell where the email subject template from step 3 is located.  

Create another computed column and do the same thing for email body:


Again, remember to replace Sheet1!$B$2 with the location of your email body template.

At this point, your table should appear as shown below. Observe how the variables [@Column] have been substituted with the real values from the corresponding form responses for each row.

google forms email notification to multiple emails

Step 5: Add SENDGMAIL Formula to Send to Multiple Email Addresses

We'll use Lido's special SENDGMAIL formula to send emails. The SENDGMAIL formula is:

=SENDGMAIL(<sender-credential>, “”, “subject”, “body”)

To send emails to multiple recipients at once, we use the ARRAY() inside of sendgmail.  For example:

=SENDGMAIL(<sender-credential>, ARRAY(“”, “”,”), “subject”, “body”)

Now let’s apply this to our example. Create a new computed column in your spreadsheet. 

In the second row of that column, put in this formula:

```=SENDGMAIL(<sender-credential>, ARRAY("", “”), E2, F2, H2)```

Make sure to replace the different cell locations in the formula with the actual cells in your spreadsheet. If you want one of the email recipients to be an email address from your form submission, you can reference that cell inside of the array without quotes around it.  For example:

```=SENDGMAIL(<sender-credential>, ARRAY("", B2), E2, F2, H2)```

Will send an email to both and the email address from cell B2. 

You should now have a column of SENDGMAIL Action formulas. Right click on the SENDGMAIL and Run action to send a test email.

You'll need to log in to the sender's email address the first time you use this feature. Ensure it's a Google email account and that it matches the email address you've mentioned in the formula.

Once the email is sent successfully, you'll notice a "success" message briefly appear in the cell. The cell you designated as the status cell will also be updated to display "success."

Step 6: Customize Email Trigger Logic for New Responses

Now we need to ensure that only one email is sent per new form response.  

First, add a Linked Column to your table to keep track of email sent status.  You will be prompted to choose an ID column; we recommend selecting Timestamp.  If you did not connect the timestamp column, you can click Edit data and go back to the data browser to add it. 

The location of your status column must be the same as the location specified in the status_cell for your SENDGMAIL formula (column H in this example).  Update your SENDGMAIL formula as needed.

Now we need to add an IF statement to our SENDGMAIL formula so that it only displays if an email has not already been sent for that response row. 

```=IF(H2<>”success”,SENDGMAIL(<sender-credential>, “”, E2, F2, H2))```

The SENDGMAIL formula will now only display if an email has not already been successfully sent.

Step 7: Create New Automation

The last step is to automate running all of the SENDGMAIL formulas in the column.  Click on the column header and select Run column on a schedule.

This will open the automation panel.  Select how frequently you want to check for updates.  On each automation interval, Lido will pull in your latest form submissions and send emails.  In this example we will select 15 minutes.

Click Save.  Then you are all set!

When a new Google Form response is submitted, Lido will automatically fetch the information and send emails to the multiple email addresses.

We hope this article has helped you to send Google Forms responses to multiple email addresses. You might also like our articles on how to send an email based on a response in Google Forms and send confirmation emails.

Get Google Forms productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->