The latest articles on DEV Community by misnome (@misnome). https://dev.to/misnome https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F600042%2Fcdb3c13d-4414-48e4-92cd-50e53a8c7ee5.png https://dev.to/misnome en misnome Fri, 19 Mar 2021 17:34:02 +0000 https://dev.to/misnome/how-to-prevent-viewer-using-app-script-to-get-values-from-shared-google-spreadsheet-especially-for-hidden-sheets-17ag https://dev.to/misnome/how-to-prevent-viewer-using-app-script-to-get-values-from-shared-google-spreadsheet-especially-for-hidden-sheets-17ag <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <h1> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7Gn-iPj_--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/66711890/how-to-prevent-viewer-using-app-script-to-get-values-from-shared-google-spreadsh" rel="noopener noreferrer"> How to prevent viewer using app script to get values from shared google spreadsheet, especially for hidden sheets </a> </h1> <div class="ltag__stackexchange--post-metadata"> <span>Mar 19 '21</span> <span>Comments: 2</span> <span>Answers: 0</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/66711890/how-to-prevent-viewer-using-app-script-to-get-values-from-shared-google-spreadsh" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Y9mJpuJP--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--wif5Zq3z--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>For shared spreadsheets, the permission has been set to viewer, and unticked the checkbox "Viewers and commenters can see the option to download, print, and copy". However, the viewer still able to get values by using App Script, for example function:</p> <pre><code>function grabValues(){ const ss = SpreadsheetApp.openById(sheetId) const sheet =</code></pre>… </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/66711890/how-to-prevent-viewer-using-app-script-to-get-values-from-shared-google-spreadsh" rel="noopener noreferrer">Open Full Question</a> </div> </div>