Jing jing-jin-mc

## Automate_User_Deletion.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                jing-jin-mc
                / Automate_User_Deletion.ipynb
            
            
              Created
              December 6, 2018 20:16
            
              
                Get Data from Analytics Reporting API, Connect Jupyter Notebook with Spread Sheet
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## user_deletion_api.gs
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]);

## Google_Drive.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                jing-jin-mc
                / Google_Drive.ipynb
            
            
              Created
              December 3, 2018 16:11
            
              
                Connect Jupyter Notebook with Google Sheet
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## Get_ClientID_List.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jing-jin-mc
                / Get_ClientID_List.ipynb
            
            
              Created
              December 3, 2018 11:36
            
              
                Google Analytics Reporting API
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
	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]);