Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function share_links() {
- const ssId= SpreadsheetApp.getActive().getId();
- const urls = ["url1", "url2", "url3"];
- urls.forEach(url => {
- Logger.log(addImportrangePermission(ssId, getIdFromUrl(url)));
- })
- }
- function addImportrangePermission(ssId, donorId) {
- const url = `https://docs.google.com/spreadsheets/d/${ssId}/externaldata/addimportrangepermissions?donorDocId=${donorId}`;
- const token = ScriptApp.getOAuthToken();
- const params = {
- method: 'post',
- headers: {
- Authorization: 'Bearer ' + token,
- },
- muteHttpExceptions: true
- };
- return UrlFetchApp.fetch(url, params);
- }
- function getIdFromUrl(url) {
- return url.match(/[-\w]{25,}/);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement