What is the easiest way to create a spreadsheet which is read only?

  • Profile Image
    NRS108
    Asked on November 28, 2017 at 09:11 AM

    Hello,

    I understand how to integrate a spreadsheet on Google Drive for all the responses which come in from a form. But is there a way to create and integrate the spreadsheet as "read only" and to make the spreadsheet available to anyone with the link without having to go directly to the spreadsheet to change all the settings there?

    Thanks.

    Sincerely,
    Neal

  • Profile Image
    Jan
    Answered on November 28, 2017 at 11:34 AM

    I recommend you check this Support Document from Google: https://support.google.com/docs/answer/1218656.

    This document will show you how to protect and set permissions to the spreadsheet. It also shows you how to hide or unhide a sheet.

    Hope that helps. If you have any questions, please let us know. Thank you.