In this article:

How to Share Google Forms Responses (Easiest Way in 2024)

In this article we will show you how to share responses from google forms in just a few clicks. Simply follow the steps below.

How to Share Google Form Responses with Others

1. Click the Responses Tab

In Google Forms, you will see three tabs above the edit area. Click the Responses tab. The number of responses received by Google Forms appears alongside the tab label. In the image below it’s 14 for example.

How to share google form responses

You will get a summary of the responses displayed. You can check the responses before going to the next step. 

Google forms responses tab‍

2. Click Link to Sheets

In the Responses tab, you will see a Link to Sheets button in the upper-right hand corner. If you hover your cursor over it you will see the message Sends responses to a spreadsheet. Click it. 

How to share google forms responses

A box will appear saying Select destination for responses. You have two options: Create a new spreadsheet (the default option) or Select existing spreadsheet. We will stick with the default option, and click Create.

Create new spreadsheet to share google forms responses

A new tab will appear, loading the new spreadsheet containing the responses. 

Google sheets containing google forms responses‍

3. Share the Linked Sheet

You can now share the linked sheet. Click the Share button on the upper-right corner of Google Sheets. 

Google sheet share button

A box will appear. The users with access will be listed (which is only you), and a textbox is included for you to give access to other users via their Google accounts. 

How to share responses from google forms‍

To add the user, input their Gmail address to the text box, then click Send. You can add a custom message to the email that they will receive.

How to share google forms responses with others

The Google Forms responses have been shared via their Google account!

Google forms share responses

The user will get an automated email informing them that they now have access to the spreadsheet containing the Google Form responses.

Share google forms responses

We hope this article has helped you and given you a better understanding of how to share Google Forms responses. You might also like our articles on how to save Google Forms and how to check your submission history in Google Forms. To optimize your workflow better, we recommend reading our guide on implementing approval processes through Google Forms.

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