Let's say I'm collecting Name and Email (using Collect Emails setting), I wish to allow view-access to the Google Sheets Response Sheet linked to that form with only those who put their email id. Assume every email-id entered will be of Gmail.
How can I do it without manually putting emails in share option.
Google-sheets – How to give access of Response sheet linked with Google Form to only those who filled form
google sheetsgoogle-forms
Related Topic
- Google-forms – Pre-filled Google form with varying number of questions
- Google-sheets – How to block access to sheet in Google Sheets spreadsheet
- Google-sheets – Google Forms Quiz Response Sheet
- Google-sheets – Google Form response is modifying a cell on another row of linked sheet
- Google-sheets – way to allow users to access Google Sheets with installable triggers without manually signing in
- Google-sheets – Importing data into Google Form response sheet with date, list, grid
Best Answer
One easy solution would be to File > Share the spreadsheet as
anyone with link can view
. If you do not publish the link address anywhere, it will not be easily discoverable.You can then use one of the many mail merge add-ons to send an automatic response email to people who submit a form and include their email address. The email message would include the link to the spreadsheet, enabling those responders to open it and see all the responses. Others would not know the link address, and would therefore not have access.
To find a suitable mail merge add-on, choose Add-ons > Get add-ons and search for
mail merge
.