Skip to content

Instantly share code, notes, and snippets.

@jing-jin-mc
Created December 6, 2018 19:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jing-jin-mc/0a5d8af8efb6f40ac5801cebc21bc07f to your computer and use it in GitHub Desktop.
Save jing-jin-mc/0a5d8af8efb6f40ac5801cebc21bc07f to your computer and use it in GitHub Desktop.
function myFunction() {
var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = activeSpreadsheet.getSheetByName('Main');
var resultsheet = activeSpreadsheet.getSheetByName('Result');
var userInputs = sheet.getRange("A3:B").getValues();
var webPropertyId = String(userInputs[0][0]);
var numClients = userInputs[0][1]
for (var i = 0; i<numClients;i++){
var typeOfId = String(userInputs[2+i][1]);
var userId = String(userInputs[2+i][0]);
try {
var request = {
"kind": "analytics#userDeletionRequest",
"id": {
"type": typeOfId,
"userId": userId
},
"webPropertyId": webPropertyId
};
Analytics.UserDeletion.UserDeletionRequest.upsert(request);
resultsheet.appendRow(["'" + userId, 'yes']);
}catch(error) {
Browser.msgBox(error.message);
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment