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.

  • Welcome to Web Applications. Please show what you tried and add a brief description of your search efforts as is suggested in How to Ask. P.S. There is not an automatic built-in feature that does this, you might do it manually, using Google Apps Script, the Google Sheets API, an add-on, etc. May 23, 2021 at 15:02

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.