---
title: "Quickly append file permissions in Google Drive with Google Sheets and Google Apps Script"
author: "Phil Bainbridge"
date: 2024-10-16T08:16:02+00:00
modified: 2024-10-16T08:26:43+00:00
canonical_url: https://pulse.appsscript.info/p/2024/10/quickly-append-file-permissions-in-google-drive-with-google-sheets-and-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2024/10/quickly-append-file-permissions-in-google-drive-with-google-sheets-and-google-apps-script.md
categories:
  - "Drive"
  - "No Code"
  - "Sheets"
  - "Solutions"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2024/10/Append20Drive20file20permissions20screenshot.png
description: "Phil Bainbridge has written this post with a Google Apps Script tool that simplifies the process of appending new permissions to existing files in Google Drive or Shared Drive. The solution is designed for users who already have a Google Sheet containing file IDs or URLs. Phil provides detailed instructions for using the tool, including how to make a copy of the Google Sheet, complete the required columns, and execute the script. All the script is included if you would like to modify it. The post includes some important caveats, such as avoiding the use of Smart Chips for Drive URLs."
---

# Quickly append file permissions in Google Drive with Google Sheets and Google Apps Script

![Quickly append file permissions in Google Drive with Google Sheets and Google Apps Script](https://pulse.appsscript.info/files/2024/10/Append20Drive20file20permissions20screenshot.png)

> Quickly append new permissions to existing files within Google Drive. Insert email addresses using a comma-space format with optional notifications.
> [https://www.pbainbridge.co.uk/2024/09/append-drive-file-permissions-tool.html](https://www.pbainbridge.co.uk/2024/09/append-drive-file-permissions-tool.html)Quickly append new file permissions via a Google Sheet

The following Google Apps Script tool allows you to quickly append new permissions to existing files within Google/Shared drive. This is quite a niche tool so it is anticipated you would already have a Google Sheet of file IDs/URLs, though there is the option to select an existing Drive folder of files and automatically bring them into this tool.

By inserting email addresses using a comma-and-space format you can optionally select to send a notification email to the new user(s)

You can continue to append further rows to the Google Sheet as existing ones will be skipped once the ‘Status’ column has automatically been marked as ‘Completed’. Alternatively you can clear the Sheet each time for a fresh start.

Source: *[The Gift of Script: Append Drive file permissions Tool*](https://www.pbainbridge.co.uk/2024/09/append-drive-file-permissions-tool.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2024/10/quickly-append-file-permissions-in-google-drive-with-google-sheets-and-google-apps-script/](https://pulse.appsscript.info/p/2024/10/quickly-append-file-permissions-in-google-drive-with-google-sheets-and-google-apps-script/)*