What is the best way to include text in an editor access notification email?

I've developed a script to assign editors to a spreadsheet, but I'm looking to personalize the emails sent to them. The screenshot below illustrates the step where I can input a message for the email recipients who have been granted access.

    function send_emails(){
  var ss = SpreadsheetApp.getActiveSheet();
  var lr = ss.getLastRow();
  for (var i=1;i<=lr;i++){
    var ID = ss.getRange(i, 3).getValue();
    var MCP = ss.getRange(i, 4).getValue();
    var MCVP_1 = ss.getRange(i, 5).getValue();
    DriveApp.getFileById(ID).addEditors([MCP,MCVP_1]);
  }
}

https://i.sstatic.net/4ols0.png

javascriptgoogle-apps-scriptgoogle-sheetsgoogle-drive-api

Answer №1

If you want to enable this functionality, consider using the Advanced Drive Service in place of DriveApp

This option is linked to the Drive API and grants access to the Permissions: insert method.

Here's a sample code snippet:

function send_emails(){
  var ss = SpreadsheetApp.getActiveSheet();
  var lr = ss.getLastRow();
  for (var i=1;i<=lr;i++){
    var ID = ss.getRange(i, 3).getValue();
    var MCP = ss.getRange(i, 4).getValue();
    var MCVP_1 = ss.getRange(i, 5).getValue();
    var resource1 = {
      "role": "writer",
      "type": "user",
      "value": MCP
    }
    var resource2 = {
      "role": "writer",
      "type": "user",
      "value": MCVP_1
    }   
    var optionalArgs = {
      "sendNotificationEmails":true,
      "emailMessage": "This is my custom message"
    }
    Drive.Permissions.insert(resource1, ID, optionalArgs);
    Drive.Permissions.insert(resource2, ID, optionalArgs);
  }
}

Keep in mind:

Before executing the code, remember to manually activate the Advanced Drive Service.

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Deleting a record by sending an HTTP request and then removing the corresponding object from an array in Vue.js

After successfully solving this particular issue with the help of @nils, I have encountered a new question that I hope someone can assist me with! My current situation involves having a list of records from which I can select and remove items with just on ...

javascriptarraysvue.jsvue-resource

No receiving a callback_query update upon user pressing an inline button in the Telegram webhook

