Advertisement
Namokonov

Untitled

Feb 3rd, 2022
1,293
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function share_links() {
  2.   const ssId= SpreadsheetApp.getActive().getId();
  3.   const urls = ["url1", "url2", "url3"];
  4.   urls.forEach(url => {
  5.     Logger.log(addImportrangePermission(ssId, getIdFromUrl(url)));
  6.   })
  7. }
  8.  
  9. function addImportrangePermission(ssId, donorId) {
  10.   const url = `https://docs.google.com/spreadsheets/d/${ssId}/externaldata/addimportrangepermissions?donorDocId=${donorId}`;
  11.   const token = ScriptApp.getOAuthToken();
  12.   const params = {
  13.     method: 'post',
  14.     headers: {
  15.       Authorization: 'Bearer ' + token,
  16.     },
  17.     muteHttpExceptions: true
  18.   };
  19.   return UrlFetchApp.fetch(url, params);
  20. }
  21.  
  22. function getIdFromUrl(url) {
  23.   return url.match(/[-\w]{25,}/);
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement