Environment
U-M Google, Google Forms, Google Drive
Issue
How can I share Google Form responses and uploaded attachments with other people?
Resolution
Google Form responses and attachments (e.g., file uploads)are available only to the owner and collaborators by default.
- Both the owner and collaborators will have the ability to view and delete these form responses
- The form responses can be viewed from the "Responses" tab for the Google Form or from the associated Google Sheet used to capture the responses
- Similarly, the form attachments can be viewed from the "Responses" tab or from the associated Google Drive folder for storing the files uploaded by the respondents
- The form attachments are also linked in the Google Sheet used for responses; however, they can only be accessed if the Google Drive folder is shared as well
If someone should only be able to view the responses, then it will be best to share the associated Google Sheet and/or Google Drive folder for the Google Form per the instructions provided below. Please note that only the owner or collaborators with sharing permissions of the Form can perform these steps.
How to Share Google Form Responses:
- Select the "Responses" tab for the Google Form
- Click the Google Sheets icon near the top of the page to open the responses Google Sheet
- Click the "Share" button in the top-right corner of the Google Sheet
- Add the people you'd like to share the responses with and click "Send"
How to Share Google Form Attachments:
- Select the "Responses" tab for the Google Form
- Navigate to the attachment section of the Google Form responses
- Click "View Folder" in the top-right corner of the file upload section to open the Google Drive folder
- Click the folder name near the top of the page, then select "Share" from the menu
- Add the people you'd like to share the responses with and click "Send"
Additional Information
Note: The "Upload" option in Google Forms will not be available if the Form is stored in a Google shared drive. This means that there will be no ability to collect and share Google Form attachments.
More information on how to share files in Google can be found athttps://support.google.com/docs/answer/2494822?co=GENIE.Platform%3DDesktop&hl=en#zippy=
Need additional information or assistance? Contact the ITS Service Center.
FAQs
Navigate to the attachment section of the Google Form responses. Click "View Folder" in the top-right corner of the file upload section to open the Google Drive folder. Click the folder name near the top of the page, then select "Share" from the menu. Add the people you'd like to share the responses with and click " ...
How do I send file attachments to respondent after a Google Form is submitted? ›
Open the file in your Google Drive that you wish to send to your respondents as email attachments. Right-click the file and choose Get link to get the link to the file. Click Copy link and then Done. It is not necessary to share the file with anyone, the file can be private, visible only to you in Drive.
How to have Google Form responses emailed to multiple recipients? ›
Configure Notifications: Navigate to 'Settings' and select 'Email notification. ' Set Preferences: Enable 'Notify me' and add up to 5 email addresses in the 'Send copy' section to receive notifications and responses.
Can you export Google Form responses? ›
Yes, you can easily export Google Forms to Excel online. Go to Settings and set Excel as the default spreadsheet application on your PC. Using its charts and graphs, the spreadsheet app can help you extract insights into data gathered via online forms, such as Google Forms.
How to make Google Form responses public? ›
Click the Send option at the top right corner. A pop-up window will open, displaying all the sharing options, including email, link, and embedding. To make your Google Form public, choose the second option, which allows you to share your form as a direct link.
How can I share Google Form responses? ›
How to Share Google Form Responses:
- Select the "Responses" tab for the Google Form.
- Click the Google Sheets icon near the top of the page to open the responses Google Sheet.
- Click the "Share" button in the top-right corner of the Google Sheet.
- Add the people you'd like to share the responses with and click "Send"
To notify a respondent that their Google form submission has been received, thank them for their time, or send any other kind of message, you can automatically send them an email. As mentioned in the previous section, you'll find three tabs in the top bar of the form-building page in Google Forms.
How do I send a copy of Google Form responses to another account? ›
Open your form in Google Forms > Click More ⋮ icon > Click Add collaborators. Add editors screen will be displayed > Enter the email address > Click Send
- Sync responses to Google Sheets and add them as collaborators in Google Sheets (learn more)
- Send a copy of form responses as email to the collaborators (learn more)
Send Confirmation Email to Google Form Respondents
- Open your Google Form and launch the Form Notifications add-on.
- Click Email Notification from the Create menu to create a new workflow for sending automatic email notifications to the form respondent.
- Set the workflow name to, say, Respondent Notifications .
What's more, only you (the form's creator) will receive notifications. If you want your colleagues to receive notifications, you'll have to add them as collaborators in the form and then ask them to turn on email notifications.
Step 4: Save the Google Forms responses as a PDF
Click “Save.” You will be prompted to select a destination for the PDF you want to save. Once you've done that, all you have to do is press “Save.” You can now find a copy of all the responses in PDF format at your chosen destination.
How do I transfer Google Form responses to another Google Form? ›
If your form creates charts in your "Responses" section, you can copy and paste them into other files.
- Open a form in Google Forms.
- Click Responses.
- At the top right of a chart, click Copy .
- Paste the chart wherever you would like.
Choose where to save form responses
- Open a form in Google Forms.
- At the top, under “Responses,” click Summary.
- At the top right, click More. Select destination for responses.
- Select an option: Create a new spreadsheet: Creates a spreadsheet for responses in Google Sheets. ...
- Click Create or Select.
Steps to share Google Form responses
- Select the Responses tab.
- Click Link to Sheets.
- When you've made your selection, click Create.
- The spreadsheet will open in a new tab.
- Click the Share button.
- Add people by typing their names or email addresses.
Instead of adding your team members as collaborators in Google Forms, you can sync the form responses to Google Sheets and then add them as collaborators in Google Sheets. This will allow you to share google forms responses without edit permissions.
Are Google Form responses private? ›
If you don't add any identifying information to the form itself, then your respondents will remain anonymous. However, if you include questions that ask for personal information or email addresses, then those responses will be tied to specific individuals.
How do I send a message after submitting a Google Form? ›
You can customize the message people get after they submit the form.
- Open a form in Google Forms.
- At the top of the form, click Settings.
- Next to “Presentation,” click the Down arrow .
- Next to "Confirmation message," click Edit.
- Enter your message.
- Click Save.
Google Forms also has a file upload feature. Users can upload attachments such as presentations, spreadsheets, documents, PDFs, videos, images, and audio files directly into the form.
Can you edit Google Form responses after submission? ›
Form owners or collaborators can enable the edit after submit option in Google Forms to allow form respondents to edit the response they have submitted. When this option is enabled, an edit link will be included in the confirmation message shown after submit and the response receipt sent to their email.
