In this article:

How to Send Google Forms Responses to Another Email (2024)

In this article, we will cover how to send a copy of Google Forms responses directly to another email. 

Step 1: Connnect Google Form Submissions to Google Sheet

Google Forms offers a built-in feature to connect to a Google Sheet. Follow these steps:

  1. Go to the "Responses" tab
  2. Click "Link to Sheets"
  1. Select "Create New Spreadsheet"
  2. Click "Create

This will create a new Google Sheet that will populate with new Google Form responses.  Copy the Google Sheets URL.

Step 2: Connect Google Sheet to Lido to Send Emails

Google Sheets does not have native email notification functionality so we will use our product Lido to send emails.  There is a free tier with other paid pricing plans. You can create a free account here.

Create a new file in Lido.  Click Connect Data, then select Google Sheets.  Paste in the URL of the Google Sheet from Step 1 with your Google Form submissions.  The first time you connect you will need to login to a Google account that has access to the Google Sheet.  

Next, select which columns to import to Lido.  Each column should correspond to a Google Form question and you should select all of the columns that you wish to include in your emails.

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

Step 3: Create Custom Email Notification Templates

Now, let's make a template for the email that will be sent every time a new Google Form response is submitted.

Create a new worksheet in Lido .  Write your email subject and body templates, referencing different tables as columns using [@Column] format. 

how to get email responses from google forms

Step 4:  Connect Email Templates to Form Response Table

Next, we will link our newly created templates to our form submissions.  Go back to your table and create a new computed column for “Email subject”. 

google forms send copy of responses to email

In the second row of the new column (cell E2 in our example), enter the formula:


Make sure to replace this with the actual cell location of your email notification subject from the previous step. 

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


You should now have a table that looks like this.  Notice how the variables referenced with [@Column] are now replaced with the actual values from the form response for that row.  

Step 5: Add SENDGMAIL Formula to Send Emails to Another Email

We will use Lido’s SENDGMAIL formula to send our emails.  The formula is:

=SENDGMAIL(<sender-credential>, recipient, subject, body, status)

Here's what each parameter represents:

Sender credential: The email address from which the email will be sent

Recipient: The email address where the email will be delivered. This is where you put the other email that you want to send to.

Subject: The subject line of your email

Body: The content or message of the email

Status: The location of a spreadsheet cell that will be updated with the status of whether the email was successfully sent

Create another computed column.  Then enter this formula in row 2:

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

Since your data might look different than our example, it’s important to replace the cell references in the example properly.  Here is what each cell maps to in the formula:

E2: the location of your subject column

F2: the location of your body column

H2: the location of an empty cell to the immediate right of this new computed column


  1. To send a copy of the form responses to an email address that is part of the form submission (like the form submitter), then in the second argument instead of “” you can reference the cell location for the email address (e.g. C2).  
  2. To send to multiple recipients, you can use ARRAY(“”, “”, “”) in the second argument of the formula.  If one of those recipients should be a cell reference, you can include it with ARRAY(“”, C2, “”)

This creates a column of SENDGMAIL Action formulas. Action formulas only run when they are triggered either manually or via an automation.  To manually trigger an action, right click on the formula and select Run action.  Heads up that this will actually send an email!

google forms response email

After the email successfully sends, you will see a “success” message flash in the cell.  The cell you selected as the status cell will also now say “success”.

google forms email notification of each response

Step 6: Customize Email Trigger Logic

We need to add some logic to ensure that only one email is sent per form submission.  

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 Timestamp, since it will almost always be unique.  If you did not connect the timestamp column, you can click Edit data and go back to the data browser to add it or pick another column like email.

The location of your status column must be the same as the location specified in the status_cell for your SENDGMAIL formula.  In this example, it is column H.  If they are not the same, then update the SENDGMAIL formula to account for this.

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

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

As you can see, the SENDGMAIL formula now only displays if an email has not already been successfully sent.

Step 7: Automate Sending Emails

Now we need to automate triggering 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 notifications.  In this example we will select 15 minutes.

Click Save.  Then you are all set!

The automation starts running immediately, and emails for each new Google Form response will be sent to another email.

We hope you are now able to send your google forms responses to another email address by following the steps above! You might also like our articles on how to get email notification of each response in Google Forms and how to send custom emails based on responses.

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 ->