When using the node-telegram-bot-api library, I encountered an issue with my Webhook. Although I am able to receive updates when messages are sent, I do not get any updates when a user presses a button in an inline keyboard. class BotController { async ...

javascriptnode.jstelegram-webhooknode-telegram-bot-api

Using AJAX to create an interactive dropdown menu with changing options

I have been working on creating a dropdown menu using Ajax. When hovering over the navigation bar, the menu successfully triggers the Ajax function to display the dropdown options. The issue arises when attempting to navigate to another page (show_activi ...

javascripthtmlcssajax

Exploring Data within Data Structures

I am currently making two JSON requests in my code: d3.json("path/to/file1.json", function(error, json) { d3.json("path/to/file2.json", function(error, json2) { }); }); The structure of json 2 looks like this: [ { "city" : "LA", "locati ...

javascriptjsond3.js

MUI options - The specified type 'string' cannot be matched with type '"icon" | "iconOnly" | "text" | "outlined" | "contained" | undefined'

Is it possible to utilize custom variants in MUI v5? I am having trouble using a custom variant according to their documentation: https://mui.com/material-ui/customization/theme-components/#creating-new-component-variants declare module "@mui/material ...

javascripttypescriptmaterial-ui

JSON.Parse allows for graceful degradation of data when handling JSON objects in JavaScript

What should be done if a browser does not support JSON.parse? Would it be appropriate to include json.js and use parseJSON instead? Here's an example of how the code could look: var output; if (JSON.parse) output = JSON.parse(data); else ou ...

asp.netjavascriptjson

Verify that the images have been successfully loaded

I'm in the process of loading 8 images that all share a common class name. For example: <img class="commonClass" src="..." alt="" /> <img class="commonClass" src="..." alt="" /> <img class="commonClass" src="..." alt="" /> How can ...

javascriptjquery

How to Determine If a String Represents an HTML Tag Using jQuery

Checking if a string is an HTML tag can be tricky. I've tried various methods found on Google, but none have been successful so far: var v = $(string).html() ? 1 : 0; --or---------------------------------------------- var htmlExpr = new RegExp("/^( ...

javascriptjqueryhtml

Transferring parameters via URL - When passing single quotes, they are converted to &#39;

In my current ASP.NET project, we encounter an issue with passing parameters through the URL. Whenever a single quote is passed, the URL automatically changes all single quotes to %27 and the actual JavaScript value reads them as &#39; I need assistan ...

javascriptc#asp.net.net

Potential causes for Chrome to send duplicate requests

In my nginx server logs, I have the following entries (IPs and paths altered for illustration purposes): 101.101.101.101 - - [15/Apr/2020:14:46:03 +0000] "GET /item/download-file/ready/5e971e290107e HTTP/2.0" 200 142940 "https://example.com/referer" "Mo ...

javascriptgoogle-chromehttp

Wind - Best practices for managing the status of multiple entities within a single display prior to executing the save changes function

In my system, there are three main entities: Project, Attachment, and Messages. A project can have multiple attachments and messages associated with it. The issue arises on the project detail view, where I display the project's messages and any attac ...

c#javascriptangularjsbreeze

Utilizing React Javascript leaftlet library to implement functionality to zoom in on map using state

As a beginner in programming and leaflet, I've encountered a roadblock in my code. Check out my code snippet: import "./App.css"; import { MapContainer, TileLayer, Marker, Popup } from "react-leaflet"; import { useEffect, useState ...

javascriptreactjsleaflet

Unable to retrieve my Google Drive files using a service account

I am seeking to develop an application that enables users to add files to Google Drive and share those files with other users, such as [email protected]. The user [email protected] should be able to log in to the application and view and download ...

phpgoogle-drive-api

Create a JavaScript code snippet that replaces the innerHTML of the function document.getElementById with

In my limited knowledge of JavaScript, I have come across an issue with the following code: function example() { document.getElementById("example").innerHTML = "<script>document.write(example)</script>"; } Unfortunately, this code doesn&ap ...

javascripthtmlinnerhtml

Having trouble displaying child nodes in MatTreeView with Angular 14?

In an Angular project, I am attempting to display a private group's data from GitLab (utilizing a public one for testing purposes). To achieve this, I have implemented the NestedTreeView component. While the parent nodes are displaying correctly, I am ...

javascriptangulartypescriptangular-material

Unable to make changes to a file authored by a different user within Firestore using Vue.js / Firestore

I appreciate any assistance in advance, as this issue has been causing me a lot of frustration! Currently, I am adhering to the firestore data model where users are able to create their own documents associated with their userID. This ensures that users c ...

javascriptfirebasevue.jsgoogle-cloud-firestore

Elements that allow for asynchronous data submission without requiring a traditional submit button

Hey there, I could really use some help with this puzzle I'm trying to solve. Here's the situation: <ul> <li>Number: <span id="Number">123</span></li> </ul> I want to set up a connection between t ...

javascripthtmlangulartypescriptasynchronous

What is the best way to animate the preprending of a div in an AJAX response?

Here is the code I am currently working with: $.ajax({ type: 'POST', url: 'load_more.php', data: {val:myval}, success: function (data) { $("#load_current").prepend(data); ...

javascriptjqueryhtmlcssajax

Utilizing Redux state within _app.tsx in NextJS: A comprehensive guide

This snippet of code pertains to my _app.tsx file import '../styles/globals.css' import AppNav from '../components/AppNav' import type { AppProps } from 'next/app' import { store } from '../store' import { Provider } ...

javascriptreactjsreduxreact-reduxnext.js

Error 500 on Firebase: Issue solving "firebase" in "firebase.js" not resolved

Struggling to incorporate Firebase into my latest React project, I keep encountering the dreaded "The development server returned response error code: 500." Despite creating a firebase.js file to house my Firebase configuration details, I am at a loss as ...

javascriptreactjsfirebasereact-nativereact-native-firebase