{"id":17131,"date":"2025-01-13T16:53:59","date_gmt":"2025-01-13T07:53:59","guid":{"rendered":"https:\/\/84office.jp\/?p=17131"},"modified":"2025-01-13T16:54:00","modified_gmt":"2025-01-13T07:54:00","slug":"https-84office-jp-file-access-rights-change-batch","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/https-84office-jp-file-access-rights-change-batch\/","title":{"rendered":"Manage and Modify Spreadsheet Permissions in Bulk with Google Apps Script: The Update Guide"},"content":{"rendered":"
<\/div>\n

In the previous article<\/a>, we introduced how to list the access permissions of spreadsheet files.<\/p>\n\n\n\n

This time, we\u2019ll explain how to use the retrieved information to modify access permissions for multiple files in bulk.<\/p>\n\n\n\n

When managing multiple files in a business setting, manually updating the permissions for each file can be time-consuming. However, with this method, you can make changes to permissions all at once, saving both time and effort.<\/p>\n\n\n

\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t
\"\"<\/figure><\/div>\t\t\t\t\t
\n\t\t\t\t\t\tEffortlessly Manage and Modify Spreadsheet Permissions Using Google Apps Script: Preparation Guide<\/a>\n\t\t\t\t\t\tHave you ever struggled with the tedious task of reviewing and modifying sharing settings for individual files, such as spreadsheets or documents? This proce…<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n

Example Output<\/h2>\n\n\n\n

Listing Access Permissions (Previous Article)<\/strong><\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Bulk Modification of Access Permissions (This Article)<\/strong><\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Using the input data in the spreadsheet, this guide demonstrates how to use Google Apps Script to update the access permissions for each file.<\/p>\n\n\n\n

You can select the files that require changes and configure settings to grant or remove viewing or editing permissions for specific users.<\/p>\n\n\n\n

Steps<\/h2>\n\n\n\n

Preparing the Spreadsheet<\/strong><\/h3>\n\n\n\n
\n
STEP<\/span><\/div>
Open the Spreadsheet<\/strong><\/div>
\n
\"\"<\/figure>\n<\/div>\n\n\n

Prepare a sheet that lists the access permissions for each file.<\/p>\n\n\n\n

For details on how to list access permissions, please refer to [this article<\/a>].<\/p>\n<\/div><\/div>\n\n\n\n

STEP<\/span><\/div>
Mark Files for Modification<\/strong><\/div>
\n
\"\"<\/figure>\n\n\n\n

By checking the boxes in the “Change Target”<\/strong> column, you can specify which files will be targeted for access permission updates.<\/p>\n<\/div><\/div>\n\n\n\n

STEP<\/span><\/div>
Select New Permissions<\/strong><\/div>
\n
\"\"<\/figure>\n\n\n\n

Choose the desired type of access permission from the dropdown list.<\/p>\n\n\n\n

The dropdown list is generated during the previous execution of the Google Apps Script.<\/p>\n\n\n\n